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

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.

Comments

  • 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?

    Cheers!

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

    Thanks!

  • 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?

    Cheers!

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

    SYSO7 Is populated.

    Screenshots attached.

    THANKS

  • 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?

    Cheers!

  • 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?

    Cheers

  • Greetings!

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

    Have a look on screenshot.

    Thanks.

  • 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:)

    Regards,

    Venkatesh

  • Hello Venkatesh

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

    Thanks

  • Hi @Saher ,

    which line items data is not matching now.

    Regards,

    Venkatesh