INV01 SPRINT 3 ISSUE

HI Team,

 

I have few issues with the formula, its right or wrong? i have noticed 3 issues in my model 

 

1. For Beginning inventory my formula is 

IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

here in week 2 of beginning inventory, it's displaying the same beginning inventory as week 1

 

2. Reorder flag my formula 

OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

 

it's not changing for week 6 because beginning inventory is the same for all weeks 

 

3. shipping weeks my formula 

'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

 

It's showing on 1 in place it should show 2 for roads 

 

 Screen Shot 2021-05-08 at 3.01.58 pm.pngScreen Shot 2021-05-08 at 3.02.10 pm.png

 

 

can anyone help me where am going wrong! and is my formula right or wrong?

Answers

  • Hi @harishroshan 

     

    1. For Beginning inventory

    IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory.

    The formula written is close but needs a little tweak in the first part :- Instead of 1st forecast year you need to use "Not 1st week of Timescale" as data has to be identified and fetched through a conditional statement  based on weeks .

     

    2. Reorder flag my formula

    OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0

    Seems Right.

     

    3. shipping weeks 

    'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]

    Shipping Time weeks is calculated based on the products and the type of  Shipping method used for the respective products. The formula is close, add shipping methods to find the right shipping time.

     

    ~ABhi

  • Thank you @abhi1017 i got solutions am in next step