Level 2- Sprint 3- INV01 Question

jingru
jingru
edited January 2023 in Academy Discussions

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