BeyondERP.Newsletter
Menu

Setup page · Product information management

Standard cost conversions

A list page where you create standard cost conversion records and add the items that each record converts from an actual costing approach to standard cost.

Used by
Inventory accountant, Inventory accountant clerk, Accounting manager
Business process
Develop product strategy
Menu item
InventStdCostConv
Main table
CostingVersion
Data entity
CostingVersionEntity
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 list page where you create standard cost conversion records and add the items that each record converts from an actual costing approach to standard cost.
What you do hereUse this page to convert the inventory model for a batch of selected items from actual cost to standard cost, by working through item checks and status changes during a planned transition period.
Standard cost conversions 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 processDevelop product strategy
Menu pathProduct information management › Periodic tasks › Cost conversions › Standard cost conversions
Related pagesCosting 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 Standard cost conversions

Use this page to convert the inventory model for a batch of selected items from actual cost to standard cost, by working through item checks and status changes during a planned transition period.

Steps from Microsoft

  1. Go to Product information management > Periodic tasks > Cost conversions > Standard cost conversions.
  2. Select New to create a conversion record, and enter the transition date, the conversion date and the identifier for the new costing version.
  3. Add the items that you want to convert to standard cost.
  4. Enter or calculate the pending standard cost for each item in the dedicated costing version.
  5. Select Check, and resolve any issues until every item has a status of Checked.
  6. Use Update status to change the status of the conversion record to Ready.
  7. On the planned conversion date, select Convert to perform the conversion.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Transition dateThe start of the planned transition period. An inventory close must be performed one day before this date.Microsoft Learn TransitionStartDate
Conversion dateThe planned date of the conversion. An inventory close must be performed one day before this date.Microsoft Learn TransitionEndDate
VersionThe user-defined identifier of the new costing version that holds the standard costs for the converted items.Microsoft Learn
StatusThe status of the conversion record. When it is changed to Ready, the system performs a final check before the conversion.Microsoft Learn
Use cost price by variantShows the standard cost for every combination of product dimensions. When it is cleared, only one pending cost is entered for the item.Microsoft Learn
New model groupThe item model group with a standard cost inventory model that converted items are moved to.Microsoft Learn ModelGroupId

Test checklist

  1. Run an inventory close, then create a conversion record with the transition start date one day later and a new costing version ID.
  2. Add the items, enter or calculate pending standard costs per site, and run the Standard cost conversion checks report until every item is Checked.
  3. Set the record to Ready, back up the database, and run the conversion.
  4. Check the record is Completed, items are Converted and their item model group now uses standard cost.
  5. Run the Variance analysis statement and the Inventory value report for the conversion date to reconcile the revaluation.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Standard cost conversionsOne conversion record that holds all manufactured items, with the transition start date set to the day after an inventory closeLearn advises including all manufactured items in a single conversion record so costs are calculated correctly, and the status can only move to Ready when an inventory close exists one day before the transition start date.Starting the transition without an inventory close one day before the transition start date. The record can't be set to Ready, and you lose time in the transition period.Test: Convert an actual cost item to standard cost
Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model
Can it be undoneOne-way: Warning: after conversion the item model group of each item changes to a standard cost group, financial on-hand is revalued, and you can't post backdated transactions before the conversion date. The inventory close one day before the conversion date can't be cancelled. When the record is set to Ready, its cost records can no longer be changed. Microsoft Learn
If you change it laterWhen the conversion record status is changed to Ready, changes to the cost records in its costing version are no longer permitted. Microsoft Learn
Technical architect

6Technical

Menu itemInventStdCostConv Checked in Dynamics 365
FormInventStdCostConv Checked in Dynamics 365
TableCostingVersionShown as “COSTING VERSIONS” in Record infoChecked in Dynamics 365
Data entitiesCostingVersionEntityCosting versions Microsoft data model
Who can open itPrivilegesMaintain standard cost conversions InventStdCostConvMaintainView standard cost conversions InventStdCostConvViewDutiesEnable inventory valuation process InventStdCostInvValuationProcessEnableInquire into inventory valuation status InventValueInvValuationStatusInquireInquire into inventory valuation policies (cur.) InvStdCostInvValuatPoliciesSecInquire_RU
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 LedgerAccountingManagerTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkGive 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): Update status, Check, Costing versions, ConvertChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=InventStdCostConv
Integrate withCostingVersionEntity data entity Microsoft data model
Data migrationCostingVersionEntity (Costing versions): loaded for each company, in Microsoft's default template 420 - Costing.Load order: Microsoft's default template 420 - Costing loads Costing versions at execution unit 1, level 300, sequence 50. 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 Budgeting)Microsoft Learn
Table definitionCostingVersion columns and relations Microsoft data model
Everyone

8Sources