I am having multiple issues with the formulas in the Inventory Ordering Module.
First of all, I don't understand why I Have 0 as Beginning inventory for Nutzo Bar_En with the formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
I checked the DAT01 table and the value for New York location and the inventory there is 13000, so not sure why that is not captured.

For Forecast Demand I used the Formula 'DEM03 Demand Forecast'.Final Forecast and that also provides incorrect answers. I also noticed some really strange behaviour in the DEM03. How can the Final forecast be zero when it has not ben overriden? What could be the cause to this?

Lastly, the shipping time is incorrect based on the default mode of transportaton. I use the formula 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] and value is zero, although it should be 2 weeks according to DAT02 Shipping metrics.

Here is a screenshot on all of my formulas etc. in the module for reference.

Would appreciate input on all of the above 🙂