Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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 .
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?
this account using for sell items through sales order only.
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.
so i have to create separate ledger accounts for components right.
can u pleas explain briefly if you don't mind.
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.
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.
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.
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. :-)
Business Applications communities