Inventory Worksheet by Product Class /Product Description

** This utility is under development and is not yet available. **

This worksheet prints by Product Class, Product Description or Group selection.
It is not available by Location, but can be selected for all or for specific Vendors.
The prompts for this worksheet are:

SORT BY PRODUCT CLASS

Press <ENTER> or N (NO) to skip the Product Class sort, and to sort by Product Description or by Group instead.
Type Y (YES) to sort by Product Class. The prompts to sort by Product Description or by Group will be skipped. A window opens and prompts:

SORT BY DESC OR PROD#

Enter D to print the products in Description order within each Product Class.
Enter P to print the products in Product number order within each Product Class.

FROM PRODUCT CLASS

<F4> Press <ENTER> for all Products Classes or type in the desired beginning Product Class number.

TO PRODUCT CLASS

<F4> Press <ENTER> for all Products Classes or type in the desired ending Product Class number.

NEW PAGE PER CLASS?

Y (YES) to print each Product Class on a new page.
N (NO) to prevent paging by Product Class.

SORT BY PRODUCT DESCRIPTION

Press <ENTER> or N (NO) to skip the Product Description sort, and to sort by Group instead.
Type Y (YES) to sort by Product Description. The prompt to sort by Group will be skipped. The prompts are:

FROM PRODUCT DESCRIPTION

<F4> Press <ENTER> for all Products or type in the first few characters of the beginning Product Description. The lookup window allows product search by product number.

TO PRODUCT DESCRIPTION

<F4> Press <ENTER> for all Products or type in the first few characters of the ending Product Description. The lookup window allows product search by product number.

SORT BY PRODUCT GROUP

Type N (NO) to re-select the sort option. One of Product Class, Product Description or Group must be selected for the worksheet.
Type Y (YES) to sort by Product Group. The prompts to sort by Group are:

FROM GROUP

<F4> Press <ENTER> for all Products Groups or type in the desired beginning Group number.

TO GROUP

<F4> Press <ENTER> for all Products Groups or type in the desired ending Group number.

NEW PAGE PER GROUP?

Y (YES) to print each Group on a new page.
N (NO) to prevent paging by Group.

ALL VENDORS

Press <ENTER> for Y (YES) to print products for all Vendors.
Type N (NO) and select specific Vendor from the window.

INCLUDE 0 ON HAND ITEMS

Y (YES) to include all products, even those with quantities less than 1.
N (NO) to exclude products with quantities less than 1.

RENTAL, SALE OR BOTH

R for only RENTAL Inventory.
S for only SALE Parts.
B for BOTH Rental and Sales Products.

ACTIVE ITEMS ONLY

Y (YES) to include only Active products.
N (NO) to include all products, even disposed Rental Products.

INVENTORY ITEMS ONLY

Y (YES) to include products flagged as Inventory in the Product file.
N (NO) to exclude Non-Inventory products, such as labor, that are included in Sales Inventory or Rental Inventory but are flagged as Inventory = NO.

ACCEPT or CANCEL

A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.

Click the ACCEPT button to begin printing the report, or CANCEL to abort.