Hi,
I would like to use the Ledger allocation on the basis formula where :
- In My Source account Telephone expenses “400001” with Business unit “100” and Department “104” posted.
- These $100 expenses I want to allocate to different Business units (100,101) and Department (106,107).
3 - Basis is based on the sales revenue amount of the different departments financial dimension
Rent expense is $100, GL 400001-100-104
Business unit 100 balance for the Sales Revenue account is 1000, GL 310100
Business unit 101 balance for the Sales Revenue account is 2000, GL 310100
Then the Telephone expense account should be debit 33.33$ for the Business unit 101 department 107 financial dimension , debit 66.67$ for the Business unit 100 department 106 financial dimension.
But i am getting ledger allocation like below, please provide me knowledge on this
My overall set up screenshot's for reference
Step1:
Basis created and its source
sales dell hyd source:
Sales dell bng source:
Step2: Allocation rule
Clicked on source
Clicked on Destination given destination BU and department and linked basis
Thanks,
Vinod
