Level 2 Conclusion INV05


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

But I am getting 0 for "Shipping Costs" .

Here is the formula that i am using :

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

and this is my INV01 Inventory Ordering

Can anyone help me please ?


Best Answers

  • pyrypeura
    Answer ✓

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

  • Tiffany.Rice

    @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).