Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Allocate amounts based...
Finance forum
Suggested answer

Allocate amounts based on financial dimension regardless of ledger account

Posted on by 2
Hi, 
 
Our customer requires to allocate from financial dimension X to multiple financial dimension A, B, C, with each a different fixed percentage.
This allocation needs to happen for each P&L account and the destination main account should be the same one that was used on the source main account.
 
In the ledger allocation rule you don't have the possibility to select the destination account source, only user specified.
Because of this we would need to setup this allocation rule for each account, which isn't really manageable. 
 
 
I notice that when you select allocation method equally, we have the possibility to select keep account from source, which is what we would like to pick when selecting fixed percentage. 
But because we don't distribute the amount equally we cannot pick this option.
 
 
Does anyone have experience with setting up such scenario using other methods? Or developing customization for this in the ledger allocation rules? Or any other alternatives? 
Allocation terms on the main account doesn't work either because these postings should be done end of month and directly when posting. 

Thanks in advance for your help! 

Kind regards, 
Kevin 
  • Allocate amounts based on financial dimension regardless of ledger account
    Hi Bharti, 
     
    Thank you for your reply. The case at this customer is that the destination account should be the same one as the source one. And because this applies to all P&L account, its not feasible to set up this way for each account. 
     
    Kr, 
    Kevin Vanhede
     
  • Suggested answer
    saurabh bharti Profile Picture
    saurabh bharti 14,932 Super User on at
    Allocate amounts based on financial dimension regardless of ledger account
    Hi Kevin,
     
    Though it is disabled here but if you click on top destination option you have to define percentage for destination and you can select your accounts and diemnsions.
  • BillurSamdancioglu Profile Picture
    BillurSamdancioglu 13,216 Super User on at
    Allocate amounts based on financial dimension regardless of ledger account
    Hi,
     
    As a workaround, you may consider to use cost accounting module.
    This will make easier to manage the process and do not create ledger transaction. 
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans