All Inventories Value Report (Oracle Cost Management)


	Previous	Next		Contents	Index	Glossary	Library

All Inventories Value Report

This report lists the quantity and value of items for all inventory for the specified cost type. If you run this report using either the Frozen or Average cost type, depending on the costing method, the subinventories (stock) and intransit items are valued at current Frozen standard or Average costs. The system always values receiving inspection at the purchase order cost for items regardless of costing method. If you choose a non-implemented (not Frozen or Average) cost type, the items are valued at their total cost in that cost type.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

Cost Type

Select a cost type. If you select a non-implemented cost type, the system values the items at this cost type. If the cost type is not available, the system values the items at the default cost type. For example, if you choose Quarter1 as the cost type and Quarter1 has Frozen as the default cost type, the system values the item at the Quarter1 cost. If Quarter1 is not available, it values the items at the Frozen cost type.

Sort Option

Choose one of the following options:

Item Sort by inventory item. The system displays this option as the default.

Category, Item Sort by category, and then by item within category.

Report Option

Choose one of the following options:

Display quantities and values Report both quantities and values for each inventory type, subinventories, intransit inventory and receiving inspection, as well as the total quantity and value for the current organization. The system displays this option as the default.

Display quantities only Report quantities only for each inventory type, subinventories, intransit inventory and receiving inspection, as well as the total quantity and value for the current organization.

Item From/To

To restrict the report to a range of items, select a beginning and an ending item.

Category Set

Select a category set. The value of all inventory types, subinventories, intransit inventory and receiving inspection is reported for items associated with this category set. The default is the category set you defined for your costing functional area.

Category From/To

To restrict the report to a range of categories, select a beginning and an ending category.

Currency

Select a currency. You can run this report for any defined currency. When you select a currency other than the functional currency, item costs are converted to the selected currency using the End of period rate you choose in the Exchange Rate field.

Exchange Rate

Select an exchange rate. If you choose a currency other than the functional currency, the system displays the most recent End of period rate as the default. However, you can choose any prior End of period rate.

Display Zero Costs Only

Select Yes or No to indicate whether to print zero cost items only in the report. Select No to find valuation issues.

Include Expense Items

Select Yes or No to indicate whether to include expense items in the report. When you select Yes, this option includes quantities for expense items in asset subinventories. To include expense items in all subinventories, select Yes for both the Include Expense Items and the Include Expense Subinventories parameters. These quantities are not valued.

Include Expense Subinventories

Select Yes or No to indicate whether to include expense subinventories in the report. When you select Yes, this option includes quantities for asset items in expense subinventories. To include all items in expense subinventories, select Yes for both the Include Expense Items and the Include Expense Subinventories parameters.

Item	Sort by inventory item. The system displays this option as the default.
Category, Item	Sort by category, and then by item within category.

Display quantities and values	Report both quantities and values for each inventory type, subinventories, intransit inventory and receiving inspection, as well as the total quantity and value for the current organization. The system displays this option as the default.
Display quantities only	Report quantities only for each inventory type, subinventories, intransit inventory and receiving inspection, as well as the total quantity and value for the current organization.