3.3.5.2A Negative Balance in the Beginning Inventory

WilliamVERHILLE
WilliamVERHILLE
edited March 2023 in Academy Discussions

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.

Capture11.PNG
Capture.PNG
Capture1.PNG

Can you help me ? Thanks, 😅

Answers

  • pyrypeura
    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.

  • WilliamVERHILLE
    WilliamVERHILLE
    edited March 2023

    Ok many thanks

    but I think I have still an issue because now the beginning inventory remain the same week after week 🤔

    How it is :

    image.png

    How it should be (according the example in the level 2 activity) :

    image.png

  • WilliamVERHILLE
    WilliamVERHILLE

    Problem solved, I have use the wrong line item. Thanks !

  • Jogesh1449
    Jogesh1449
    edited September 2

    Hello,

    Can someone help with shipping time weeks formula
    'TRA01 Shipping Metrics by Week'.'Shipping Time (Weeks)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method]

    I'm not getting an error but there is no data which is being displayed.

Categories