Business Central / NAV UG
Experts:
Cost Breakdown for Manufacturing
-
Cost Breakdown for Manufacturing
I am working with a client who runs FIFO with manufacturing. During the manufacturing process, costs are captured between material, labor, overhead, etc.
Once the product is complete, those amounts lump together to value the inventory (into one inventory account).
When the sale is completed, that entry is only to one COGS account, not the individual branches.
The Cost Share Breakdown report in BC is “Ok”. But, there is no correlation between the production order and the outbound sale.
Has anyone developed a custom report or found a way to use the cost share breakdown report to compare this data?
-
2 Replies
-
What do you mean by Branch? Is that location or did you mean cost is not broken down by material, labor overhead?
Either way, since the cost of the finished product is one amount, that is the cost of goods amount. I have seen reports written to breakdown the cost via a journal entry for accounting.
-
Unfortunately, this is not really possible with BC. I have worked with clients in the pas to develop a report but was not really successful. The problem with breaking out the sales by component is trying to tie it back to the production order which produced the goods. Working with the application tables should work but it hard to keep everything typed together. This is especially true if your sales orders pulls from multiple FIFO layers. You can break out the costs if you just focus on production, but not with sales. Sorry there’s not better news.
Log in to reply.
