L2 INV01 Formulas

pjc95

Something is off on my formulas but I cannot figure it out since the differences in the screenshots below are so close.

 

My module:

 

Module from L2 3.3.7.2 

 Formulas:

• Beginning Inventory: IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
• Forecast Demand: 'DEM03 Demand Forecast'.Final Forecast
• Ending Inventory: Beginning Inventory + Confirmed Purchase Order Receipt - Forecast Demand
• Suggested Order Amount for the Month: MONTHVALUE(Forecast Demand)
• Final Shipment Amount: 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
• Shipping Costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]
• Final Shipping Costs: Final Shipment Amount * 1000 / 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Final Shipping Method]

Where am I going wrong?

ankit_cheeni

Your forecast demand for week 2 is different. Check why your value differs from Anaplan's in 'DEM03 Demand Forecast'.Final Forecast (maybe there is an override you need to clear)