Generate job order cost variance report

Use the Job Order Cost Variance report to generate a summary of hours, material costs, labor costs, and overhead costs. Both estimated and actual numbers are shown, in addition to a percentage variance. Sub-jobs are only included if they meet sort order and sort range criteria. The purpose of this report is to compare job order estimated to actual costs.

This report will reflect the total number of hours charged to the operations in the job order routing and may not match the time allocated to each operation in the Labor Input Detail report. However, the labor and overhead costs in this report are accurate, reflecting the actual costs charged to the job.

By default, generic filters are available to generate this report. You can use Advanced Filters to customize or expand your filter criteria. For more information about Advanced Filters, click here.

To generate job order cost variance report

1. Open the Job Order Cost Variance (RPJOCV) page.

   1. Select Production Management > Production Reports > Job Orders > Job Order Cost Variance.

   Or

   2. Search for RPJOCV or Job Order Cost Variance in the Navigation box and then select Job Order Cost Variance.

   Job Order Cost Variance (RPJOCV) page appears.

2. In the Selection dropdown, select the information you want to view.

3. In the Sort Order dropdown, select how to sort the report.

   The Sort Order list is populated based on the type of report selected in the Selection list.

4. In the Layout dropdown, select the layout in which you want to view the report.

   The Layout list is populated based on the type of report selected in the Selection list.

5. In the Date Range area, specify the date range for the report to be generated. You can select the date from the From and To fields only if you select the Custom option in the Fill Dates list.

   The Date On field is populated based on the type of report selected in the Selection list.

   To include the entire time frame, leave the date fields blank.

   In the Fill Dates dropdown, you can select from the predefined date ranges. They are:

   • Custom:
     Select this option to enable the From and To fields in the Date Range area.

   • Calendar Year:
     Select this option to display the Calendar Year list. You can select any of the predefined calendar year formats from the list.

   • GL Periods:
     Select this option to display the GL Periods list. You can select any of the predefined GL period formats from the list.

6. In the Sort Range list, specify the sort range.

   The Sort On field is populated based on the type of report selected in the Selection list.

   The available sort ranges are:

   • Single: Select this option to include only one item. Selecting this option enables the From field. Do one of the following:

     • Type the item reference in the From field.

     • Click the Lookup Reference and from the Lookup For From window, select the required sort item, and click Select.

   • Range: Select this option to include a range of items to sort from. Selecting this option enables the From and To fields. Do one of the following:

     • Type the first and last values of the range in the From and To fields.

     • Click the Lookup Reference (if available) and from the Lookup For window, select the required sort item, and click Select.

   • All: Select this to include all available items.

7. In the Other Variables section, filter the report generation based on Part Revision, Facility or other variables.

   The Other Variables section is not available when you select Job Order - Operation Level in the Selection list.

8. On the Toolbar, click Run Report.

   Select Open now to open the report in a new tab or select Notify when Complete to get notification. You can open the downloaded report from My Reports page.

​