Price Lists Calculated with Bill of Materials

The Calculated Price Lists with Bill of Materials section allows you to create complex price lists by applying a calculation bill of materials, which is a set of rules or markups that affect specific columns or groups of prices. It is the most advanced tool for managing increases, variations, or customized versions of price lists starting from preconfigured conditions.

📂 Interface and main fields

🧮 Key Features

🔸 Creating a New Bill of Materials
1. Click on + New Bill of Materials at the top right.
2. Fill in the fields:
• Bill of Materials Code
• Description
• Any calculation rules (percentages, columns, or references to source price lists).
3. Save to add the bill of materials to the list.

Bills of materials can include:
• percentage increases or decreases (e.g., +10%)
• applications on specific columns (e.g., “columns 408, 416, 417”)
• copying or merging of price lists (e.g., “copy col. 020 to col. 0211”)
• thematic surcharges (e.g., “LED SURCHARGES”)

🔹 Calculation of a Bill of Materials
After configuring one or more bills of materials, you can perform the global calculation using the 🧮 Calculate button at the bottom right.

The system processes all the bills of materials in the list:
• automatically applying the defined formulas and rules
• updating or generating the resulting price lists

During processing, consistency checks are performed, and an internal log of operations is created.

🔹 Actions Menu (⋮)

The menu next to each row allows you to:
• ✏️ Edit the selected bill of materials
• 📄 Duplicate to quickly create a new variant
• 🗑️ Delete the bill of materials from the system

📊 Typical examples