Process Cost Rollup Results

Form ID: (AM508000)

You use this form to process cost rollups generated on the Generate Cost Rollups (AM518000) form. This includes updating pending standard costs of the BOM items, updating costs of materials used in the BOMs, and archiving cost rollups. You can also create automation schedules to process generated cost rollups as frequently as needed.

For more information about the cost rollup process and updating standard costs, see Bills of Material: Updating Standard Costs.

Attention:
When it updates the pending standard costs of items assigned to the BOMs, the system typically updates the pending costs of the stock item on the Price/Cost tab of the Stock Items (IN202500) form. The system instead updates the pending cost of the item–warehouse pair on the Price/Cost tab of the Item Warehouse Details (IN204500) form if the following conditions are met:

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Process

Starts processing for the cost rollup results selected in the table.

This button becomes available after you select an action in the Action box.

Process All

Starts processing for all cost rollup results displayed in the table.

This button becomes available after you select an action in the Action box.

View Archived Rollups Opens the Archived Cost Rollups (AM408000) form.
Update Standard Costs Opens the Update Standard Costs (IN502000) form.
Preview Standard Cost Changes Opens the Standard Cost Change Preview (IN617500) form.
Generate Cost Rollups Opens the Generate Cost Rollups (AM518000) form.

Selection Area

You can use the settings in this area to select an action that will be performed during processing of cost rollups as well as to narrow the range of cost rollup results listed in the table. For example, you may want to process rolled up costs for items in a particular warehouse or assigned to a particular item class..

Element Description
Action

The action that the system performs when processing the cost rollup results.

You can select any of the following actions:

  • Update Pending Costs: Updates the pending costs of the stock items with the Standard valuation method that are used in the BOMs for which costs have been rolled up with the calculated costs.

    The system searches the items based on the value in the Default BOM ID box on the Stock Items (IN202500) or Item Warehouse Details (IN204500) form.

    Attention:
    This action is available if the Auto Archive when Update Pending check box is cleared on the BOM Preferences (AM101000) form.
    Important:
    This action updates only the item's pending cost. To update the standard cost, use the Update Cost command on the Stock Items form or use the Update Standard Costs (IN502000) form.
  • Update Material Costs: Updates the unit costs of the materials used in the BOMs.

    During the update, the system copies the material cost from the Price/Cost tab of the Stock Items or Item Warehouse Details form to the Unit Cost column of the Materials tab on the Bill of Material form depending on the valuation method of the material as follows:

    • Standard: The current standard cost
    • Average or FIFO: The average cost
    • Specific: The last cost

    For purchased components, the system uses costs from the Stock Items or Item Warehouse Details based on its valuation method. If the Use Pending Standard Cost for Purchased Items check box is selected, for items with the Standard valuation method, pending costs are used instead.

    For subassemblies, the costs are updated based on the level of cost rollup:

    • Single: The system uses costs from the Stock Items or Item Warehouse Details based on its valuation method.
    • Multi: The system uses the cost calculated for the subassembly's bill of material.
  • Archive: Archives the results of the cost rollup, which can then be viewed on the Archived Cost Rollups (AM408000) form.

    This action is available only if the Allow Archive without Update Pending check box is selected on the BOM Preferences form.

  • Update Pending Costs and Archive: Updates the pending costs of the stock items with the Standard valuation method that are used in the BOMs for which costs have been rolled up with the calculated costs; then archives the cost rollup results.

    This action is available if the Auto Archive when Update Pending check box is selected on the BOM Preferences form.

The system archives BOM records for the current date. If you archive the results multiple times on the same date, the system overrides the previous data for this date.

Attention:
The Item Warehouse Details (IN204500) form is used only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form and the warehouse-specific settings have been specified for the item.
Item Class

The item class assigned to the stock items whose cost rollups will be processed.

Warehouse

The warehouse assigned to bills of material whose cost rollups will be processed.

Inventory ID

The identifier of the stock item used in bills of material whose cost rollups will be processed.

BOM ID

The bill of material for which costs will be rolled up.

Revision The revision of the BOM specified in the BOM ID box for which costs will be rolled up.
Use Pending Standard Cost for Purchased Items

A check box that you select if the system should use the pending standard cost instead of the standard cost for purchased items when updating material costs.

This check box appears if Update Material Costs is selected in the Action box.

Table

The table lists the bills of material for which the system has rolled up costs and match the criteria specified in the Selection area.

If a BOM does not have a warehouse specified on the Bill of Material (AM208000) form and the production item has multiple warehouses, the table displays one row for each item–warehouse pair associated with this BOM. You can choose the warehouse for which you want to process the cost rollup.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 1. Table Columns
Column Description
Included A check box that you select to include the BOM in processing when you click Process or Process All on the form toolbar.
BOM ID The bill of material whose cost has been rolled up.
Revision The revision of the bill of material specified in the BOM ID column.
Warehouse The warehouse assigned to the BOM.
Inventory ID The stock item used in the BOM.
Unit Cost The unit cost of the item, which has been calculated during the cost rollup process. The system copies this cost to the pending cost of the item when you click Update Pending.
Material

The total cost of the BOM materials.

The system calculates the cost of subassemblies included in the BOM depending on the value of the Level box in the Selection area.

The system uses the cost of each material that is a finished good from the Price/Cost tab of the Stock Items (IN202500) form or the Item Warehouse Details (IN204500) form according to the valuation method assigned to the material on the General tab of the Stock Items (IN202500) form as follows:

  • Average or FIFO: The average cost is used. If the average cost is 0, then the last cost is used.
  • Standard: The standard cost is used.
  • Specific: The last cost is used.
Attention:
The Item Warehouse Details (IN204500) form is used only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form and the warehouse-specific settings have been specified for the item.
Fixed Labor The fixed labor cost. The system calculates this cost as the sum of the setup times for each operation of the bill of material multiplied by the standard rate of the work center assigned to the operation.
Variable Labor The variable labor cost. The system calculates this cost as the sum of the labor time (which is a run time multiplied by the number of run units) for each operation multiplied by the standard rate of the work center assigned to the operation.
Fixed Overhead The total cost of fixed overhead.
Variable Overhead The total cost of variable overhead.
Tools The total cost of tools.
Machine The total machine cost. The system calculates this cost as the sum of the machine time for each operation multiplied by the machine rate per hour.
Subcontract The cost of materials with a type of Subcontract and a subcontract source of Purchase or Ship to Vendor.
Ref. Material The cost of materials that have a type of Subcontract and a subcontract source of Vendor Supplied. The cost of these materials is not included in the product cost because the materials are supplied by the vendor.
Lot Size

The lot size, which the system uses to apportion fixed costs, such as fixed labor costs and fixed overhead costs.

The system copies the lot size from the Lot Size box of the Stock Items (IN202500) or Item Warehouse Details (IN204500) form. If the lot size is 0, then the system copies the Min Order Qty. value. If this value is also 0, then the system specifies a lot size of 1.

Attention:
The Item Warehouse Details (IN204500) form is used only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form and the warehouse-specific settings have been specified for the item.
Status The status of the BOM revision.
Description The description of the bill of material.
Level The level of the BOM relative to the parent BOM. For the top-level bill of material, the level is 0. For the subassembly of the top-level BOM, the level is 1. The system defines the levels of all nested subassemblies similarly.
Fixed Labor Time The total setup time for all operations of the BOM.
Variable Labor Time The total run time for all operations of the BOM.
Machine Time The total machine time for all operations of the BOM.
Item Class The item class of the stock item specified in the BOM.
Current Standard Cost The current standard cost if the item has the Standard valuation method. The system copies this value from the Price/Cost tab of the Stock Items (IN202500) or Item Warehouse Details (IN204500) form.
Attention:
The Item Warehouse Details (IN204500) form is used only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form and the warehouse-specific settings have been specified for the item.
Pending Standard Cost The pending cost if the item has the Standard valuation method. The system updates this value when you update pending costs by clicking the Update Pending button.
Source

The replenishment source of the stock item used in the BOM.

If the Multiple Warehouses feature is enabled on the (CS100000) form, this value is copied from the Source box on the Inventory Planning tab of the Item Warehouse Details (IN204500) form. If this feature is disabled, this value is copied from the Source box on the Inventory Planning tab of the Stock Items (IN202500) form.