JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports

Appendix: JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports

This appendix provides an overview of JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting reports and enables you to:

View summary tables of all reports.
View report details for selected reports.

JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports

JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting reports provide a way for you to monitor product costs; verify the integrity of cost components; review standard, current, planned, actual, and completed amounts of work orders; assess labor efficiency; and review variance between standard or estimated costs against actual costs.

You can print reports to verify accuracy and track changes to product costing and manufacturing accounting data.

JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports: A to Z

This table lists the JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting reports, sorted alphanumerically by report ID.

Report ID and Report Name	Description	Navigation
R30440 Costed Bill of Material Report	Reviews the total cost of parent items detailed by component costs. Use this information to develop more accurate financial plans by monitoring product costs.	Product Costing Reports (G3023), Costed Bill
R30445A Multi-Level Costed Bill Report	Reviews lists of the total cost of parent items detailed by component costs. Use this information to develop more accurate financial plans by monitoring product costs.	Product Costing Reports (G3023), Multi Level Costed Bill
R30543 Cost Component/Ledger Integrity	Compares the sum of the frozen standard cost components for an item on the Enter Cost Components form (W30026B) and the unit cost in the Item Cost table (F4105) and reviews the variances.	Product Costing Reports (G3023), Cost Integrity
R31401 Accounting Summary (Closed Work Orders)	Lists completed work orders and their accumulated costs. This report lists the total standard and actual costs and the variance between the two. Actual costs are detailed by material, labor, and overhead.	Manufacturing Acctg Reports (G3123), Discrete Summary of Costs by Order Manufacturing Acctg Reports (G3123), Process Summary of Costs by Order
R31425 Purchase Price Variance Report	Lists the actual price paid for an item, the standard price that you estimated for the item, and the variance between the two. It also lists a percent of variance for each item and the total costs by item for the entire report.	Manufacturing Acctg Reports (G3123), Discrete Material Price Variance Manufacturing Acctg Reports (G3123), Discrete Material Price Variance
R31426 Material Usage Variances Report	Lists the standard costs on a work order parts list and the actual costs recorded for the parts issued.	Manufacturing Acctg Reports (G3123), Discrete Material Usage Variance - Std. Manufacturing Acctg Reports (G3123), Process Material Usage Variance - Std.
R314271 Labor Rate Variance Report	Lists current and standard labor rates, and hours or amounts. It details labor rate variances between the standard rates that you estimated and the actual rates that you charged, and lists the percentage of variance.	Manufacturing Acctg Reports (G3123), Discrete Labor Rate Variance Manufacturing Acctg Reports (G3123), Process Labor Rate Variance
R31428 Work Order Labor Efficiency Report	Provides a detailed analysis of direct labor efficiency hours accumulated for a work order. It lists standard and actual hours, and calculates the cost of the variance between them based on standard labor rates.	Manufacturing Acctg Reports (G3123), Discrete Labor Efficiency Manufacturing Acctg Reports (G3123), Process Labor Efficiency
R31811 Completed Work Order Valuation	Displays the standard, actual, completed, and outstanding balance amounts by cost component and item for completed work orders. The Manufacturing Journal Entries program (R31802A) and the Variances program (R31804) have already been run for these work orders. The report displays the total for each type of cost by work order and a grand total of each cost for all of the work orders listed.	Manufacturing Acctg Reports (G3123), Discrete Completed Order Valuation
R31812A Work Order Activity - Amounts	Lists standard, current, planned, actual, and completed amounts of work orders. The report lists the costs of the components first, and then the costs of the parents.	Manufacturing Accounting (G3116), Work Order Activity - Amounts
R31812B Work Order Activity - Units	Lists the standard, current, planned, actual, and completed units of work orders. The report lists the costs of components first, and then the costs of the parents.	Manufacturing Accounting (G3116), Work Order Activity - Units
R31813 Engineering Variance	Lists work orders, their standard and current amounts, and their engineering variances.	Manufacturing Acctg Reports (G3123), Discrete Engineering Variance
R31814 Planned Variance	Lists all work orders and their planned variances. The purpose of the report is to compare the current amounts to planned amounts.	Manufacturing Acctg Reports (G3123), Discrete Planned Variance
R31816 Labor Efficiency Variances	Displays planned and actual labor hours (all cost components except A1), extended by standard rates, and the monetary amount of variance by work order and item number.	Manufacturing Acctg Reports (G3123), Discrete Labor Efficiency Variances
R31817 Total/WIP and Other Variances	Displays the standard, actual, and completed amounts, as well as total and other variances by cost component and item for work orders.	Manufacturing Acctg Reports (G3123), Discrete Total/WIP and Other Variances
R31818 Work Order Variances - Amounts	Displays detailed production costs and variance amounts for work orders.	Manufacturing Acctg Reports (G3123), Discrete Completed Order Variances

JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting: Selected Reports

This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.

R30440 - Costed Bill of Material Report

You can customize this report to help you in the analysis; for example, you can:

Process the report using any valid cost method.
Process the report for simulated or frozen costs.
Specify a date in the processing options from which the information is retrieved if you do not want to use the current date.
Print all product costs and user-defined categories on the report.
Print the report for one branch, selected branches, or all branches.

This report presents the component costs in five user-defined cost buckets. In addition, the report displays totals of the cost buckets for each item. Each cost bucket can contain several cost components, depending on how you set up user-defined codes (UDCs).

Processing Options for Costed Bill of Material Report (R30440)

These processing options control default processing for the Costed Bill of Material report.

Defaults

This processing option controls default values that the system uses when generating the report.

As of Date

Specify the as of date for the bill of material. If you leave this option blank, the system uses the current date as the default value.

Display

These processing options control which information is displayed on the report.

Cost Method

Specify the cost method to be used, for example 01, 02, and 03. If you leave this option blank, the system uses cost method 07 (standard cost) as the default value.

Simulated/Frozen

Specify the costs to be printed. Values are:

1: Simulated

2: Frozen

Quantity - Requested Quantity

Specify the number of units to cost (for example, 10,000).

R30445A - Multi-Level Costed Bill Report

You can customize this report to help you in the analysis; for example, you can:

Specify the number of units that the program costs when you run the report.
Process the report using any valid cost method.
Process the report for simulated or frozen costs.
Specify a date for the program to use as a criterion when accessing information.
Print all product costs and user-defined categories on the report.
Print the report for one branch, selected branches, or all branches.

This report presents the component costs in five user-defined cost buckets. In addition, the program totals the cost buckets for each item. Each cost bucket can contain several cost components, depending on how you set up UDCs.

Processing Options for Multi-Level Costed Bill Report (R30445A)

These processing options control default processing for the Multi-Level Costed Bill report.

Defaults

This processing option controls default values that the system uses when generating the report.

As of Date

Specify the as of date for the bill of material. If you leave the field blank, the system uses the current date.

Display

These processing options control which information is displayed on the report.

Cost Method

Specify the cost method to be used. If you leave this option blank, the system uses cost method 07 (standard cost) as the default value.

Simulated / Frozen

Specify the costs to be printed. Values are:

1: Simulated

2: Frozen

Quantity - Requested Quantity

Specify the units to cost (that is, 10,000).

These processing options control the print format of the report.

Indented Report Switch	Specify 1 to print an indented Costed Bill of Material Report.
Unit Cost Detail	Specify 1 to print a unit cost line of detail. If left blank, only one line of detail will be printed for each item.

R30543 - Cost Component/Ledger Integrity

For cost level 3 items, the program uses the unit cost for the primary location of the item in the Item Cost table.

Note. If you use actual costing, do not run this report because it does not produce accurate and relevant information about the company's costs.

Processing Options for Cost Component/Ledger Integrity (R30543)

This processing option controls default processing for the Cost Component/Ledger Integrity report.

Report Option

This processing option controls which information is included in the report.

Selection value

Specify 1 to see report detail for all items processed. If left blank, only items with cost discrepancies will be printed.

R31401 - Accounting Summary - Closed Work Orders

The system retrieves this information when you run the report:

Labor and miscellaneous costs come from values in the Work Order Time Transactions table (F31122) for the work order.
Overhead costs are the machine hours in the Work Order Time Transactions table multiplied by the overhead rates entered for the work center in the Work Center Rates table (F30008).
The total actual cost is the accumulated detail for labor, overhead, material, and miscellaneous costs.
The total standard cost is the number of items completed on the work order multiplied by the parent item's frozen standard cost from the Item Cost table (F4105).

R31425 - Purchase Price Variance Report

The system retrieves this information when you run the report:

Standard costs from the Item Cost table (F4105).
Actual costs from the Purchase Order Receiver table (F43121).

R31426 - Material Usage Variances Report

The report contains these elements:

The standard units required on a work order.
The actual units consumed.
The variance between the two in both units and cost.

The system performs these calculations:

The standard units are the parent quantity specified on the work order or the quantity of the component specified on the work order parts list.

When the work order is completed (status 99), the report lists the work order quantity completed, rather than the original parent quantity ordered.
The variance percentage results from the actual units or amounts divided by the standard units or amounts.

The variance percentage provides an accuracy value. For example, an accuracy value of 100.00 indicates that the planned quantity or amount was the same as the actual quantity or amount used.

Processing Options for Material Usage Variances Report (R31426)

This processing option controls default processing for the Material Usage Variance report.

Option

This processing option controls the data selection for the report.

Selection value

Specify the data selection value. You can select multiple specific values.

1: The primary sequence is by component item number.

*VALUES: Display a special display screen allowing the entry of up to 45 specific values. If you specify *VALUES in multiple selections of the original display, you will be prompted for multiple values lists.

*BLANKS: Search on a blank value. You cannot leave the values field blank to search on blanks. In this case *ALL is the default value.

*ZEROS: Search for amounts equal to zero.

*RANGE: Display a special display screen which allows the entry of a range of values (that is, from 1 to 50). The first value MUST be LESS than the second value. If it is equal or greater than, it will not work.

*ALL: Select all values for a field.

R314271 - Labor Rate Variance Report

The system performs the calculations based on this information:

The standard rates come from the Work Center Rates table (F30008).
The standard hours come from the Work Order Routing table (F3112).
The actual amounts are the actual hours from the Work Order Time Transactions table (F31122) multiplied by the standard rate.

Processing Options for Labor Rate Variance Report (R314271)

These processing options control default processing for the Labor Rate Variance report.

Document Type

This processing option controls the document type that you want to associate with labor variances.

Document Type

Specify the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets.

R31428 - Work Order Labor Efficiency Report

The system retrieves this information:

The actual values, which are the values from the Work Order Time Transactions table (F31122) for the operation sequence and employee.
The frozen standard hours, which are from the Work Order Routing table (F3112).
The frozen standard labor rates, which are from the Work Center Rates table (F30008), based on the type code for the operation sequence.

Processing Options for Work Order Labor Efficiency Report (R31428)

These processing options control default processing for the Work Order Labor Efficiency report.

WO Status

These processing options specify the status range for work orders that you want to include in the report.

Work Order Status Range (Optional)	Specify the range of work order statuses to be selected for processing.
From Work Order Status	Enter a user-defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from 90 through 99 triggers the system to automatically update the completion date.
To Work Order Status	Enter the next status for a work order, according to the work order activity rules, as the work order moves through the approval route. You must define a status code as a work order status in the Work Order Activity Rules table before you can use it as a next status.