Skip to Content

Planning distribution function

Jan 12 at 11:50 AM


avatar image

Hi experts,

we are trying to upload a total amount for whole year to # posting period and then distribute it equally to 1-12 posting periods.

The thing is that first upload function is set to Overwrite data so we are sure to have there always only year total.

BUT, then distribution function is not Overwriting the figures in 1-12 but it is always adding new amount to old amount, we want to save there only new amount.

We tried to run Delete function before running Distribution function but we delete all combinations not only those coming in CSV file.

We tried to run "initial" distribution function to distribute 0 to 1-12 periods with factor = 0, but system is throwing an error.

Somebody was facing this problem?

Many thanks,


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Cornelia Lezoch Jan 16 at 11:52 AM

Hi Tomas,

your "Upload" needs to be a planning function defined on an aggregation level, that does not include 0FISCPER3.

By this, the aggregation level aggregates the period values to a yearly value and does the "overwrite". any differences are then written to period = # and can afterwards be distributed.



Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Cornelia,

many thanks, your idea works great!

I created one AL for upload (without 0FISCPER3) and then second AL for distribution (contains 0FISCPER3), then I used them in one planning sequence and it works and after distribution function, only the amount uploaded via CSV file is allocated to 1-12 periods.

Many many thanks for your time and help!

Wishing a wonderful day,