L2 3.3.5 Wrong result INV 01 for begining inventory and shiping time weeks

AntoninaYakovleva
Contributor

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

AntoninaYakovleva_0-1636980576124.png

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:

AntoninaYakovleva_1-1636980673239.png

I can't find misstakes. Everything seems correct.

 

Thank you.

 

1 ACCEPTED SOLUTION

Accepted Solutions
sobaid
Regular Contributor

were you able to solve your problem?

View solution in original post

16 REPLIES 16
sobaid
Regular Contributor

Check for the lesson of Sys01 module,may be you might have missed some formulas there in (Not first week of Timescale?)

AntoninaYakovleva
Contributor

No, i added this items:

AntoninaYakovleva_0-1636982132196.png

 

sobaid
Regular Contributor

okay, could you show the formula you used for beginning Inventory?

AntoninaYakovleva
Contributor

IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

sobaid
Regular Contributor
AntoninaYakovleva
Contributor

As you see in screens, i've already write all formulas. But my data isn't correct

AntoninaYakovleva_0-1636983610620.png

 

AntoninaYakovleva
Contributor

With Shipping Time Weeks - solved.

Beginning inventory - not clear. Please, help for solving.

AntoninaYakovleva
Contributor

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?

sobaid
Regular Contributor

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