Cost Accounting for the Modern Manufacturer

by | July 29, 2021 | Dynamics 365 for Finance and Operations

Dynamics 365 Finance and Supply Chain Management enables users to collect data from a variety of sources in order to analyze, summarize, and evaluate cost data. Cost data can then be used to make key decisions related to price updates, budgets, cost controls, and more.

Item Model Group Costing Methods

The Dynamics 365 Finance and Supply Chain cost management module has a wide range of functionality, including seven-item model group costing methods. These methods include standard, moving average, FIFO, LIFO, LIFO date, weighted average, and weighted average date. D365 supports having different items with different costing methods.

Costing methods are underpinned by the notion of item model groups. With item model groups, items can be classified as stocked or not stocked, can have their own costing methodology, can have negative inventory policies if appropriate for a specific item, can have general ledger integration, can track workflow for inventory, and can place reservation rules around specific items. All of these rules are put in place to support the underlying infrastructure of an item in terms of how we cost and manage it.

Costing Sheets

In Dynamics 365, a costing sheet is used to answer the question, “how do I cost it?”. Costing sheets format how COGS are viewed for manufactured items and production orders using material, labor, and overhead. They are used for calculating and applying indirect costs and can be configured to only apply these costs in certain scenarios. Calculations can be done using a surcharge, which is percentage-based, or an hourly rate.

Costing sheets are used to create a library of item model groups with standard costs but different rules. This allows for customization and granularity around tailoring the way costs are managed at the item level and the item model group level.



Workspaces and Power BI

Dynamics 365 and Power BI integration allow users to evaluate costing data without having to drill down thousands of line items. This helps understand the true cost of production, as one can drill down and look at standard cost versus actual per order and turn this data into a graphic. Inventory and manufacturing accounting can be accessed from the cost administration and cost analysis workspaces. These workspaces provide a comprehensive overview of the current status, key performance indicators (KPIs), and detection of deviation. KPIs are used to gain insights into efficiencies. Manufacturing accounting lets users handle job order costing in production orders and batch orders, as well as Backflush costing in lean manufacturing.

Cost management Power BI content provides managerial insight into inventory and work-in-progress (WIP) inventory, and how cost flows through them by category over time. This information can be used as a detailed supplement to the financial statement. Cost management Power BI also enables users to view inventory statements and KPIs by item. Variances can be built into useful diagrams that provide insight from a cost analysis point of view. ABC analysis is another useful tool found under cost management. This tool simplifies categorizing items by importance.



Power BI allows for the comparison of cost elements and shows a cost analysis. Costs for product pricing can be easily distinguished using Power BI integration.



Cost Accounting Module: The Big Picture

The cost accounting module is a separate menu item within Dynamics 365 that evaluates cost accounting at a much higher level. This module is a micro-service connected to a data lake and offers cross-cost accounting ledger analysis looking at currency, cost flow assumption, and input measurements. It enables organizations to account for their inventory across multiple cost accounting ledgers based on different currencies, cost flow assumptions, and input measurements. This flexible cost elements setup enables organizations to analyze costs in greater detail. Inventory transactions can be pushed out to various cost accounting ledgers, driving out different cost/profit analyses at a more global level.


Are you a manufacturer looking to get the most out of Dynamics 365? If so, consider registering for our upcoming webinar.

The Modern Manufacturer – Enterprise Asset Management

August 11, 2021

10:00 am – 10:30 am CST


Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


27sep(sep 27)9:00 am15oct(oct 15)11:00 amDynamics 365 Finance & Supply Chain Development Training - Online Workshop

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!