Level 2 Conclusion INV05

AmalmMahmoudi
AmalmMahmoudi
in Academy Discussions

Hello, i am trying to create the formula for INV05.

Capture.PNG

But I am getting 0 for "Shipping Costs" .

results.PNG

Here is the formula that i am using :

'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Supplied By]

formula.PNG

and this is my INV01 Inventory Ordering

final ship costs.PNG

Can anyone help me please ?

Thanks!

Best Answers

  • pyrypeura
    pyrypeura
    Answer ✓

    Hi, If you turn summaries on for Final Shipping Costs you will have numbers flowing through to your export model.

  • Tiffany.Rice
    Tiffany.Rice
    Answer ✓

    @AmalmMahmoudi - double check the line item time summary methods in INV01. That module is dimensioned by the weekly time scale whereas INV05 is monthly. This is the key instruction that you may have missed: "Review the Summary Method settings"

    If you do not have time sum enabled on the Final Shipping Cost line items then downstream formulas based on month will return $0 (see the highlights in the screenshot below).

    image.png

Answers

Categories