BeyondERP.Newsletter
Menu

Setup page · Cost management

Costing sheets

A setup page where you build the costing sheet, a tree of nodes that sets the format for showing the cost of goods sold for a manufactured item or production order and the basis for calculating indirect costs.

Used by
Inventory accountant, Inventory accountant clerk, Accounting manager
Business process
Define costing policies
Menu item
CostSheetDesigner
Main table
CostSheetNodeTable
Data entity
CostSheetNodeEntity
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where you build the costing sheet, a tree of nodes that sets the format for showing the cost of goods sold for a manufactured item or production order and the basis for calculating indirect costs.
What you do hereUse this page to define how cost of goods sold is segmented by cost group, with totals for material, labour and overhead, and to set up the surcharges and rates that calculate indirect costs.
ExampleFor example, you can add a 3 percent surcharge to the cost of production for all the raw materials on a production order.
Costing sheets page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processDefine accounting policies › Define costing policies
Menu pathCost management › Indirect cost accounting policies setup › Costing sheets
Set up firstCost groups Microsoft Learn
Used next byCosting versions Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Costing sheets

Use this page to define how cost of goods sold is segmented by cost group, with totals for material, labour and overhead, and to set up the surcharges and rates that calculate indirect costs.

Steps from Microsoft

  1. Go to Cost management > Indirect cost accounting policies setup > Costing sheets.
  2. In the tree, select a node that represents the cost of goods that you manufactured.
  3. Select New to create a node.
  4. In the Select node type field, select Total.
  5. In the Code field, enter a unique ID for the node, such as Production Overheads.
  6. Select the Header checkbox and the Total checkbox.
  7. Select OK.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Node typeThe kind of node in the costing sheet tree, such as Total, Cost group, Surcharge, Rate, Output unit based or Input unit based.Microsoft Learn
Absorption basisThe cost groups on the production order that an indirect cost is calculated from.Microsoft Learn
SubtypeFor a Rate node, whether the rate is based on run time (Process), setup time (Setup) or the quantity produced (Quantity).Microsoft Learn

Test checklist

  1. Build the sheet with Total nodes and cost groups, then save and validate it
  2. Enter a surcharge or rate cost record for the indirect cost node in a costing version
  3. Run a BOM calculation for a manufactured item
  4. Open the costing sheet on the calculation and check the cost segmentation and overhead

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Costing sheetsOne costing sheet for the legal entity, with Total nodes such as Materials and Hours over the cost groups, and Surcharge or Rate nodes for overheadLearn allows only one costing sheet per legal entity and suggests Total nodes to split production costs into groups such as hours and materials; indirect costs need a costing sheet format.Editing the costing sheet expecting to roll back later. There is no version history and no way to go back to an older version; changes take effect when you save and validate.Test: Overhead surcharge flows into item cost
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneHard to reverse: The costing sheet can be edited and revalidated, but the system keeps no version history. Closing the page without saving discards unsaved changes; after you save and validate, the previous structure must be rebuilt manually. Microsoft Learn
Technical architect

6Technical

Menu itemCostSheetDesigner Checked in Dynamics 365
FormCostSheetDesigner Checked in Dynamics 365
TableCostSheetNodeTableShown as “COSTING SHEET NODE” in Record infoChecked in Dynamics 365
Data entitiesCostSheetNodeEntityCosting sheet nodes and absorption basis Microsoft data model
Who can open itPrivilegesMaintain cost version per indirect cost type CostSheetCalculationFactorMaintainMaintain costing sheet setup CostSheetDesignerMaintainView costing sheet setup CostSheetDesignerViewDutiesMaintain cost master CostingVersionCostMasterMaintainEnable cost process InventCostCostProcessEnableInquire into cost status InventCostCostStatusInquireInquire into cost master InventItemPriceCostMasterInquire
3 security rolesInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itAccounting manager LedgerAccountingManagerInventory accountant clerk InventCostCostClerkTo use itInventory accountant InventCostAccountantGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): New, Delete, ValidateChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=CostSheetDesigner
Integrate withCostSheetNodeEntity data entity Microsoft data model
Data migrationCostSheetNodeEntity (Costing sheet nodes and absorption basis): loaded for each company, in Microsoft's default template 420 - Costing.Load order: Microsoft's default template 420 - Costing loads Costing sheet nodes and absorption basis at execution unit 1, level 420, sequence 10. Lower levels load first, and entities at the same level load in sequence order.Load first: the default templates at lower levels (System setup to Process manufacturing)Microsoft Learn
Table definitionCostSheetNodeTable columns and relations Microsoft data model
Everyone

8Sources