Level 2- Sprint 3- INV01 Question

Options
jingru
jingru Member, ALL USERS, GroupMember, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

Could anyone help me with the questions below?

 

1. My Beginning Inventory is not showing correctly with the effect of ending inventory, it shows the same number, please see the attached screenshot. 

My formula is

IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

SPRINT 3.png

 

2. My shipping method is not showing data. I don't know which part of my mapping is wrong, I hope someone can help. My formula is 

'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code]

 3. I am not very confident with my Confirmed PO Delivery formula, it is not showing data too.  Mine is:

POST(PO Submitted, Shipping Time Weeks)

 

Thank you so much!

Tagged:

Categories