Current Sales Inventory

Search window -> Product # field -> Inventory Search "display Groups" -> Select window -> Current Sales Inventory

This utility provides an overview by Class and/or Group of sales parts with the current commitments on open documents.
An advantage of this inquiry is the Group statistical reporting.

The prompts are:

LOCATION, "ALL" OR "SEL"

Accept the default operator location displayed, or select one of the following location filters for the output:

• Type ALL to include all locations in the report.
• To print the report for a single location, leave this field blank for the Head Office, or enter a specific division code, or select a location from the drop-down list.
• Type SEL to select multiple locations to include, or to select locations by inventory region as outlined in Division Select By Region.

Note: A preferred 'Location, "ALL" Or "SEL"' default value can be defined for this search in the Division Inventory Parameters, that is respected when the 'Use Location In Inventory Search' is also checked.

CUSTOMER

Accept the default Cash Customer for this division, or enter a preferred customer, or select one from the Accounting Customer Search window.
Special pricing for this customer will be reflected in the product list output in the Cust Price column.

CLASS

Accept ALL to include all Product Classes or enter a single sales class, or select one from the Product Class Search window.

GROUP

Accept ALL to include all Groups or enter a single Group, or select one from the Group Search window.

DESCRIPTION

Leave this field blank to include all sales parts in the Class/Group selection, or enter the first few characters of the product description to narrow the search.

Note: One of the Class, Group, or Description filters must be used to generate the output.

Resulting Product List:

The products in the range are listed with Description, Available quantity by location, the Standard List Price, and the selected customer's Special Price.

The Available quantity displayed, is the quantity On Hand less the quantity on Contract.

Note: Depending on the source of the inquiry the ability is provided to identify a Customer in the selection criteria, and then report on the pricing for that customer.

A window is provided on the Pricing field to view special prices for the product as outlined in Special Pricing Search.
In the Special Pricing window click the SALES HISTORY button to drill down to the sales history records for the product.