Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales & COGS Separation
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales & COGS Separation

(1) ShareShare
ReportReport
Posted on by Jsabanovski 230
Is there any way to separate labor and materials in D365 from Sales and COGS?  
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,231 Most Valuable Professional on at
    Sales & COGS Separation
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,861 Super User 2024 Season 2 on at
    Sales & COGS Separation
    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.
  • Jsabanovski Profile Picture
    Jsabanovski 230 on at
    Sales & COGS Separation
    Andre,
     
    We apply labor using manufacturing features, specifically through the production order/route transactions. 
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,861 Super User 2024 Season 2 on at
    Sales & COGS Separation
    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? 
  • Jsabanovski Profile Picture
    Jsabanovski 230 on at
    Sales & COGS Separation
    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...
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Sales & COGS Separation
    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:
     
     
    Best Regards,
    Judy
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,861 Super User 2024 Season 2 on at
    Sales & COGS Separation
    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.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,861 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,540 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans