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

Saher
Saher
edited April 2023 in Academy 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:

Answers

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

    Kind regards,

    Bruno Rodriguez

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

    Kind regards,

    Bruno Rodriguez

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

    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!

    Kind regards,

    Bruno Rodriguez

  • 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

    Kind regards,

    Bruno Rodriguez

  • 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