Cost Roll-Up Register

 

Window Details

 

How Do I...

Navigation

 

Overview

 

 

 

Fields

 

 

 

Report Sample

 

 

 

 

 

Navigation

Use one of the following methods to access this task:

  • Select Bill of Materials Main menu > Cost Roll-Up Register. In Cost Roll-Up Register, click Print or Preview.
  • Select Production Management Main menu > Cost Roll-Up Register. In Cost Roll-Up Register, click Print or Preview.

    Note This task is available in the Production Management module if the module is integrated with Bill of Materials.

Overview

Use Cost Roll-Up Register to calculate the cost of each bill based on the cost of each component item and miscellaneous charge. The cost of all component bills assigned to the selected parent bill is recalculated, regardless of the number of levels involved. The standard cost for the inventory item is updated with the calculated cost following the completion of the report.

You can select whether to update the cost of the selected parent bills, or to update the cost of all component bills, regardless of the number of levels. Kit and option bills are not included in the cost calculation. Only the current revision of base bills is updated.

The cost of each component item can be selected to use the Average, Last, or Standard Cost method. Information provided on the register includes the bill number, description, revision (if applicable), calculated cost, old cost, and cost variance.

The Cost Roll-Up Register calculates costs based on Bill of Materials components and miscellaneous charges only. If the Production Management module is installed, and you want to use the labor and overhead costs established in Work Ticket Template Maintenance in the cost calculation (instead of miscellaneous charges), use the Production Management Cost Roll-Up Register.

Warning Do not, under any circumstances, interrupt the update process.

During the update process, the following occurs:

Note If the accounting date falls into a period closed in the general ledger, a warning appears and you will not be able to print or update.

Postings for standard cost items are updated to the general ledger when you update the Daily Transaction Register. Depending on your security setup, either the Daily Transaction Register is automatically printed and updated after you update the Cost Roll-Up Register, or you are prompted to print and update the Daily Transaction Register after updating the Cost Roll-Up Register.

Fields

 

Inventory Cost Type

Update Intermediate Bills

Effective Date

Include Materials From

Operand

Value