Level 2  Sprint 3  3.3.5.2 Inventory Ordering Module Formulas
Options
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:
0
Best Answer

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?
3
Answers

@JaredDolich
Thank you once again. I realized that I was missing 2 line items so I added them and inserted the formula and it worked.1 
HI
I have the same problem, how did you add two lines items and what are those line items?
Can you help me, about that?
0