
✏️ 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.