Data not matching In inv01 inventory ordering

Options

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

Tagged:

• Options

@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

• Options

I have done that even after that there are are error

• Options

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.

• Options

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

• Options

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

• Options
I have searched i did not get anything
• Options

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.

• Options

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

• Options

I think here you need to change to

IF NOT Override suggested order amount? THEN Suggested Order Amount for the Month ELSE Override Amount

• Options

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

• Options

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.