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?
IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
Go to Solution.
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?