web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Allocation Rule / Cost Accounting

(0) ShareShare
ReportReport
Posted on by 15

Hello,

how can you set up an allocation of a Cost Center dimension in the Cost Accounting module, which should be split in a certain ratio of three cost center dimensions?

Example:

A Cost Center dimension should be split into three cost Center dimensions in a certain percentage?

Best regards

Odai

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Odai,

    Have a look at those posts to get started with the cost accounting module.

    dynamicsax-fico.com/.../

    If you just need to split costs by a specific ratio then you don't need the cost accounting module but can make use of the simpler to use GL ledger allocation rules.

    Best regards,

    Ludwig

  • eemc Profile Picture
    15 on at

    Hi Ludwig

    Thank you for your fast reply. actually what the customer asking for:

    They are looking to post the payroll transaction which is salaries expense (Main Account) and Workers as a (dimension) after that they want these transactions to be split into two cost Center dimensions in a certain percentage which is Projects and Sections.

    Please note that the customer doesn't want to use the project module.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi eemc,

    For this 'simple allocation' you can make use of the GL ledger allocation rules in my opinion.

    The most important thing is of course defining the allocation key. If the allocation key is defined by amount posted on other accounts or findims then you can make use of the so-called basis ledger allocation rule.

    More information can be found here:

    docs.microsoft.com/.../ledger-allocation-rules

    Best regards,

    Ludwig

  • eemc Profile Picture
    15 on at

    Hi Ludwig

    actually, if I want to use the allocation rules for my cause I will need to have multip level allocation rules.

    for example

    .the HR department will post the Payroll transactions as below for more than 50 employees. 

    Salaries exp. - Tom Ozegovize 1200 $

    the allocation rule should do this base on percentage:

    Salaries exp. - Tom Ozegovice - Project 1  - Section 2 - 400 $

    Salaries exp. - Tom Ozegovice - Project 3  - Section 1 - 250 $

    Salaries exp. - Tom Ozegovice - Project 4  - Section 5 - 550 $

    My question is how I can do this by D365? Allocation rules or Cost Accounting and how?

    Thank you in advance

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi eemc,

    Many thanks for the example provided.

    Here a couple of comments:

    1. If you post the salary expense this way, you might get into trouble because people can identify the salary of others, which is something most companies want to avoid.

    2. It seems that you want to allocate costs to projects. Rather than using the cost accounting module or ledger allocation rules, I would recommend using the timesheet functionality in the project module.

    Why?

    a) Because the timesheet functionality gives you a better insight into what people are working on (project 1-section2, project 3 - section 1, etc.)

    b) In addition, posting timesheets automatically creates a cost allocation voucher in the form:

    DR: CostAccount-ProjectFinDim-SectionFindim

    CR:  Payroll allocation-CostCenterEmployeeFinDim

    You can thus see how much costs remain on the cost center of the employee and how much costs are 'moved' to projects by a simple account analysis

    An additional advantage of doing that is that you can quickly identify over/underutilization of people simply by checking how much money remains on their cost center.

    Also the integrity remains because nobody can directly see the salary of a specific employee.

    c) If you use the project module for time related cost postings only, then the setup is very 'small' and can be completed in a very short period of time.

    Best regards,

    Ludwig

  • eemc Profile Picture
    15 on at

    Thank you so much for explaining your answer to me.

    I will try with my client to accept this solution by using the project accounting module as you suggested.

    But again as I explained before the customer doesn't want to use the project accounting module that why I am trying to find a different solution for him, Either with cost accounting or allocation rules.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi eemc,

    If the allocation percentage is fixed (and simple) then you can use the ledger allocation rules.

    For the example that I shared above, I would expect that the standard GL allocation rules are sufficient as long as you can define the % values.

    Salaries exp. - Tom Ozegovice - Project 1  - Section 2 - 400 $

    Salaries exp. - Tom Ozegovice - Project 3  - Section 1 - 250 $

    Salaries exp. - Tom Ozegovice - Project 4  - Section 5 - 550 $

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 584 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 499 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 254 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans