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

Saher
Saher
edited April 14 in Academy and learning discussions

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

3.3.3.5.png
formulas.png
sprint 3 issues.png

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.

Tagged:

Comments

  • BrunoRodriguez
    BrunoRodriguez

    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!

  • Saher
    Saher

    SYS08.png
    Screenshot (1).png

    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!

  • BrunoRodriguez
    BrunoRodriguez

    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!

  • Saher
    Saher

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

    SYSO7 Is populated.

    Screenshots attached.

    beginning.png
    SYS07.png

    THANKS

  • BrunoRodriguez
    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!

  • Saher
    Saher

    Hello BrunoRodriguez,

    DAT01.png

    DAT01 is populated. Find the screnshot.

  • BrunoRodriguez
    BrunoRodriguez

    Hello @Saher ,

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

    Cheers

  • Saher
    Saher

    Greetings!

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

    Have a look on screenshot.

    Thanks.

    Screenshot (2).png

  • Venki9902
    Venki9902

    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

  • Saher
    Saher

    Hello Venkatesh

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

    Thanks

  • Venki9902
    Venki9902

    Hi @Saher ,

    which line items data is not matching now.

    Regards,

    Venkatesh

Categories