
โ๏ธ Edit Exclusions
The Edit Exclusions window allows you to manage in detail the items and columns that need to be excluded from the automatic price list calculations. Each row represents a group of item codes associated with one or more excluded column numbers.
๐ Window structure
Field | Description |
Verification price list | Allows you to select an existing price list to validate the correspondence of item codes and inserted columns. |
Item Code | Text field containing one or more item codes separated by commas. It is also possible to enter entire groups or families of items. |
Columns excluded | Field to specify the columns (one or more) that should be excluded from the calculation, separated by commas (e.g., 100,101,102). |
Actions (โฎ) | Save or delete commands for each row. |
โ Add a new row
To add a new exclusion rule:
1. Click the green + Add row button.
2. Enter the item codes in the Item Code field.
3. Specify the columns to exclude in the Excluded Columns field.
4. Optionally, select a verification price list to check the validity of the codes.
5. Click Save to record the row.
โ๏ธ Edit or Delete Rows
โข To updateโ๏ธ Edit or Delete Rows
โข To update a row, modify the fields directly and press Save.
โข To remove a row, click on the trash icon ๐๏ธ.
โข Fields highlighted in red indicate invalid or to-be-verified values.
Practical Example
In the case shown:
Item Code | Columns excluded |
123MAG00, 123MAG01, 123MAG02 | 100,101,102 |
AC00, AC01, AC02, AC03 | 100,101,102 |
These lines indicate that all listed items will be excluded from columns 100, 101, and 102 during the calculations of price lists or bills of materials.
โ๏ธ Operational Tips
โข Group similar items on the same line to reduce complexity.
โข Maintain a consistent format (codes separated by commas, without spaces).
โข Always use verification price lists to identify obsolete codes.
โข After updating an exclusion, perform a recalculation in test mode to ensure the results are correct.
๐ Relationships with other modules
โข Calculated price lists โ applies exclusions defined at the column or item level.
โข Calculation sheets โ avoids changes on excluded groups.
โข Price list management โ shows only the data actually updated after applying the exclusions.