This appendix contains the following topics:
Section A.1, "JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports"
Section A.2, "JD Edwards EnterpriseOne Product Costing and Manufacturing Accounting Reports: A to Z"
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.
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 | 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 | 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 | 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 | 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. |
|
| R31425 | 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. |
|
| R31426 | Lists the standard costs on a work order parts list and the actual costs recorded for the parts issued. |
|
| R314271 | 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. |
|
| R31428 | 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. |
|
| R31811 | 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 | 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 | 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 | Lists work orders, their standard and current amounts, and their engineering variances. | Manufacturing Acctg Reports (G3123), Discrete Engineering Variance |
| R31814 | 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 | 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 | 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 | Displays detailed production costs and variance amounts for work orders. | Manufacturing Acctg Reports (G3123), Discrete Completed Order Variances |
This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.
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).
These processing options control default processing for the Costed Bill of Material report.
This processing option controls default values that the system uses when generating the report.
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.
These processing options control which information is displayed on the report.
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.
Specify the costs to be printed. Values are:
1: Simulated
2: Frozen
Specify the number of units to cost (for example, 10,000).
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.
These processing options control default processing for the Multi-Level Costed Bill report.
This processing option controls default values that the system uses when generating the report.
Specify the as of date for the bill of material. If you leave the field blank, the system uses the current date.
These processing options control which information is displayed on the report.
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.
Specify the costs to be printed. Values are:
1: Simulated
2: Frozen
Specify the units to cost (that is, 10,000).
These processing options control the print format of the report.
Specify 1 to print an indented Costed Bill of Material Report.
Specify 1 to print a unit cost line of detail. If left blank, only one line of detail will be printed for each item.
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. |
This processing option controls default processing for the Cost Component/Ledger Integrity report.
This processing option controls which information is included in the report.
Specify 1 to see report detail for all items processed. If left blank, only items with cost discrepancies will be printed.
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).
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).
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.
This processing option controls default processing for the Material Usage Variance report.
This processing option controls the data selection for the report.
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.
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.
These processing options control default processing for the Labor Rate Variance report.
This processing option controls the document type that you want to associate with labor variances.
Specify the origin and purpose of the transaction. The system reserves several prefixes for document types, such as vouchers, invoices, receipts, and timesheets.
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.
These processing options control default processing for the Work Order Labor Efficiency report.
These processing options specify the status range for work orders that you want to include in the report.
Specify the range of work order statuses to be selected for processing.
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.
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.