Level 2 Model Building Sprint 3 3.3.5Activity :Create Inventory Ordering.

edited April 14 in Academy Discussions

Hello! I'm stuck in 3.3.5 Activity which is to

Create Inventory Ordering. I am facing multiple issues like

1.In begining inventory from week 5 data is incorrect.

2. Reordering flag is not there in week 5

3. Shipping methods are not visible although I've put formula there

4. Shipping time weeks are not showing any data

5. Ending Inventory from week 5 is wrong

I don't know what I've done wrong .It would be great if anyone can help me with this, attaching the screenshot and the module that I have created according to my understanding.


  • Hello @Saher ,

    I believe your summary in "Beginning Inventory" is incorrect. It should be None, Time: Closing Balance. That is the reason why the 13k appears all over the place.

    As for shipping method, do you have the data populated in 'SYS08 SKU Details'.Supplied By?


    Kind regards,

    Bruno Rodriguez

  • Hi BrunoRodriguez,

    Firstly, Summary for Beginnig inventory should be in SUM, TIME Opening Balance as mentioned in activity.

    I don't know why the same values are showing all over again

    Secondly, Data is populated in SYS08.

    Screenshots are attached for your asssistance.


  • Hello @Saher ,

    Can you remove your LOOKUP from Beginning Inventory?

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

    SYS07 is populated too?


    Kind regards,

    Bruno Rodriguez

  • BrunoRodriguez, After removing Lookup, begining inventory is showing in negative values.

    SYSO7 Is populated.

    Screenshots attached.


  • BrunoRodriguez
    edited April 13

    Hello @Saher ,

    What do you have in DAT01? It seems like the content is 0?

    Also, why does New Your not have a shipping method?


    Kind regards,

    Bruno Rodriguez

  • Hello BrunoRodriguez,

    DAT01 is populated. Find the screnshot.

  • Hello @Saher ,

    Can you populate New York in SYS07 with Road in default shipping and let me know the result?


    Kind regards,

    Bruno Rodriguez

  • Greetings!

    I've populated New York in SYS07 now but still results are the same.

    Have a look on screenshot.


  • Hi @Saher

    Can you try this formula for re-order flag:
    OFFSET(Ending Inventory, Shipping Time Weeks, 0) < 0 and for shipping method: IF NOT Override Shipping Method? OR ISBLANK(Override Method) THEN Shipping Method ELSE Override Method

    Hope this helps:)



  • Hello Venkatesh

    I appreciate your help but I've already used these formulae but still issues are the same.


  • Hi @Saher ,

    which line items data is not matching now.