Display Inventory Valuation Statistics

Use the Inventory Valuation Inquiry (IVQ) program to display the current value of inventory based on standard, actual, or average cost. See Road Map for work flow.

The program displays these fields:

Field Name	Displays
Item number	The number of the item
Description	The description of the item
Qty on hand Floor stock Total invty	The quantity of this item on hand at this branch The quantity of this item in floor stock at this branch The total quantity of this item: On hand + Floor stock Note Click Qty to cycle through these fields. Click Prog opts to set which field displays first. You can set the default option for the quantity on the Runtime options tab.
Standard cost Average cost Actual cost	The standard unit cost of this item at this branch The average cost of this item The actual cost (cost of the last purchase or cost of manufacturing) of this item Note Click Costs to cycle through these fields. Click Prog opts to set which field displays first. You can set the default option for the cost to be used on the Runtime options tab.
Value	The total value of the item: On hand, Floor stock, or Total quantity x Standard, Average, or Actual cost
Br	The branch for the item
Product class	The product class code for the item
Description	The description of the item
Inventory account code	The inventory account code selected in the item's record in the Enterprise Item Maintenance (IM) program
Make/Buy/Kit	B: Buy item K: Sell as a kitted item M: Make item

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See step 2.
Print the item listing	Click Print. See Print an Inquiry.
Go to a related program	Click Jump. See Jump.
Cycle through Standard cost, Average cost, and Actual cost	Click Costs.
Cycle through Qty on hand, Floor stock, and Total invty	Click Qty.
Display the quantities used, sold, manufactured, purchased, and booked per period for an item	Highlight a line and click Detail. See Display the Status of an Item. Click OK to return to this program.
Display standard, average, and actual unit costs for an item	Highlight a line and click Item costs. See Display Item Costs. Click OK to return to this program.
Display only the total value of inventory items and subtotal amounts if you select Subtotal? for a sort option	Click Totals. Click Totals again to redisplay detail.
Exit the program	Click Exit.

Review your saved options. To change them:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
2. Click the Sort tab to set sort order.
3. Click the Selection tab to select specific records.
4. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Include zero cost items?

Optional

Select to display all items, including those with zero cost, or leave blank to display only items with a cost greater than 0.

Include zero quantity items?

Optional

Select to display all items, including those with zero quantity, or leave blank to display only items with a quantity greater than 0.

If you select both Include zero cost items? and Include zero quantity items?, all items display.

If you select neither, only items that have both a cost and a quantity display.

Print only negative qtys?

Optional

Select to display only items with negative quantities or leave blank to display all items regardless of quantity.

Convert to currency

Conditional/Optional
2 alphanumeric

Select the code for the currency you want to display or leave blank to display the currency used for the transaction.

Curr exchange date

Conditional
10 date

Select the currency exchange date or enter a date shortcut.

Include tools?

Optional

Select if you want the list to include order code 4 tools:

Select	For
N	Do not include tools
Y	Include tools
O	Only list tools

1. Click Save to save these options for future use.
2. Click OK to apply these options and run the inquiry or click Cancel to exit without applying them.