Limiting the Product List in Price Sheet Entry

Limit the product list that displays on the update window in Price Sheet Entry. By default, The Price Sheet Entry/Update dialog box displays all products in a price line. We recommend limiting the list for easy processing.

Use the following criteria to limit the product list:

Select Discount Class
Null Basis Only
Sheet Sort By
Product Index Type
Maximum Lines of Description
Entity

To limit the product list in Price Sheet Entry:

Display a Price Sheet.
Select Selection > Include Deleted Items to include products on the Price Sheet Entry/Update dialog box that have a status of Delete. This status is assigned to products on the product record.

Select Selection > Selection Criteria to display the Item Select dialog box.
Enter selection criteria in the fields to determine which products to list on the Price Sheet Entry/Update dialog box.

Selection Criteria	Description
Select Discount Class	Enter one or multiple discount classes separated by commas. Leaving the field blank selects all discount classes. Assign discount classes to products in Product Maintenance.
Sheet Sort By	Select one of the following to determine the default status of the product list on the Price Sheet Entry/Update dialog box: Sort Code - Lists products by sort code, determined in the product record. This is the default entry. Product ID - Lists products by product ID, determined in the product record. Status - Lists products by status, determined in the product record. Description - Lists products according to the first line of the description in the product record. Prod Sequence - Lists products as they are listed in the price line record used for this price sheet.
Product Index Type	Select one of the following: Primary - Includes stock items only. Catalog - Includes nonstock items only. Both - Includes stock and nonstock items. This is the default. Product index types are assigned in the product record as Catalog or Primary.
Maximum Lines of Desc	Determine how many lines of description are necessary to distinguish between products on the Price Sheet Entry/Update dialog box. Enter the maximum number of lines needed.
Entity	Select either customer or vendor for this price update: The part number displays on the Price Sheet Entry/Update dialog box for any products that have customer or vendor specific part numbers under the product's description. In addition, the customer or vendor name displays at the bottom of the window next to the Entity indicator.
Null Basis Only	Select this check box to lists the null basis products - products in the price line that have a blank Basis field in Price Sheet Entry. These products did not get updated. If left unselected, the system lists all products in the price line. Run this selection after running an update to get a list of products in the price line that did not get updated.

Click OK to activate the selection.

Select File > Enter Prices on the Price Sheet Entry window to view the list of products on the Price Sheet Entry/Update dialog box.