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!
1 -
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!
0 -
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!
0 -
BrunoRodriguez, After removing Lookup, begining inventory is showing in negative values.
SYSO7 Is populated.
Screenshots attached.
THANKS
0 -
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!
0 -
Hello BrunoRodriguez,
DAT01 is populated. Find the screnshot.
0 -
Hello @Saher ,
Can you populate New York in SYS07 with Road in default shipping and let me know the result?
Cheers
0 -
Greetings!
I've populated New York in SYS07 now but still results are the same.
Have a look on screenshot.
Thanks.
0 -
Hello Venkatesh
I appreciate your help but I've already used these formulae but still issues are the same.
Thanks
0