Level 2 Sprint 3 INV03 Distribution center Summary
Line item 'stock exception' formula -
I have summed safety stock exception line item of a major module based on 'supplied by' line item of a system module (I have used only one sum parameter.
As per the training program, we are instructed not to use any summary method.
However, I am getting the results only when i use summary method 'sum'.
Please advice.
Answers
-
Good call out - you're on the right track. Let's re-read the use case.
You need to "SUM" the exceptions in INV01.
Since INV01 uses P3 SKU and INV03 uses P2 Product and G3 DC (sublist) you must supply a SUM on DC (SYS08 - supplied by) at a minimum.
Optionally, you can SUM on product too (SYS08) but it's not necessary since you already defined the relationship in the structured hierarchy.
And, as you can see, a summary method is not needed.
10 -
I am getting it now..Thanks a lot for your detailed explanation @JaredDolich !
0