Notifications
Announcements
No record found.
Hi Experts,
I have a doubt in cost accounting allocation.
Am giving below a requirement from my client. I have reduced the complexity of the requirement for simplicity so that experts can provide a solution.
cost-acc-allocation.xlsx
Main question here is->>whether can we apply cost allocation in desired sequence. Do i need to create different cost allocations or single allocation. plz suggest
Hi Pranav,
Can you explain the contents of the Excel sheet? I don't understand what these tables do represent here. Can you provide some examples how the allocations should be calculated and posted?
Good Morning Pranav,
My last information is that the cost accounting module is making the multi step allocations that you highlighted in the file automatically. That's part of the allocation logic and included in the code. The continuous allocation iteration ends when the amount remaining on the various cost centers/findims is <0.01
Please make the respective setup in a demo test environment and test those allocations.
Pretty sure that you should be getting the expected outcome if you configure things correctly.
Best regards,
Ludwig
Thanks Ludwig for replying. I was able to allocate the cost amongst cost centers. But I was not able to reallocate the cost from cost centers to product groups. So my question is ->>Does D365 fo handle allocations only amongst one kind of cost object, or does it even handle cost re-allocation from cost centers to product groups.
The process which i followed in d365 fo is to allocate it initally from indirect CC to direct CC. This worked perfectly. Subsequently the re-allocation from direct CC to product groups was failing. Please let me know if there is any setup to handle this.
8473.cost-acc-allocation.xlsx
Hi André Arnaud
Thanks for responding. I have made necessary modifications by providing expln. Hope this would be clear.
Thanks,
Pranav
Two step allocations are supported as well.
The setup is, however, a bit 'tricky'.
Please have a look at MS docs; if I remember it correctly then there is an example how this can be realized.
Also, have a look at the MS contoso demo box.
There is a cost accounting ledger 'USP2' setup there, which makes use of more than a single cost control unit.
Thanks Ludwig for this reply. Its happy to hear that there's a solution for this. Could you please send me the ms documents link where such a solution is present. As far as I remember, MS has not explained any kind of configuration on these lines
Thanks
Here is the official MS docs site:
docs.microsoft.com/.../cost-accounting-home-page
I also posted a number of posts on my blog where you can find some additional information/screenprints/etc.
Hello Pranav,
Did you have the chance to take a look at the documents on MS docs?
Have you tested and tried to implement it in your demo/test environment?
Hi Ludwig,
Finally i was able to achieve it. The trick was to build a hierarchy in control units.
Frankly to say, the link only helped in giving a basic understanding of cost accounting module. I went through your blog post too on cost accounting and it was extremely resourceful.
Great to hear that you found how to configure this.
Agree that the setup is not that easy and that you need a lot of testing.
Please let us know if your question has been answered.
If it has then please verify the answer by selecting the yes button further above.
Many thanks and best regards,
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional