kaadarsh1992
Occasional Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

@kaadarsh1992

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.

可选地,您可以和产品(SYS08)但是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.

inv03.png


Jared Dolich

View solution in original post

3 REPLIES3
kaadarsh1992
Occasional Contributor

Anaplan sprint 3.PNG

JaredDolich
Moderator

@kaadarsh1992

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.

可选地,您可以和产品(SYS08)但是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.

inv03.png


Jared Dolich
kaadarsh1992
Occasional Contributor

I am getting it now..Thanks a lot for your detailed explanation@JaredDolich!