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

Saher

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

3.3.3.5.png

Uploaded Apr 12, 2023391.01 KB

formulas.png

Uploaded Apr 12, 2023112.04 KB

sprint 3 issues.png

Uploaded Apr 12, 202361.48 KB

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.

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

SYS08.png

Uploaded Apr 13, 2023106.16 KB

Screenshot (1).png

Uploaded Apr 13, 202353.71 KB

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

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

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

SYSO7 Is populated.

Screenshots attached.

beginning.png

Uploaded Apr 13, 2023107.35 KB

SYS07.png

Uploaded Apr 13, 202366.04 KB

THANKS

BrunoRodriguez

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

Hello BrunoRodriguez,

DAT01.png

Uploaded Apr 13, 2023149.49 KB

DAT01 is populated. Find the screnshot.

BrunoRodriguez

Hello @Saher ,

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

Cheers

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

Uploaded Apr 14, 2023101.03 KB

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

Hello Venkatesh

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

Thanks

Venki9902

Hi @Saher ,

which line items data is not matching now.

Regards,

Venkatesh