3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue

nikhilbharadia
nikhilbharadia
edited November 2022 in Modeling

I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

nikhilbharadia_0-1667819615626.png

However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE 'DAT01 Beginning Inventory'.Beginning Inventory. So Please guide what is the issue with this.

nikhilbharadia_1-1667819776260.png

 

 

Tagged:

Answers

  • jagadishdash
    jagadishdash
    edited November 2022

    @nikhilbharadia 

    As you written formula everything is looks fine.

    Check with your DAT01 module, there beginning inventory must be 13000 for Nutzo bar __ Newyork AND

    SYS01 module's not 1st week timescale? is it coming correctly the check box or not!

     

    If above everything is fine and still facing the issues let me know.

     

    Thanks,

    Jagadish Dash

  • nikhilbharadia
    nikhilbharadia
    edited November 2022

    Yes everything is correct, DAT01 is autopopulated by system itself. When I apply just 2nd part of the formula individually it takes the values properly of beginning inventory but it's not working with If then formula. 

Categories