Open topic with navigation

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

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 Work Order module is installed, and you want to use the labor and overhead costs established in Routing Maintenance in the cost calculation (instead of miscellaneous charges), use the Work Order Cost Roll-Up Register.

Warning 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.

After printing the Cost Roll-Up Register, review it for accuracy. If there are errors, return to Bill of Materials Maintenance and make the necessary changes. Then reprint the Cost Roll-Up Register and proceed with the update.

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

During the update process, the following occurs:

• The standard cost of each bill in the Item file is updated.

• If cost roll-up is performed on inventory items using the Standard Cost method, the appropriate general ledger adjustments are posted to the inventory and adjustment accounts. The amount of the adjustment for each item appears in the Extension column of the report. This amount is calculated by multiplying the quantity-on-hand amount by the variance adjustment amount (old standard cost minus new standard cost). The adjustment amount is debited to the inventory account and credited to the manufacturing variance account. The actual account numbers used are specified in the Inventory Management Product Line Maintenance task.

If there are postings to the general ledger for standard cost items, you are prompted to print the Daily Transaction Register and update the general ledger entries posted from the Cost Roll-Up Register.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks