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
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!