I have two segments in my chart of accounts.
Cost center
Allocation
At every month-end, from my shared service cost center 1000, we allocate to other cost centers based on fix %. After allocation, cost in 1000 cc become zero and get divided into other CCs.
My requirement is when we allocate to other CCs then I want to store the cost center 1000 (source) in allocation segment so that we can identify that how much was booked directly into CC and how much came from allocations. Source 1000 is not static. There can be multiple CCs. So, system should pick the CC of the source and put it into allocation segment in target.
How can we do that using Formula?