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
Good Morning Pranav,
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,
Ludwig
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.
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?
Best regards,
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.
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
Pranav
Hi 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.
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,
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.
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.
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 Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,120
Sohaib Cheema 815 User Group Leader
André Arnaud de Cal... 811 Super User 2025 Season 2