Level 2 Sprint 3 - Inventory Ordering Module Formulas Module

@Naivedya 

Hi there. You're doing great. 

In this line item, we are trying to create an inventory balance set where the beginning on hand is equal to the previous ending on hand. All but one week will work this way except the first week because there isn't a previous ending on hand. So we need two strategies:

1. Set our IF statement so that the most common occurrence is first. In this case since all but one week will use the previous ending onhand we will check to see if the week is not the first week. That's why we created the line item in SYS01.
2. On the first week we need to lookup the beginning on hand which will be imported from a file. We can find that value in DAT01.

So, our formula for beginning on hand should look like this:

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

@Naivedya 

good job! You got it. You just haven't loaded DAT01 yet. Nice job!

@Naivedya 

Check your SYS01 and make sure the first week of 2020 is being identified correctly.