This chapter contains the following topics:
Section 6.1, "JD Edwards EnterpriseOne Advanced Stock Valuation Reports: A to Z"
Section 6.2, "JD Edwards EnterpriseOne Advanced Stock Valuation: Selected Reports"
This table lists the JD Edwards EnterpriseOne Advanced Stock Valuation Reports, sorted alphanumerically by report ID.
| Report ID and Report Name | Description | Navigation |
|---|---|---|
| R39220 | Use this report as often as necessary to calculate the stock value you use for forecasting. | Access Batch Versions by typing BV in the Fastpath. On Available Versions, enter R39220 in the Batch Application field and click Find. Select a version of the Annual Layered Fiscal Report (R39220) and select Processing Options from the row menu. |
| R39400 | Use this report to display First In, First Out (FIFO), Last In, First Out (LIFO), weighted average cost, or replacement cost valuation methods in detail by item and pool.
For each item and pool, this report displays the openings, incomings, outgoings, and closings for the year to date or for the current period. This report also displays the GL Update methods. |
Select Stock Valuation Reports menu (G3920), Stock Valuation Detail Report. |
| R39500 | Use this report to display a summary of stock valuation information by valuation method for each item and pool. | Select Stock Valuation Reports (G3920), Stock Valuation Summary Report. |
| R39510 | Use this report to display a summary of the stock valuation information that will be updated to the general ledger. | Select Stock Valuation Reports (G3920), General Ledger Update Summary Report. |
| R39540 | Provides the average cost of each item or pool for selected periods, based on valuation method. | Select Stock Valuation Reports (G3920), Unit Cost Period Report. |
This section provides detailed information, including processing options, for individual reports. The reports are listed alphanumerically by report ID.
This report uses the average unit cost unless you set the processing option to override the average unit cost with a substitute cost. Before you override the average unit cost, you must complete these fields in the Item Pool Valuation Cost Master (F3908) table:
Enter the substitute cost in the Unit Cost field.
Enter the last day of the fiscal year in the Effective Thru Date field.
The R39220 program also uses data from the F3908 table when you use the Replacement Cost method to determine stock value. If you override the average unit cost with a substitute cost, you cannot use the Replacement Cost method.
You can run the Annual Layered Fiscal report as often as necessary to calculate the stock value you use for forecasting.
The Annual Layered Fiscal report contains:
Valuation method.
Currency code.
Company.
Item or item pool number and description.
Quantity, average purchasing unit cost, and monetary amount by year for each business unit.
Total quantity and monetary amount for each business unit.
Total quantity and monetary amount for the company.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify the date and the cost method that the system uses for processing stock valuation records.
Specify the general ledger date that the system uses as the closing date. The general ledger date must equal the Thru Date from the Item Pool Valuation Cost Master table (F3908) to ensure that the system uses normal costs when processing the current year. If you leave this processing option blank, the system uses the current date.
Specify whether to override the average unit cost with the normal cost when processing the report. Values are:
Blank: Average unit cost.
1: Normal cost.
You must set up the normal cost in the Item Pool Valuation Cost Master table (F3908) with the thru date equal to the end date of the fiscal year. The general ledger date from the G/L Date processing option must equal the thru date in the F3908 table in order for the system to use the normal cost when processing the current year.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify the information that appears on the Stock Valuation Detail Report when it is printed.
Specify whether to print the report using valuation methods. Values are:
Blank: Prints the report using all valuation methods.
1: Prints the report using the GL update valuation method for each item pool.
Specify whether to omit or include the period incoming and outgoing quantities along with the amount on the LIFO report. Values are:
Blank: Omits the period incoming and outgoing quantities along with the amount from the report.
1: Prints the period incoming and outgoing quantities on the report along with the year to date quantities and amounts for LIFO valuation methods.
Specify whether to omit or include dual currency amounts on the report. Values are:
Blank: Omits the dual currency amounts on the report.
1: Includes the dual currency amounts on the report.
Processing options enable you to specify the default processing for programs and reports.
This processing option specifies the dual currency amount used in the Stock Valuation Summary Report.
Specify whether to omit or include the dual currency amounts on the report. Values are:
Blank: Omits the dual currency amounts on the report.
1: Includes the dual currency amounts on the report.
Processing options enable you to specify the default processing for programs and reports.
This processing option specifies the dual currency amount that the system uses for processing the general ledger update.
Specify whether to omit or include dual currency amounts on the report. Values are:
Blank: Omit the dual currency amounts from the report.
1: Include the dual currency amounts on the report.
After you run the Period Build program (R39120), you can generate a report to verify the accuracy and completeness of the valuation. The Unit Cost Period Report program (R39540) provides the average cost of each item or pool for selected periods, based on valuation method. You can specify in a processing option whether to display domestic or dual currency.
Processing options enable you to specify the default processing for programs and reports.
These processing options specify how to process the Unit Cost Period Report.
Specify the Fiscal Period to display on the report.
If you leave this option blank, the system displays the current fiscal period for the company.
Specify the fiscal year of the first period to display on the report.
If you leave this option blank, the system displays the current fiscal period for the company.
Displays average unit costs for the closing period on the report. Values are:
Blank: Displays the average unit cost for incoming transactions.
1: Displays the average unit cost for closing inventory.
Specify whether to omit or include the dual currency amounts on the report. Values are:
Blank: Omits the dual currency amounts from the report.
1: Includes the dual currency amounts on the report.