Elemental Inventory Value Report (Oracle Cost Management)


	Previous	Next		Contents	Index	Glossary	Library

Elemental Inventory Value Report

This report lists the subinventory quantity and value of items by cost element. Elemental values are the material, material overhead, resource, overhead, and outside processing cost elements of inventory items. This report prints the extended value of each cost element for the range of items you choose.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

Cost Type

Select a cost type. If you choose a different 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. An asterisk (*) next to the total indicates the unit cost is from the default cost type.

Sort

Choose one of the following options:

Item Sort by inventory item.

Category, Item Sort by category and then by item.

Subinventory, Item Sort by subinventory and then by item.

Report Option

Choose one of the following options:

Detail Include detail information. If you choose the Subinventory, Item sort option, the report prints the elemental cost for all items in each subinventory. If you choose either the Item or Category, Item sort option, the report prints the elemental cost for each subinventory the item has an on-hand balance.

Summary Include only summary information. If you choose the Subinventory, Item sort option, the report prints the elemental cost distribution for each subinventory. If you choose either the Item or Category, Item sort option, the report prints the elemental cost distribution for each item.

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 system reports the value of all items associated with this category set. The category set defined for your costing functional area is the default.

Category From/To

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

Subinventory From/To

To restrict the report to a range of subinventories, select a beginning and an ending subinventory.

Currency

Select a currency. You can run this report for any defined currency. When you enter 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. Your functional currency is the default.

Exchange Rate

Select an exchange rate. If you choose a currency other than your 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.

Negative Quantities Only

Select Yes or No to indicate whether to report only items with negative quantities.

Display Zero Costs Only

Select Yes or No to indicate whether to report only items with zero costs in the chosen cost type.

Include Expense Items

Select Yes or No to indicate whether to include expense items on the report.

Include Zero Quantities

Select Yes or No to indicate whether to report items with zero on-hand quantities.

Include Unvalued Transactions

Select Yes or No to indicate whether to report unvalued transactions. There are transactions that have no accounting entries because they have not been valued by the Material Cost Transaction Processor.

Attention: If you set this option to Yes and you have unvalued transactions, the balance reported will not tie to your general ledger balances.

Item	Sort by inventory item.
Category, Item	Sort by category and then by item.
Subinventory, Item	Sort by subinventory and then by item.

Detail	Include detail information. If you choose the Subinventory, Item sort option, the report prints the elemental cost for all items in each subinventory. If you choose either the Item or Category, Item sort option, the report prints the elemental cost for each subinventory the item has an on-hand balance.
Summary	Include only summary information. If you choose the Subinventory, Item sort option, the report prints the elemental cost distribution for each subinventory. If you choose either the Item or Category, Item sort option, the report prints the elemental cost distribution for each item.