Previous  Next          Contents  Index  Glossary  Library

Inventory Value Report

Use the Inventory Value Report to show quantity, valuation, and detailed item information for the subinventories you specify.

Report Submission

In the Submit Requests window, select the report name.

Report Parameters

Cost Type

Select a cost type. If you choose a cost type other than Frozen or Average (depending on your costing method), the system values the items at this cost type. If that 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 Option

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. If you choose the Subinventory, Item sort option, the report prints all items in each subinventory. If you choose either the Item or Category, Item sort option, the report prints the subinventory where 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 one line for each item showing the quantity and extended value.

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 you defined for the 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

Choose 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.

Quantities by Revision

Select Yes or No to indicate whether to display item quantities by the revision of the item on the report.

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.

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 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.

See Also

Submitting a Request

Entering Period Rates


         Previous  Next          Contents  Index  Glossary  Library