web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Cost of Goods Breakdown

(1) ShareShare
ReportReport
Posted on by 254
Hello,
 
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?
 
I have the same question (0)
  • Suggested answer
    Jun Wang Profile Picture
    8,210 Moderator on at
    The cost breakdown report out of box is at the bom level so user could analyze the percentages on costs. But once a production order is finished, the costs roll up into the finished products. However, user could use the statistics page on a finished production order to view the variances. Consider a custom report pull data from the below page/table to suit your needs. 
     
    From my understanding, there is no out of box such report for finished production orders. 
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    22,213 Super User 2026 Season 1 on at
    you can create a custom report
  • ahanson Profile Picture
    254 on at
    @Khushbu Rajvi. would you utilize the item ledger and gen ledger tables?
  • Suggested answer
    Valentin Castravet Profile Picture
    32,319 Super User 2026 Season 1 on at
    Are you saying that the Cost Share Breakdown report does not show the connection between the production order and the sales document?
     
    When you run the report with the 'Print Cost Share - Sales' option enabled, the 'No.' column will display the posted sales shipment associated with the item sold. You can add two new columns to the report to look up that shipment number and retrieve the corresponding posted sales invoice (or possibly the sales order if it is still open) and the production order number it originated from. This would be significantly easier than creating a new report, the calculations on this report are not simple. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    99,364 Super User 2026 Season 1 on at
    Hi, just adding some information, in the next version the standard will also add multiple reports for manufacturing, I hope it will be of some help to you as well.
     
    Thanks
    ZHU

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,717 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 995 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans