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.