IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory.
The formula written is close but needs a little tweak in the first part :- Instead of 1st forecast year you need to use "Not 1st week of Timescale" as data has to be identified and fetched through a conditional statement based on weeks .
2. Reorder flag my formula
OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0
3. shipping weeks
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
Shipping Time weeks is calculated based on the products and the type of Shipping method used for the respective products. The formula is close, add shipping methods to find the right shipping time.