Can the GL Allocation process handle a situation where a chartfield is part of the Pool, Basis, Targ
We would like to reallocate dollars for a particular Account and Product (Chartfield) using Prorata method where the Pool Product is part of the Basis calculation and is also part of the Target distribution and Offset.
Let's say in our Actuals Ledger we have 100 dollars in Account 12345 and Product A. We want to redistribute that 100 to 3 additional Products within that Account. We want Product A to have some dollars - just not all dollars.
Our Basis is a different Account grouping (45678 - 47777) and Products A, B, C & D.
Let's say this is how the numbers work out with the Prorata calc: