Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Total Hours in COGS

(0) ShareShare
ReportReport
Posted on by 258

Is there a way to see a monthly COGS breakdown between materials, direct labor, and overhead costs (or even hours) in D365?  Trying to get a breakdown after our monthly closing. 

  • Jsabanovski Profile Picture
    Jsabanovski 258 on at
    RE: Total Hours in COGS

    Thank you all for your help...I was afraid you were going to say that.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    RE: Total Hours in COGS

    Hi,

    Yes agree with Andre, For COGS, you need to mark(link) transaction if you can in the business process.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    RE: Total Hours in COGS

    Hi Jet,

    Unless you have a make to order (MTO) process, such a report would be hard or even impossible. On the production order you have a cost calculation option. The RAF process creates on-hand with inventory transactions. There is not always a link between the sales order line and the inventory transaction which was created by a production order. If you create a production order from a sales order (MTO) or if you reserve the on-hand from sales orders, then there will be a link between the sales inventory transaction and the production inventory transaction.

  • Jsabanovski Profile Picture
    Jsabanovski 258 on at
    RE: Total Hours in COGS

    Hi Andre,

    Sorry for the lack of detail.  I am trying to find a report or information that links cogs to the sales revenue for the month or whatever period selected. So, I am trying to find a way to look at what production hours, overhead, and materials were for the revenue that was shipped for that period.  Does that help?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    RE: Total Hours in COGS

    Hi Jet,

    Can you please provide some more detailed information? I'm not able to understand what exactly you are looking for. Are you looking for some production related reports or do you want to link the sales COGS to the produced items and link them back to the financial production details or something different?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans