SNP aggregation issue

[aparna_ranganathan]

Hi Experts

Here is a scenario for which i need some help. We have multiple locations and these locations can be supplied by one or more distribution centers. The distribution centers need to be planned in APO, but the plants have to be MRP planned. So the scenrio is demand from multiple plants aggregating to distribution center A and demand from another bunch of plants aggregation to dc B. Apart from the demand from the plants the DC' also have their own demand .

I have maintained the hierarchy at material - DC level and I tried to plan the DC's using the SNP aggregate book. But the problem is DC's original demand gets overwritten with the demand from the individual plants. How do i overcome this issue. That is how do i make sure the aggregated demand is the sum of DC's original demand + demand placed by DC's on plants. I want to know if there is any straightforward way of achieving this before modifying the macros to the achieve the same.

Thanks

Saradha

Edited by: Saradha Ramesh on Sep 3, 2010 11:12 PM

[Former Member]

Hi Saradha,

I have a similar issue. So it would be interesting for me if You found a solution finally.

Thanks for feedback!

Heinz

[aparna_ranganathan]

Hello Heinz

I ended up modifying the stock balance macro - In the macro for initial stock calculation i put the logic similar to the template below

STOCK_CALC(<<demand>>; <<receipt>>;INITIAL_STOCK(version;product;location;'AGGR')   +

INITIAL_STOCK(version ;product ;location;)

The initial_stock with 'aggr' function would sum up the stock values for all child branches and the next initial stock function wihout 'aggr' will add the stock of the distribution center to aggregated stock value of child branches .

It has been working perfectly for us

[Former Member]

Hi Hi Saradha,

that's an interesting idea. Thanks for Your answer.

After my further investigations I suspect it also should work by setting the aggregation indicator in key figure detail view of the planning area to '3' or '4'.

Right now I did not prove it for the stock key figure.

Best regards

Heinz