Level 2 Sprint 3 - Inventory Ordering Module Formulas Module

Naivedya

Hi,

 

I have created the two boolean value but I am having problem while creating Beginning Inventory.

 

So can anyone please help me with the correct formula and data.

 

JaredDolich

@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