Allocation process with Booking Account in SAP Analytics Cloud

[etienne1110]

Hi Experts,

I've a simple allocation case where I want to allocate the cost of a few cost centers (9010, 4000, 4020, 06-TF) to other cost centers.

In order to differentiate direct cost and allocated cost, I created different account type : EXPENSES where I have my original direct cost for every cost center & ALLOCATION where I have my allocated cost (IN type for receiver cost centers and OUT type for sender cost centers) regarding sender cost centers . Finally I sum the two of them with a TOTAL account on top.

account-hierarchy.png

For each cost center to allocate, I created two steps:

1. To allocate cost of one cost center to other cost center in the booking ALLOCATION_IN account of the sender cost center 1st-allocation-step.png
2. To eliminate cost of the sender cost center in the booking ALLOCATION_OUT account of the sender cost center in order to have a TOTAL account of zero 2nd-allocation-step.png

Everything is working well when I launch the process for the 1st time but if I launch the process again (because new cost has to be allocated), it duplicates my values in "ALLOCATION" accounts. However I overwrite target values at each time in my steps, so I don't understand why it appends values.

Thx,

Etienne

[etienne1110 · Accepted solution]

Hello Jef,

Finally, I used the "booking account" feature in the allocation step and it's better because I only had to create one step rather than two thanks to this feature. It allocates to receiver cost centers and put negative amount in my sender cost center in order to have zero in TOTAL account.

allocation-step.png

before-allocation.png

after-allocation.png

But thanks for your time and answer!

Etienne

[JefB]

Hi, could it be you are taking too many values in your source filter?

On your ALLOCATION_IN, change your source filter from Account=TOTAL to Account=EXPENSES

On your ALLOCATION_OUT, change your source filter from Account=IN to Account=OUT
or perhaps to Account = ALLOCATION with 'keep source' flagged.