3.3.5.2A Negative Balance in the Beginning Inventory

WilliamVERHILLE

Hello Everyone !

I have an issue in the Sprint 3 of the training level 2. In fact, my beginning inventory have a negative balance, as you can see in the following picture. However, my formulas seems good. I don't understand.

Can you help me ? Thanks, 😅

pyrypeura

Hi,

I would recommend to check formula for beginning inventory and how you get beginning inventory for the first week of the calendar. Your current if statement the previous ending inventory during first year of the model and beginning inventory otherwise. In pseudosyntax your formula in Beginning Inventory should say

IF First Week of Model? THEN Beginning Inventory Input ELSE PREVIOUS(Ending Inventory) .

Hope this helps 😊 Let me know if any questions or doubts.