W/O Cost Roll-Up Register

 

Window Details

 

How Do I...

Navigation

 

Print a Journal or Register

Overview

 

 

 

Fields

 

 

 

 

Navigation

Select Work Order Main menu > Cost Roll-Up Register. In the Work Order Cost Roll-Up Register window, click Print.

Warning If the accounting date falls into a period closed in the General Ledger module, a warning displays and you will not be able to print or update.

Overview

The W/O Cost Roll-Up Register calculates the cost of each bill based on the cost of each component in its bill of materials with yield and scrap percentages included. The cost of all component bills assigned to the specific parent bill is recalculated, regardless of the number of levels involved. Labor and Overhead costs are calculated using the routing assigned to the bill. The standard cost for the parent item of a bill is updated with the calculated cost following the completion of the report.

The cost of each component item can be specified to use the average, last, or standard cost. In addition, scrap and yield percentages can be factored into the material cost. The labor and overhead amounts are calculated based on the information contained in the product routing specified for the bill.

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

If cost roll-up is performed on inventory items using the Standard Cost Valuation method, the appropriate general ledger adjustments are posted to the Inventory and Manufacturing Variance Adjustment accounts.

Note Save the most recently printed report as an audit trail.

Review the register for accuracy before updating.

Warning Do NOT, under any circumstances, interrupt the update.

If there are errors, make the necessary changes in W/O Cost Roll-Up Register, and then reprint the register and proceed with the update. When the update is complete, the Work Order Cost Roll-Up file is cleared.

Fields

 

Inventory Cost Type

Effective Date

Update Intermediate Bills

Bill Number

 

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