L2 3.5.3 INV03 Stock Exceptions formula
Hello,
I have come across an issue with 'Stock Exceptions' and for some reason I get blank.
If I set the Summary method as Sum, then it works but the task clearly says it should be kept None.
I am attaching INV03, INV01 (source) and SKU08 if you can think if I did anything wrong there.
Comments
-
Yes you are right, When you keep the Summary as SUM it will auto Aggregate SKUs into Product Level but if the ask is to keep Summary as None then you will have to use another SUM function in the formula. Your formula should look like
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center] - If the summary is set to None
Hope that helps
Misbah
2 -
Very difficult to understand without screenshots. Please add screenshot if you could
First of all your Safety Stock Exception Count is wrong in INV01 but the Formula looks ok to me. Just rewrite it this way IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0
Second if you are not able to see the numbers in INV03 then I would certainly check SYS08 module to confirm if I have the DC mapping available there.
2 -
Here is my SYS08 module
Along with my INV01,INV03
0 -
Here it is
0 -
But we are asked to make it None in INV03 hence my whole confusion. Let me read the instructions again.
1 -
Change the context selectors to a specific SKU and a specific country.0
-
I'm having the same issue - I'm beginning to believe it's just a typo in the training
0