L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks
Hello,
can you help me for find mistakes:
1. Begining inventory
2. And wrong result for shipping time weeks = 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product]
Here is my results:
I can't find misstakes. Everything seems correct.
Thank you.
Best Answer
-
were you able to solve your problem?
0
Answers
-
Check for the lesson of Sys01 module,may be you might have missed some formulas there in (Not first week of Timescale?)
0 -
No, i added this items:
0 -
okay, could you show the formula you used for beginning Inventory?
0 -
IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
0 -
As you see in screens, i've already write all formulas. But my data isn't correct
0 -
With Shipping Time Weeks - solved.
Beginning inventory - not clear. Please, help for solving.
0 -
I'm slill confised in 13 on 1st week, in all tables i see this number for this period (but in the lesson it is 13000). Where i have mistake?
0 -
Hey! I think you should check the lesson for DAT01 beginning Inventory cause the first value 13000 comes from there when you check the boolean is not true for that and you will be alright! You are almost there!!
0 -
Take your time and you'll understand the formula
0 -
I've solved it. Thank you a lot.
0 -
Can you tell me where was the issue, and how did you overcame it?
0 -
Of course, I find mistake for importing data01 into the hub model. And find mistake in formula.
0 -
Mistake in Formula in the Dat01 Module right?
0 -
Now - yes. I do import again.
0