MB - L2 - S3 - 3.3.5.2 Inventory Ordering Module Formulas

Hi Everyone,

Could you please help me to compete activity 3.3.5.2. I am struggling with the missing formulas in the screen shot. I will really appreciate if someone can help to resolve these formulas. Also please let me know if all other formulas are correct.

Screenshot 2022-03-05 at 22.20.50.png

Thanks

JH

Tags

Modeling

Accepted answers

Hi @zaibhamid81 ,

First off, all of the formulas you already have there do look correct from what I can tell.

For Shipping Time Weeks: You should be able to reference the same line item within your TRA01 module, but you will need to use lookups to figure out the SKU's Product, and also to figure out the Shipping Method.

For Confirm Purchase Order Receipt: You need to check if the Confirmed PO Delivery is non-zero, in which case you should be pulling in the suggested order amount in the final shipping time (weeks).

Sorry to be purposefully vague, just trying to give you some hints without spelling out the formulas... let me know if that does help nudge you in the right direction or if you need more detail.

Thanks,

Timmy

All comments

Hi @zaibhamid81 ,

First off, all of the formulas you already have there do look correct from what I can tell.

For Shipping Time Weeks: You should be able to reference the same line item within your TRA01 module, but you will need to use lookups to figure out the SKU's Product, and also to figure out the Shipping Method.

For Confirm Purchase Order Receipt: You need to check if the Confirmed PO Delivery is non-zero, in which case you should be pulling in the suggested order amount in the final shipping time (weeks).

Sorry to be purposefully vague, just trying to give you some hints without spelling out the formulas... let me know if that does help nudge you in the right direction or if you need more detail.

Thanks,

Timmy

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
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