I am stuck on this module from last 2 day but not getting how to get data correct my formule are correct
The image for data what i have got is below
@Brj73Look at the input data in the task. As I recall you have to fill in some values in order to test you calculations for matching
I have done that even after that there are are error
IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
As per this formula is correct, how you are input the data as you're getting the values. So you're correct only. Go-ahead.
the first image is the output we should get secong image is the one o got
1. Error here is ending inventory and beginning inventory is different for week 3 and week 4
2. Confirm purchase order is receipt value in week 4 is different
This module is always the tricky one for all learners. There were many questions in this forum regarding it.
I'd recommend you to go through some solutions from the past: Just click magnifier to search and type "inv01" as below.
I am sure you will find the answer there.
For example, here @filip.sypniewski gives good tips for this module: https://community.anaplan.com/t5/Anaplan-Platform/INV01-Line-Item-Formulas/m-p/85066/highlight/false#M18738
Looking at two screenshots I can say that calculated line items such as Final Shipment Amount and Shipping costs are not matching in values. Meaning you have to look through your formulas once again.
These are the formulas i have used
Final shipment amount :IF NOT Submit Purchase Order Request? THEN Suggested Order Amount for the Month ELSE Override Amount
Shipping cost : 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] / 1000 * Final Shipment Amount
I think here you need to change to
IF NOT Override suggested order amount? THEN Suggested Order Amount for the Month ELSE Override Amount
After applying the formula u told
The value i got for shipping cost is 532.6 and in lesson it is shown 529.7
And 2 error remains the same as mentioned above about ending and beginning invnetory
No, The formula in Final Shipment amount will be this one only:--
IF NOT Submit Purchase Order Request? THEN 0 ELSE IF NOT Override Suggested Order Amount? THEN Suggested Order Amount for the Month ELSE Override Amount
Because after submit purchase order request? only the override or suggested amount need to appear.