🧮 Edit Calculation Bill
The Edit Bill of Materials window allows you to manage in detail the individual rows that make up a calculation bill of materials. Each row represents a rule applied to one or more columns of the source price list: for example, a percentage increase, a reduction, or a targeted rounding.
📑 Table Structure
Field | Description |
From / To | They indicate the range of columns (or price groups) to which the rule applies. You can enter the same value in both fields to act on a single column. |
% | Percentage of variation applied. It can be positive or negative. |
Sign | Determine if the operation is an increase (+) or a decrease (-). |
Rounding | Allows you to set a specific rounding rule for that line (e.g., €0.05, €0.10, none). |
Description | Text field to document the purpose of the rule (e.g., “Increase +5% – White Lacquer”). |
Actions (⋮) | Sidebar menu that allows you to edit or delete the selected row. |
➕ Adding a New Row
To insert a new calculation rule:
1. Click the + New Row button at the top right.
2. Fill in the required fields:
• From / To → range of affected columns
• % → percentage of increase or decrease
• Sign → + for increase, – for reduction
• Rounding → if necessary
• Description → free text
3. Save the changes: the new row will appear in the table and will be applied in the next price list calculation.
✏️ Edit or Delete Rows
• Click the ⋮ icon to edit or delete a specific row.
• Changes are saved immediately and remain active until a new revision.
• You can reorder or duplicate rows to speed up the creation of similar rules.
Practical Example — List “PREZZI2025”
From | H. | % | Sign | Rounding | Description |
002 | 002 | 5 | + | No rounding | Increase +5% – White Lacquer |
006 | 006 | 5 | + | No rounding | Increase +5% – Metal Lacquer |
007 | 007 | 5 | + | No rounding | Increase +5% – Laminate |
100 | 100 | 5 | + | No rounding | Increase +5% – Accessories/Supp. |
Each row defines a single markup operation applied to the specified columns.
⚙️ Operational Tips
• Group rows by material type or category (e.g., lacquers, laminates, tops).
• Keep the Description column clear and readable: it will also be used in calculation logs.
• Use multiple ranges (e.g., From 200 to 205) to speed up the definition of similar rules.
• Before calculating the bill of materials, ensure there are no overlapping intervals.
🧠 Relationships with Other Modules
• Price Lists Calculated with Bill of Materials → uses the rows defined here to generate the final price lists.
• Price List Management → shows the result of the calculated bills of materials.
• Exclusions for Calculated Price Lists → can exclude specific columns defined in the bill of materials.