3.7.3.�Quantities on Hand

3.7.3.1. Quantities on Hand by Class Code
3.7.3.2. Quantities on Hand by Item Group
3.7.3.3. Quantities on Hand by Location
3.7.3.4. Quantities on Hand by Item

Quantities on Hand Reports section.

3.7.3.1.� Quantities on Hand by Class Code

To view Quantities on Hand by Class Code, select the "Quantities on Hand by Class Code" option. The following screen will appear:

Quantities on Hand by Class Code

When displaying Quantities on Hand by Class Code, you are presented with the following options:

All Class Codes

Select to display Quantities on Hand for all Class Codes.

Selected

Specify Class Code whose Quantities on Hand you want to display.

Pattern

Enter a Class Code pattern to select a range of Class Codes. Refine your search using Regular Expressions, as described in Section�1.2.9, “Topic: Pattern Matching with Regular Expressions”.

All Warehouses

Select to display Quantities on Hand by Class Code for all Warehouses.

Selected

Specify Warehouse whose Quantities on Hand by Class Code you want to display.

Order By

Order the output by one of the following methods:

Item Number: Select to order the display by Item Number.
Value: Select to order the display by value.

Show All Quantities

Select to show all Quantities on Hand in the display.

Only Show Positive QOHs

Select to show only Inventory with a positive Quantity on Hand in the display.

Only Show Negative QOHs

Select to show only Inventory with a negative Quantity on Hand in the display.

Show Inventory Value

Select to include the Inventory value of Quantities on Hand by Class Code in the display. Specify whether to display Inventory value using Standard Costs or Actual Costs.

Use Standard Costs

Select to show Inventory value based on Standard Costs.

Use Actual Costs

Select to show Inventory value based on Actual Costs.

Quantities on Hand

Display lists Quantities on Hand by Class Code, using the specified parameters. If the "Show Inventory Value" box is selected, the display will also show unit Cost, value, and non-netable value. Totals for each column will be calculated at the bottom of the display. If a Quantity on Hand value displays in the color orange, this means the actual or projected Quantity on Hand is at or below the Reorder Level. If the color is red, the current or projected Quantity on Hand is below 0.

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters.
PRINT: Runs the report associated with this screen.

Right-clicking on an Item in the Quantities on Hand list enables you to select from the following menu options:

Transfer to another Warehouse: Select to transfer Inventory from the specified Warehouse to another Warehouse.
Adjust this QOH: Select to enter a Miscellaneous Adjustment for the specified Item Site.
Reset this QOH to 0: Select to change the Quantity on Hand for the specified Item Site to zero.
Enter Misc. Count: Select to enter a Miscellaneous Inventory Count for the specified Item Site.
Issue Count Tag: Select to create a Count Tag for the specified Item Site.
Export Contents: Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.7.3.2.� Quantities on Hand by Item Group

To view Quantities on Hand by Item Group, select the "Quantities on Hand by Item Group" option. The following screen will appear:

Quantities on Hand by Item Group

When displaying Quantities on Hand by Item Group, you are presented with the following options:

All Item Groups

Select to display Quantities on Hand for all Item Groups.

Selected

Specify Item Group whose Quantities on Hand you want to display.

Pattern

Enter an Item Group pattern to select a range of Item Groups. Refine your search using Regular Expressions, as described in Section�1.2.9, “Topic: Pattern Matching with Regular Expressions”.

All Warehouses

Select to display Quantities on Hand by Item Group for all Warehouses.

Selected

Specify Warehouse whose Quantities on Hand by Item Group you want to display.

Order By

Order the output by one of the following methods:

Item Number: Select to order the display by Item Number.
Value: Select to order the display by value.

Show All Quantities

Select to show all Quantities on Hand in the display.

Only Show Positive QOHs

Select to show only Inventory with a positive Quantity on Hand in the display.

Only Show Negative QOHs

Select to show only Inventory with a negative Quantity on Hand in the display.

Show Inventory Value

Select to include the Inventory value of Quantities on Hand by Item Group in the display. Specify whether to display Inventory value using Standard Costs or Actual Costs.

Use Standard Costs

Select to show Inventory value based on Standard Costs.

Use Actual Costs

Select to show Inventory value based on Actual Costs.

Quantities on Hand

Display lists Quantities on Hand by Item Group, using the specified parameters. If the "Show Inventory Value" box is selected, the display will also show unit Cost, value, and non-netable value. Totals for each column will be calculated at the bottom of the display. If a Quantity on Hand value displays in the color orange, this means the actual or projected Quantity on Hand is at or below the Reorder Level. If the color is red, the current or projected Quantity on Hand is below 0.

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters.
PRINT: Runs the report associated with this screen.

Right-clicking on an Item in the Quantities on Hand list enables you to select from the following menu options:

Transfer to another Warehouse: Select to transfer Inventory from the specified Warehouse to another Warehouse.
Adjust this QOH: Select to enter a Miscellaneous Adjustment for the specified Item Site.
Reset this QOH to 0: Select to change the Quantity on Hand for the specified Item Site to zero.
Enter Misc. Count: Select to enter a Miscellaneous Inventory Count for the specified Item Site.
Issue Count Tag: Select to create a Count Tag for the specified Item Site.
Export Contents: Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.7.3.3.� Quantities on Hand by Location

To view Quantities on Hand by Location, select the "Quantities on Hand by Location" option. The following screen will appear:

Quantities on Hand by Location

When displaying Quantities on Hand by Location, you are presented with the following options:

All Warehouses: Select to display Quantities on Hand for all Warehouses.
Selected: Specify Warehouse whose Quantities on Hand by Location you want to display.
Location: Specify Location whose Quantity on Hand you want to display. Displays Quantity on Hand for selected Location.
Netable: Indicates whether Location is Netable or not.
Restricted: Indicates whether Location is Restricted or not.
Quantities on Hand: Display lists Quantities on Hand by Location, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters.
PRINT: Runs the report associated with this screen.

Right-clicking on an Item in the Quantities on Hand list enables you to select from the following menu options:

Export Contents: Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.7.3.4.� Quantities on Hand by Item

To view Quantities on Hand by Item, select the "Quantities on Hand by Item" option. The following screen will appear:

Quantities on Hand by Item

When displaying Quantities on Hand by Item, you are presented with the following options:

Item Number: Enter the Item Number of the Item whose Quantity on Hand you want to display.
UOM: Inventory Unit of Measure.
All Warehouses: Select to display Quantities on Hand by Item for all Warehouses.
Selected: Specify Warehouse whose Quantities on Hand by Item you want to display.
Show Inventory Value: Select to include the Inventory value of Quantities on Hand by Item in the display. Specify whether to display Inventory value using Standard Costs or Actual Costs.
Use Standard Costs: Select to show Inventory value based on Standard Costs.
Use Actual Costs: Select to show Inventory value based on Actual Costs.
Quantities on Hand: Display lists Quantities on Hand by Item, using the specified parameters. If the "Show Inventory Value" box is selected, the display will also show unit Cost, value, and non- netable value. Totals for each column will be calculated at the bottom of the display. If a Quantity on Hand value displays in the color orange, this means the actual or projected Quantity on Hand is at or below the Reorder Level. If the color is red, the current or projected Quantity on Hand is below 0.

To the far right of the screen, the following buttons are available:

CLOSE: Closes the screen, returning you to the application desktop.
QUERY: Select to generate the display, using the specified parameters.
PRINT: Runs the report associated with this screen.

Right-clicking on an Item in the Quantities on Hand list enables you to select from the following menu options:

Transfer to another Warehouse: Select to transfer Inventory from the specified Warehouse to another Warehouse.
Adjust this QOH: Select to enter a Miscellaneous Adjustment for the specified Item Site.
Reset this QOH to 0: Select to change the Quantity on Hand for the specified Item Site to zero.
Enter Misc. Count: Select to enter a Miscellaneous Inventory Count for the specified Item Site.
Issue Count Tag: Select to create a Count Tag for the specified Item Site.
Export Contents: Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

If an Item has a Default Location defined, the following menu option will also be available—in addition to those mentioned above—when you right-click on the Item:

Print Packing List: Select to print a Packing List for the specified Order.