347
Dear All,
how can we split cogs into components wise (raw material wise).actually we have only one cogs account .after sale invoice posted total amount going to COGS Account.
but client need components wise because they are preparing budget for next year so they need this year cogs details component wise.
please help me .
Thanks
Ashok
*This post is locked for comments
It is either a customization or an offline report where you allocate out the COGS amount by a predefined split of teh BOM. I have come across this a few times but no one has ever decided to re-write the production cost posting routines for obvious reasons. :-)
Hi Ashok R,
If you have a lot of products for which you would have to define an allocation you might be better of just doing an kind of 'offline' analysis outside of AX by making use of BI tools.
Allocations would only make sense if you need some kind of vouchers posted in AX.
If you are, however, only interested in an analysis, then you might be better off using either the AX cubes or external calculations to get this info.
Best regards,
Ludwig
hi
thanks for your support.
actually we have 100's of finished goods and raw materials .
no problem i will check this process and let you know.
thanks
Hello Ashok,
I do not think that you need separate ledger accounts for all of your components. I think using financial dimensions is easier & better.
Let's assume that you sell a finished good 'Fg1000' with COGS of $500.
If this finished good is make up of 5 components 'COMP 1-5' and provided that each of those components is setup with its own financial dimension you can then for example define an allocation rule that uses the production cost account in combination with the financial dimension as the allocation basis to split the COGS of $500 into the components.
Here is an example that uses a fixed percentage allocation - you would need to make use of an base allocation which is a bit more complex. Yet, this article might give you an idea how to Approach this issue. dynamicsax-fico.com/.../allocations-cost-distributions-in-gl Even though it will take you some time to figure out how this works especially if you have not done that before, I am pretty sure that based on the Information you provided, Standard AX can handle that.
Please let us know if this answers your question or if further assistance is requried.
Best regards,
Ludwig
hi ludwig,
so i have to create separate ledger accounts for components right.
can u pleas explain briefly if you don't mind.
Ashok
Hi Ashok R,
This split up cannot be achieved directly because you only sell the finished product but not the individual components that make up the finished product.
The only possibility that I see to split the COGS for your sold finished products is by making use of a subsequent cost allocation through the ledger allocation functionality.
If you are making use of the Dynamics AX cost accounting module you can also make use of the allocation features that are available there.
Best regards,
Ludwig
hi ludwig,
this account using for sell items through sales order only.
Thanks
Hi Ashok,
The COGS account you refer to is this the one that is used when you sell items through a sales order or is it related to the production of a finished good or something else?
Can you provide a bit more details?
Many thanks,
Ludwig
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
48
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
