
β Validation of Exclusions
The validation of exclusions ensures that the item codes and specified columns are indeed present in the selected verification price list. This way, the system avoids calculation errors and ensures consistency between exclusion rules and the actual data of the price lists.
π§ Main fields (validated version)
Field | Description |
Verification price list | Mandatory field that allows you to choose the price list on which to verify the validity of the codes and excluded columns. Once selected, the system automatically checks the data and reports any errors. |
Item Code | List of excluded items, separated by commas. When the price list is valid, the field is highlighted with a green border. |
Columns excluded | Numeric list (e.g., 100,101,102) indicating the columns of the price list to exclude. This field also turns green when the columns exist in the verification price list. |
π§© Validation Operation
1. Select a verification price list from the dropdown menu (e.g., ARBI2025 – Arbi Price List 2025 (08/07/25)).
2. The system automatically checks:
β’ the presence of item codes in the selected price list;
β’ the validity of the excluded columns.
3. If both fields are correct:
β’ the borders turn green β
β’ the Save button becomes active.
4. In case of an error, the fields remain red β with a warning icon next to them.
Advantages
β’ Avoids configuration errors before calculations.
β’ Allows real-time verification of exclusion consistency.
β’ Reduces the need for manual checks or subsequent corrections.
β’ Enables maintaining an always updated and validated exclusion archive.
βοΈ Operational Tips
β’ Always associate a verification price list before saving exclusions.
β’ Maintain consistency between excluded columns and the actual structure of active price lists.
β’ If an item is not validated, check that the code has not changed in the new price list.
β’ To quickly test the effect of an exclusion, use the trial mode in the Calculated Price Lists module.
Complete example
Verification price list | Item Code | Columns excluded | State |
Price List 2025 | 123MAG00, 123MAG01, 123MAG02 | 100,101,102 | β Validated |
Price List 2025 | AC01,AC02,AC03 | 100,101,102 | β Validated |
All valid fields are shown in green, indicating that the exclusion is correctly configured and ready to be used in calculations.