Product List

Browse, search, and filter the product master file. The Product List displays all products with configurable columns, and provides access to add new products or open existing product records.

Search Options

Select a search mode from the dropdown to control which fields are searched:

Code or Description Searches across both the ProductCode and Description fields simultaneously. This is the default search mode.
Code Searches the ProductCode field only.
Description Searches the Description field only.

Default Columns

The following columns are displayed by default. Additional columns can be shown using the column selector.

ProductCode The unique identifier for the product. Click on a row to open the product detail page.
Description The product name or short description.
Details Extended product description.
AlternateCode An alternative product code or reference number.
StockGroupCode The stock group this product belongs to.
CreditorCode The default supplier (creditor) for this product.

Selector Columns

When the Product List is used as a selector dialog (e.g., selecting a product from another form), the following columns are displayed:

ProductCode, Description Product identification fields.
SellingPrice1 through SellingPrice9 All nine selling price levels are available in the selector view.

Selection Filters

Use these filters to narrow down the product list:

Product (Code Range) Filter products by a range of ProductCode values. Looks up from the ICPROD table.
StockGroupCode Filter by stock group. Looks up from the ICGROUP table.
CreditorCode Filter by default supplier. Looks up from the APCRED table.
SalesGroupCode Filter by sales analysis group. Looks up from the ARANL table.
Inactive Boolean filter to include or exclude inactive products.

Actions

Row Display

Inactive products are displayed with the row-inactive CSS class, which visually distinguishes them from active products in the list.