Modifica esclusioni

โœ๏ธ 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 ne
w 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

โ€ข Gr
oup 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 shee
ts โ†’ avoids changes on excluded groups.
โ€ข Price list management โ†’ shows only the data actually updated after applying the exclusions.

Torna in alto