Sales price lists

Prerequisite

Operation

The main OBJect is automatically detected with the main key corresponding to the price code and the list number.

The details lines are detected according to two criteria in this order:

1. Search with the line number if it is set up and assigned.
If the line exists, it is modified otherwise it is created.
This line number assigned during creation, may be unknown. It is less suitable for line modification.

2. Search with the import line number IMPNUMLIG if it is set up and assigned.
If the line exists, it is modified otherwise it is created.
This line number is not specified during price creation. It is incremented during price import and enables to keep a reference number.
 If the import line number is zero, it is a creation.

Other prerequisites

Tables to be completed

The following tables are used by the function. Their content must be updated if necessary :

Mandatory fields in the template

In file SPRICLIST, criteria are grouped in a single element PLI.
In the template, they must be separately defined in the global variables.

• Criterion 1 = GIMP(1).
• Criterion 2 = GIMP(2).
• Criterion 3 = GIMP(3).
• Criterion 4 = GIMP(4).
• Criterion 5 = GIMP(5).

A specific variable is assigned to each criterion.

 These correspondences must not be swapped.

Error messages

The only error messages are the generic ones.

Tables used

This template can be used in import and export modes. The data is updated in the following tables :