Bills of Material: Updating Standard Costs

Steps to Update Standard Costs

When you want to update standard costs of items to be produced for bills of material[7]Brian.Quan for bills of material2023/05/0816:56:56-04:00, you perform the following general steps:

1. You update [8]Brian.Quaninsert2023/05/0417:19:38-04:00purchased and transferred items with the Standard valuation prior to the cost rollup process. If you have not yet updated the standard costs for the materials used in the BOMs, you can select the Use Pending Standard Cost for Purchase Items check box on the Cost Roll (AM508000) form. In this case, the system will use the pending costs instead of standard costs for the materials that are purchased. the standard cost with the pending cost for each material included in the BOM for which the following conditions are met:[9]Brian.Quanthe standard cost with the pending cost for each .. 2023/05/0417:19:36-04:00<ul id="_724ff588-ea9b-45c4-844a-2dbbc234ec3b"><li>The material has the <i>Standard</i> valuation method specified on the <uicontrol>General</uicontrol> tab of the <xref href="../UserGuide/IN_20_25_00.dita"/> (IN202500) form.</li><li>The material is not a subassembly.</li></ul><p>For details, see the <i>Update of Standard Costs for Materials</i> section below.</p>[10]Brian.Quan<ul id="_724ff588-ea9b-45c4-844a-2dbbc234ec3b"><l.. 2023/05/0417:32:23-04:00
<li>You preview the cost changes for the materials with standard costs by using the <xref href="../UserGuide/IN_61_75_00.dita"/> (IN617500) report, so that you can see the impact of the cost changes on production cost drivers, such as overhead or labor costs.</li>[11]Brian.Quan<li>You preview the cost changes for the material.. 2023/05/0417:36:13-04:00
2. You roll up the costs for the bills of material by using the Cost Roll (AM508000) form. For more information, see the Cost Rollup for BOMs section below.
3. You update the pending costs with the costs calculated by the rollup process for the BOMs on the Cost Roll form. For more information, see the Pending Cost Update for BOMs section below.
4. You again [12]Brian.Quanagain 2023/05/0417:36:19-04:00preview the cost changes for materials by using the Standard Cost Change Preview (IN617500) report to make sure that the costs are correct and to understand the impact of the inventory revaluation.
5. You update the standard costs for the items to be produced by using the Update Standard Costs (IN502000) form. For details, see the Standard Cost Update for the Items to Be Produced section below.

Update of Standard Costs for Materials

Before you roll up the costs of a bill of material, you need to update[13]Brian.Quanneed to update2023/05/0421:00:55-04:00[14]Brian.Quaninsert2023/05/0421:00:55-04:00should update the standard cost for each material that is used in the BOM, has the Standard valuation method, and is not a subassembly[15]Brian.Quan, and is not a subassembly2023/05/0510:19:09-04:00. You can use either of the following ways:

• Specify the pending cost for each material manually on the Price/Cost tab of the Stock Items (IN202500) form and then update the current cost by using the Update Cost command on the same form.
• Create a generic inquiry to display the purchase order history. By using this generic inquiry, you analyze and calculate a new standard cost that could be imported to update the pending costs of the materials. If you want to select only items used in BOMs, you can refer to the Using Manufacturing Data in Inquiries and Reports topic that lists the DACs used by the manufacturing-related forms.

Cost Rollup for BOMs

To calculate costs for bills of material based on the costs of BOM elements, such as materials, tools, or overhead, you do the following on the Cost Roll (AM508000) form:

1. In the Level box of the Selection area, select Multi [16]Brian.Quaninsert2023/05/0421:02:22-04:00or Single to calculate costs of the bills of material and the subassemblies included in the BOMs.[17]Brian.Quaninsert2023/05/0421:04:27-04:00 We recommend selecting Multi to roll up costs level by level from the bottom up.
2. In the Selection area, select the needed check boxes[18]Brian.Quanneeded check boxes2023/05/0421:12:45-04:00[19]Brian.Quaninsert2023/05/0421:12:45-04:00desired elements, such as Include Material Scrap Factors.
<li>In the Included column, select the check box for each BOM for which you would like to calculate costs.</li>[20]Brian.Quan<li>In the Included column, select the check box .. 2023/05/0509:48:11-04:00
3. On the form toolbar, click Roll Costs and wait till[21]Brian.Quantill2023/05/0421:13:24-04:00[22]Brian.Quaninsert2023/05/0421:13:24-04:00until the process is completed.[23]Brian.Quaninsert2023/05/0421:13:40-04:00 The cost of the bill of materials are now rolled up.
[24]Brian.Quaninsert2023/05/0509:44:18-04:00
4. Review the costs in the grid.
<li>On the form title bar, click <menucascade><uicontrol>Tools</uicontrol><uicontrol>Trace</uicontrol></menucascade> to view the trace log and make sure that no errors occurred during the cost rollup process.</li>[25]Brian.Quan<li>On the form title bar, click <menucascade><ui.. 2023/05/0421:14:33-04:00

You can run the cost rollup process as many times as you need.

Pending Cost Update for BOMs

When the cost rollup process is completed, on the toolbar of the Cost Roll (AM508000) form, you [26]Brian.Quaninsert2023/05/0421:15:03-04:00select the rows of inventory items you want to update and click Update Pending[27]Brian.Quaninsert2023/05/0421:15:14-04:00. so that [28]Brian.Quan so that 2023/05/0421:15:12-04:00[29]Brian.Quaninsert2023/05/0421:15:17-04:00 Tt[30]Brian.Quant2023/05/0421:15:12-04:00he system updates the pending costs of the items assigned to the BOMs with the calculated costs on the Price/Cost tab of the Stock Items (IN202500) form.[31]Brian.Quaninsert2023/05/0510:05:06-04:00 Only items with valuation method Standard will have the pending cost updated.

Standard Cost Update for the Items to Be Produced

Finally, y[35]Brian.QuanFinally, y2023/05/0509:45:42-04:00[36]Brian.Quaninsert2023/05/0509:45:42-04:00You update the standard costs of items to be produced by using the Update Standard Costs (IN502000) form. During the update, the system does the following for each item to be produced:

• On the Price/Cost tab of the Stock Items (IN202500) form for the item or the Item Warehouse Details (IN204500) form for the item–warehouse pair, copies the value of the Pending Cost box to the Current Cost box in the Standard Cost section.
• Sets the Pending Cost to zero.
• On the Adjustments (IN303000) form, creates an inventory adjustment to update the Inventory GL account and Standard Cost Revaluation GL account and releases the adjustment.

Inventory is always revalued when you update standard costs. However, you might want to revalue inventory without updating the current costs of the items to the next pending cost. In this case, on the Update Standard Costs form, you can select the Revalue Inventory check box. With the check box selected, the form shows all items with the Standard valuation method that have cost layers in the warehouse selected in the Warehouse box. When you run the update process, the system revalues the inventory with the current cost, but the current cost will not be updated with the pending cost for the items.