Roll Up Costs

Use the Standard Cost Rollup (MCR) program to update the standard cost of items and update the general ledger if you have inventory interfaced to the GL. See Background, Overview: Interfacing Inventory to GL and Road Map for more information.

The program displays in-process batches:

Field Name	Displays
Batch	The batch number assigned when the batch was created
Status	The status of the batch
User	The user ID of the person that created the batch
Date/time	The date and time the batch was created
Preview work file	The work file created when costs are rolled up but not updated

Choose the appropriate options:

To	Do This
Add a batch	Click Add. See step 2.
Delete a batch	Highlight the batch and click Delete. See Delete.
Copy a batch	Highlight the batch and click Copy.
Display a batch	Highlight the batch and click Select or double click the line. See step 3.
Print the batch listing	Click Print.
Exit the program	Click Exit.

The program prompts Batch. Enter NEW or # if you want program to assign the next available batch number, which you use to track this cost rollup, and press Enter. Use the Batch Number Setup program to set up a batch numbering scheme.

OR

Enter a unique identifier (12 alphanumeric characters maximum) for the batch you want to create and press Enter. You can do this only if the Allow manual assignment? option in Batch Number Setup is selected for this program.

OR

Enter * to create or change the default record. See Create a Default Record for a Maintenance Program.

The program prompts Branch. Accept the displayed branch or click the Lookup icon to select another branch.

If you roll up costs for your manufacturing branch, updated costs may be copied to some or all of the branches in your inventory branch group (controlled by the Copy new costs to branches in cost roll? option in System Options Maintenance (XM) - Inventory Control Options).
Click OK or Register to set your options:

Note
If options were previously selected for this batch, they can be changed until the batch is in update mode. Once in update mode, Runtime and Sort options for register output can be changed, but Selection and Program options are disabled.

Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click the Sort tab to set the sort order.
Click the Selection tab to select specific records.
Click the Program tab to set these program specific options:

Field Name	Type / Max Length	Action / Description
Include items with no cost change?	Optional	Select if you want to roll up the cost of items whose costs have not changed since the last cost rollup
Only items with zero unit cost?	Optional	Select if you want to only roll up the cost of items that currently have zero cost or leave blank to roll up the cost of all items that meet your selection criteria.
Calculate labor and overhead?	Optional	Select to calculate labor, labor overhead, and outside service costs based on the item's routing or leave blank to use the incremental labor, overhead, and outside service costs as displayed in the Item Cost Maintenance (ICM) program.
Default labor rate	Optional 14 numeric in the format 999999999.99999	Enter the rate to use only if the Direct labor cd field in the Routing Maintenance (RTM) program is no longer associated with a rate in the Labor Rates Maintenance (TLR) program.
Default overhead rate	Optional 14 numeric in the format 999999999.99999	Enter the rate to use only if the Overhead code 1 - 4 fields in the Item Cost Maintenance (ICM) or Work Center Maintenance (WCM) program is no longer associated with a rate in the Overhead Rate Codes Maintenance (TORC) program.
Default machine rate	Optional 14 numeric in the format 999999999.99999	Enter the rate to use *only if* the code for the Machine labor cd field Work Center Maintenance (WCM) program has no associated rate in the Labor Rates Maintenance (TLR) program.
Default setup rate	Optional 14 numeric in the format 999999999.99999	Enter the rate to use only if you selected a code for the Setup labor cd field in the Routing Maintenance (RTM) program that has no associated rate in the Labor Rates Maintenance (TLR) program.
List file name	Optional	Select a saved list of item numbers to roll up. See Create a List of Items for Cost Roll Up.

Choose the appropriate options:

To	Do This
Review the preview register on your screen	Click View. See Background for a list of what displays. The program prompts Register is complete; proceed with update? Click OK to update costs or click Cancel to retain the work file. The name of the work file is displayed and the file is retained for the life of the cost roll batch. The work file can be used to generate reports showing the old and new costs.
Print the preview register	Click Print. See Background for a list of what prints. The program prompts Register is complete; proceed with update? Click OK to update costs or click Cancel to retain the work file. The name of the work file is displayed and the file is retained for the life of the cost roll batch. The work file can be used to generate reports showing the old and new costs.
Save these options for future use	Click Save.
Redisplay selected options	Click Refresh.
Create a list of items whose costs you want to roll up	Click List to create a list of items that are not sequentially numbered. A green check mark on the List button indicates a list of items exists. See Create a List of Items for Cost Roll Up.
Exit the program	Click Exit.

Based on how you set the Include print of GL journal? Runtime option in this program, the GL journal may be printed in preview and/or final mode.
If inventory is interfaced to the general ledger (set in System Options Maintenance (XM) - Inventory Control Options), the general ledger may also be updated. See System Options Maintenance (XM) - GJ Journal Options settings for the GJZ - Standard Cost Rollup journal.