Hi,
I would like to use the Ledger allocation on the basis formula where :
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
Hello Vinod,
Please refer to the document https://docs.microsoft.com/en-us/dynamics365/finance/general-ledger/ledger-allocation-rules. Hope this helps!
Best Regards,
Poornima
Hi Vinod,
Can you try whether it makes a difference if you enter a date interval code in your rule?
In addition, can you double check differences in your setup with one of the sample allocation rules in the MS Contoso environments? In the USMF demo company there is an Advert rule that makes use of the basis rule as well.
Might be the case that something has been overlooked.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,336 Most Valuable Professional
nmaenpaa 101,156