Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Allocate amounts based on financial dimension regardless of ledger account

(0) ShareShare
ReportReport
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 15,029 Super User 2024 Season 2 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 16,176 Most Valuable Professional 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. 
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans