Using Inventory Inquiry

Use Inventory Inquiry to review product availability and inventory information, such as product rank, demand, and sales figures, in all branches and territories. This information is useful in procuring products because you can review the branches that have available inventory.

Inventory Inquiry displays product information based on the following branch or territory hierarchy:

Inventory inquiry territory set for you on the Accessible Branches screen.
Your home territory.
Branches set for your home branch on the Inventory Inquiry Brs screen.
Your home branch.

If you are assigned an inventory inquiry territory or a home territory, the system also displays product information for all stocking branches within the territory.

You can also access additional inquiries and product information from Inventory Inquiry.

To use Inventory Inquiry:

From the Orders > Inquiries menu, select Inventory Inquiry to display the Inventory Inquiry screen.

Note: When accessing Inventory Inquiry from other screens, the system uses the product and branch information from those screens.

In the Desc field, enter the product for which to review inventory information.
Review the following information to determine where inventory is available.

Field	Display
Desc	Product description.
Status	Product status, such as stock or nonstock.
Pkg Qty	Buy package quantity for the currently selected branch. As you scroll up or down in the list of branches (Wh#), the buy package quantity changes to reflect the current branch.
Weight	Product weight in pounds.
Buy Line	Buy line to which the product is assigned.
Load	Load factor for the product. Use the load factor to determine the amount of the product required to fill a shipment vehicle.
Prc Line	Price line to which the product is assigned.
Wh#	Warehouse / branch to which the displayed product information applies.
Avail	Amount of the product that is uncommitted in each location.
In PO	Quantity of the product scheduled for purchase from vendors. Note: Kit components are counted, but the items making up the components are not counted.
In Xfer	Quantity of the product being transferred from other branches.
In Proc	Quantity of the product in the process of being picked or received.
In Work	Quantity of the product scheduled for value-added processing.
Rnk	Product rank that identifies how often the product is purchased, in terms of number of hits, gross profit, or demand over a 12-month period, when compared to other products.
Demand	Frequency at which the product is typically purchased.
30Day Sls	Number of times you purchased the product in the last 30 days.
365 Sls	Number of times you purchased the product in the last 365 days.
UM	Product's primary unit of measure for sales.

When you have finished reviewing the information, press Esc to exit the screen.

More Options from the Inventory Inquiry Screen

The Inventory Inquiry screen also offers these options:

Hot key	Function
Fut Ledger	Displays the Future Ledger for the product and branch. Use this screen to view inventory forecasts for the product.
Hist Led	Displays the Inventory History Ledger for the product and branch. Use this screen to view the transaction history for the product.
Inven	Displays the Primary Inventory Maintenance screen for the product and branch. Use this screen to review demand information for the product.
Pricing	Displays the Product Pricing screen for the product and branch. Use this screen to review the pricing rules for the product by customer class.
Kit	Displays the Product Kit Maintenance screen. Use this screen to review the kit for which this product is a component if any.
Sales Hist	Displays the Product Sales History screen for the product and branch. Use this screen to review product sales.
Locas	Displays the Product Location Maintenance screen for the product and branch. Use this screen to review warehouse locations for the product.
Subs	Displays a substitute products and their associated statistics if available. Select a substitute to do an inquiry on the substitute product.
Log	Displays the Product Activity Log Viewing screen for the product and branch. Use this screen to view changes made to the product's maintenance record.
Xref	Displays the Product External References screen if the product is cross-referenced to an external catalog or Internet address, such as an online catalog. Use this screen to cross-reference the product with a catalog or other external reference.
Net Avail	Displays the Network Avail screen when the selected branch is either a central purchasing branch (C) or central warehousing branch (W). Use this screen to view the total item availability in a multiple warehouse scheme, where the central purchasing branch (C) or central warehousing branch (W) branch is the controlling branch. Note: Central purchasing and central warehousing schemes are set up for product groups using Procurement Group Maintenance.
Terr	Displays a prompt to select a stocking branch or territory from the user's authorized branches. Enter All to select all stocking branches. Use this function to view product inventory information for a different branch or territory. If you select a branch for which you do not have full access, the Pricing, Fut Ledger, and Hist Led hot key are disabled.
Find Br	Displays a prompt to search for a branch ID in a list of branches or territories. At the prompt, enter the branch or territory ID and press Esc to return to the Inventory Inquiry screen. The cursor moves to the requested branch.