Finance | Project Operations, Human Resources, ...

Sales & COGS Separation

(1) Share

Report

Posted on by Jsabanovski

314

Is there any way to separate labor and materials in D365 from Sales and COGS?

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 303,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Jsabanovski,

Can you elaborate on your question? Are you using manufacturing and want to analyze the labor versus consumed material costs? Or do you want to have a split of the inventory cost in your ledger? Please provide some more information, so we would be able to understand your complete requirement.

Was this reply helpful? Yes No
Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

What product are you using?

The estimated costs and revenues tab in the WBS in Dynamics 365 Project Operations allows you to estimate and track costs for labor, materials, and expenses for each task.

The helpful links regarding WBS:

Work breakdown structures overview | Microsoft Learn

Project sales tracking | Microsoft Learn

Best Regards,

Judy

Was this reply helpful? Yes No
Jsabanovski 314 on at

Like (0)

Report
Copy link

Link copied!

Judy - D365 F&O

Andre - I apologize for the vagueness of my question. Yes, I would like to analyze the labor versus consumed material costs. What I'm trying to do for my company coming in as their new CFO is somehow analyze our financial information to show the COGS broken down between consumed labor and material costs. I would also love to figure out how I can do that on the sales side as well. It would be great to pull up my trial balance from D365 F&O and see the Sales and COGS accounts broken down by labor and material costs. I have dimension currently set that breaks down Sales and COGS by customer, but I would love to go further and brake it down between materials and labor.

We are a contract packaging company that has two different entities that deal with toll and turn-key manufacturing. We charge for straight labor on one side (with customer supplied materials for the most part), and labor and materials on the other side (with us purchasing the materials and selling it back with an upcharge plus labor). I hope that helps...

Was this reply helpful? Yes No
André Arnaud de Cal... 303,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Jsabanovski,

Thanks for providing some additional information. How exactly do you post the labor today? Are you using manufacturing or project management features? Or it is an entry on the sales order?

Was this reply helpful? Yes No
Jsabanovski 314 on at

Like (0)

Report
Copy link

Link copied!

Andre,

We apply labor using manufacturing features, specifically through the production order/route transactions.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,481 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the additional clarification, Jsabanovski.

In this case, the produced item has a cost price which is used on sales transactions as COGS. The details of consumed material and labor are part of the production transactions. You can get some insights from the production module or use the cost accounting features. Potentially, you would need to create a custom report for specific requirements. In the past, I was involved in an implementation where we created a new batch number per production order and included this dimension in financial cost to be able to analyze every single detail of manufacturing cost and expected rebates on purchased items.

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 20,521 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

You are not able to have this data OOB easily. You will need customization.

There is a functionality in Dynamics to show the costs of the transactions but will show you by transactional level.

Was this reply helpful? Yes No