## JD Edwards EnterpriseOne Advanced Stock Valuation Reports

This appendix provides an overview of JD Edwards EnterpriseOne Advanced Stock Valuation reports and enables you to:

- View summary tables of all reports.

- View report details and tables accessed.

### JD Edwards EnterpriseOne Advanced Stock Valuation Reports: A to Z

This table lists the JD Edwards EnterpriseOne Advanced Stock Valuation Reports, sorted alphanumerically by report ID.

Report ID and Report Name | Description | Navigation
R39220 Annual Layered Fiscal Report | 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 Stock Valuation Detail Report | 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 Stock Valuation Summary Report | 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 General Ledger Update Summary Report | 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 Unit Cost Period Report | 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.

### JD Edwards EnterpriseOne Advanced Stock Valuation: Selected Reports

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

#### R39220 - Annual Layered Fiscal Report

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 for the Annual Layered Fiscal Report (R39220)

Processing options enable you to specify the default processing for programs and reports.

Process

These processing options specify the date and the cost method that the system uses for processing stock valuation records.

1. G/L Date (general ledger date) | 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.
2. Normal Cost | 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 for the Stock Valuation Detail Report (R39400)

Processing options enable you to specify the default processing for programs and reports.

Print Report

These processing options specify the information that appears on the Stock Valuation Detail Report when it is printed.

1. G/L Update valuation method (general ledger update valuation method) | 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.
2. Period incoming and outgoing for LIFO | 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.
3. Dual currency amounts | 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 for the Stock Valuation Summary Report (R39500)

Processing options enable you to specify the default processing for programs and reports.

Dual Currency

This processing option specifies the dual currency amount used in the Stock Valuation Summary Report.

Dual Currency Amount | 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 for the General Ledger Update Summary Report (R39510)

Processing options enable you to specify the default processing for programs and reports.

G/L Update Sum

This processing option specifies the dual currency amount that the system uses for processing the general ledger update.

Dual Currency Amount | 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.

#### R39540 - Unit Cost Period 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 for Unit Cost Period Report (R39540)

Processing options enable you to specify the default processing for programs and reports.

Process

These processing options specify how to process the Unit Cost Period Report.

1. Enter the Fiscal Period | 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.
2. Enter the Fiscal Year | 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.
3. Cost for Closing Inventory | 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.
4. Dual Currency Amounts | 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.