Inventory Ordering Module Formulas



From 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.





  • @SupriyaH 

    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.




  • Hi @JaredDolich

    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.



    Thank you

  • 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

    Any suggestions?
    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 on
  • trenttheising1
    edited February 8

  • shlokhan
    edited March 29

  • @ArthurRobbe what was the mistake, I am having same issue.