SELITV1CRIT: Product selection

This entry point impacts the product selection triggered when entering product references in sales documents.

It allows you to take control in order to modify selection criteria.

Context and operating mode

Transaction

There is no transaction.

Log file

There is no open log file.

Call context

This entry point is called in quote, order, delivery and invoice management when entering the product reference. It is called by the SELITV1 control action linked to the ITV data type (Sales product) of the product field (ITMREF).

This action is triggered only when the user parameter AUTOSELITS (Sales chapter, MIS group) is set to Yes.

This action opens a selection window for active products (ITMSTA) with a reference (ITMREF), a description (ITMDES1) or an EAN code (EANCODE) corresponding to the value entered.

The EP allows you to intervene on this selection to modify the criteria, the sort order, the selection request.

Available variables and masks

The SELITV1 action is an action of "Selection from table" type.

A link has been created for the ITMMASTER and ITMSALES tables.

The following variables are available:

·               VALEUR  (value char): Product reference entry

·               UPVAL  (value char): Product reference entered in uppercase

·               ORDRE  (value char): Name of the field on which the sort order is performed = "ITMREF"

·               START  (value char): Name of the field on which the selection is started = "ITMREF"

·               OBJET  (value char): Object used = "ITS"

·               CRITERE  (value char): Selection criteria

·               SQL_REQ (Local Clbfile): Selection request

The EP allows you to modify the CRITERE and SQL_REQ variables in order to modify the standard selection criteria.

Open tables

The open tables are the tables of the object (quote, order, delivery, invoice).

 

Table

Significant content

Table title

ITMMASTER

No

Products

ITMSALES

No

Sales product