
๐ซ Module: Exclusions for Calculated Price Lists
The Exclusions module for calculated price lists allows you to define and manage sets of items, categories, or combinations that must be excluded during the generation of calculated price lists. Exclusions enable precise control over which elements to apply or not apply formulas, preventing unwanted changes to specific products.
๐ Interface and main fields
Field | Description |
Code | Unique exclusion identifier. It must be clear and consistent (e.g., ACCESSORI, PIANI, IBRA_BOX). |
Description | Explanatory text specifying the content or purpose of the exclusion (e.g., “New 2025 accessories + LED surcharge”). |
Actions (โฎ) | Management menu that allows you to modify or delete the selected exclusion. |
โ Creating a New Exclusion
1. Click the green button + New Exclusion at the top right.
2. Enter the following fields:
โข Code โ short and meaningful name (e.g., LAVABI_E_VASCHE)
โข Description โ explanation of the exclusion scope (e.g., โLavabi e vasche new 2025โ)
3. Save to add the exclusion to the table.
4. The exclusion can then be selected within the Calculated Price Lists or Calculation Sheets modules.
โ๏ธ Edit or Delete
โข To edit an existing exclusion, click on the โฎ menu next to the corresponding row.
โข You can update the code, description, or linked content.
โข Deletion permanently removes the exclusion from the system (upon confirmation).
๐งฉ Examples of Common Exclusions
Field | Description |
ACCESSORIES | New 2025 accessories + LED increments |
MODELLO_1 | Melamine, matte lacquered, columns |
MODEL 2 ACCESSORIES | Accessory exclusions |
MODEL 2 BOX | Shower enclosure exclusions |
WASHBASINS AND BATHTUBS | Washbasins and bathtubs new 2025 |
MODELS | Exclusion of new items 2025 |
TOPS | New tops + tops to increase by 10% |
MIRRORS | Exclusion of mirrors |
โ๏ธ Operation in Calculations
When generating a calculated price list or a bill of materials:
โข exclusions are automatically read;
โข items or columns belonging to an exclusion are skipped during the calculation;
โข the system logs excluded elements for traceability.
๐ง Operational Tips
โข Use clear and consistent names for exclusion codes: they assist in future maintenance.
โข Create groups of logical exclusions (e.g., materials, categories, brands).
โข Update exclusions with each price list revision or collection release.
โข Before launching a complex calculation, ensure exclusions are correctly associated.
๐ Integration with other modules
โข Calculated price lists โ exclusions can be selected before calculation.
โข Calculated price lists with bill of materials โ use exclusions to prevent changes to certain columns.
โข Price List Management โ displays post-calculation results where exclusions have already been applied.