220.127.116.11 Inventory Ordering Module Formulas
From 18.104.22.168 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks.
Beginning Inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
Shipping Time Weeks - 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
Please refer below screenshots and let me know the correction needed.
Syntax looks good. Check your DAT01 to make sure the data is loaded. It looks like your first week isn't showing up. Also, make sure INV01 is dimensioned with SKU and DC. Looks like you only have SKU.0
I am having data in Beginning inventory. also dimensions are same as you mentioned.
It is not showing any weeks data. Currently the negative data is populated because of ending inventory. Please check below screenshot once and help me resolve the same.
Hi good afternoon,
When writing the formula for Beginning Inventory, I have an error message that 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' is not recognized as a line item
Thank you in advance for your helpc,
Just found my mistake,
I don t know why but my module SYS01 was not completed as the one I took example on0
@ArthurRobbe what was the mistake, I am having same issue.0