Level 2 Conclusion INV05

AmalmMahmoudi · 2023-10-05T11:43:58+00:00

There was an error rendering this rich post.

AmalmMahmoudi

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 ?

Thanks!

Accepted answers

pyrypeura

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

All comments

pyrypeura

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

Tiffany.Rice

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

AmalmMahmoudi

Hi thank you @pyrypeura and @Tiffany.Rice for your help.

I changed the summary in inv01. final shipping costs to SUM and it works!

THANK YOU

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385