3.3.7.2 Add DCA to INV01 Inventory Ordering

Yosr · 2024-08-13T11:13:26+00:00

There was an error rendering this rich post.

Hi, I am encoutering several issues with this module compared to the screenshot i have from the training!

Fisrtly, the fisrt value for week, the suggested Order Amount for the Month does not appear!
Additionally, the shipping costs values, Final Shipping time weeks, Final Shipping costs Shipping Cost Varianvce are different!
Any help ? thank you!

Accepted answers

Rajat26

Hi @Yosr

I can see that you have made an error in your Final Shipping Costs formula you have referred

Shipping Time (Weeks) instead of Cost per 1000 Units. The correct formula would be

'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method] * Final Shipment Amount / 1000

Hope this helps!

All comments

Rajat26

Hii @Yosr

As far as the DCA is concerned here is the read and write access you are supposed to give

And for the values which you are getting wrong I think you have made an error in your formula, can you send a screenshot so that I can help you.

Yosr

Thank you for answering! For DCA it works perfectly, yes, thank you for your help.

This is my formula :

Final Shipping Costs : Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

Shipping Cost Variance :`IF NOT Override Shipping Method? THEN 0 ELSE Shipping Costs - Final Shipping Costs`

Rajat26

Hi @Yosr

I can see that you have made an error in your Final Shipping Costs formula you have referred

Shipping Time (Weeks) instead of Cost per 1000 Units. The correct formula would be

'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method] * Final Shipment Amount / 1000

Hope this helps!

Yosr

Hi !

Thank you for answering! that was very helpful, it works!

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
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.…