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.
- A warehouse is specified in the Warehouse box on the Bill of Material (AM208000) form.
- A record for the item–warehouse pair exists on the Item Warehouse Details form.
- The Override Std. Cost check box is selected on the Price/Cost tab of the Item Warehouse Details form.
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:
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.
| 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:
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. |
