Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

ismaelmaclovio
Contributor

Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

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.

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

@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?


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

@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?


Jared Dolich

View solution in original post

ismaelmaclovio
Contributor

Re: Level 2 - Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas

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