Skip to Content

Planning distribution function

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,

Tomas.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    regards

    Cornelia

    Add comment
    10|10000 characters needed 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,

      Tomas.