Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

ismaelmaclovio
ismaelmaclovio
in Modeling

Hello everyone,

 

I get an error when I try to add this formula to the Beginning Inventory Line Item. I'm not sure why I get the error. Can someone help me out with this?

FORMULA:

IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

Thank you.

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @ismaelmaclovio 

    Your formula is exactly correct. So take a look at SYS01 and make sure the line item is there and spelled the same way and has the following formula.

    'NOT First Week of Timescale?' = NOT First Week of Timescale?

Answers

Categories