
⚙️ Macro
The Macro Module allows you to create and manage unified codes that represent a set of multiple items already present in the database. Each macro defines an aggregate code whose price is calculated as the sum of the prices of the component codes. Macros are used to:
• generate kits or preconfigured groups of items;
• create synthetic codes to simplify sales or price list management;
• automate the price calculation of complex items derived from multiple components.
🧱 Main Screen Structure
The main screen displays the complete list of available macros, with filters, status indicators, and management buttons.
• Macro Assemblies → Main macro code.
• Alternative Code → Macro code alias.
• Description → Macro description.
• Width (W), Height (H), Depth (D) → reference dimensions.
• Calculation Columns → Price list columns where the macro is calculated.
• Active (✔️) → Indicates if the macro is enabled or temporarily disabled.
• Action (⋮) → Control menu to edit, duplicate, or delete the macro.
🧮 Calculation Logic
Each macro is associated with a bill of materials of component codes already existing in the system.
During synchronization:
1. Reads the codes contained in the macro’s bill of materials.
2. Retrieves the corresponding prices from the price list columns.
3. Sums the values, applying any rounding rules or reference columns.
4. Saves the total price as the value of the macro code.
➕ Creating a New Macro
To add a new macro:
1. Click on “+ Add Macro”.
2. Fill in the main fields: Macro Code, Alternative Code, Description, Columns, Length (L), Height (H), Depth (D).
3. Press Save to create the macro.
4. The “Macro Rows” window opens automatically.
✏️ Edit and Maintenance of Macros
From the ⋮ icon, you can:
• Edit macro data;
• Update macro rows;
• Duplicate a macro as a basis for a variant;
• Delete a macro no longer in use.
Changes are applied in real-time.
🧾 Edit Macro Header
The window allows you to edit the header of a macro, i.e., the identifying, dimensional, and functional data that determine the behavior of the macro.
📋 Main Fields
• Macro Code → Unique identifier of the macro code.
• Alternative Code → Secondary code or alias.
• Description → Descriptive text of the macro.
• Columns → Column(s) where the price is stored.
• Length (L), Height (H), Depth (D) → Reference dimensions.
💾 Available Actions
• Save → Records the entered or modified data.
• Close → Closes the window without saving.
🧮 Edit Macro Rows
The window allows you to define the rows that make up the macro. Each row represents a real component used to determine the macro’s value.
📋 Main Fields
• Row → Automatic sequential number.
• Code → Item code to include in the macro.
• Alternative Code → Secondary code or alias.
• Quantity → Number of component units.
• Column → Indicates the price list column from which to retrieve the price. You can enter a specific column number or “MACRO”: in this case, the calculation is performed on all price columns of the item. Example: code MA01 has a price of 100 in column 100; MA01CAT has prices 10, 20, 30 in columns 001, 002, 003. If the row indicates “MACRO” as the column, the macro sums the components and generates: 110 in column 001, 120 in column 002, 130 in column 003.
• Operator → + adds, – subtracts, = replaces the total.
⚙️ Buttons
• ➕ Add Row → Inserts a new row in the list.
• ✏️ Edit → Edits the selected row.
• 💾 Save Changes → Updates the list in the database.
• ❌ Cancel → Closes the window without saving.
✏️ Edit Row (Macro)
The window allows you to insert or modify a single item in the component list.
📋 Editable Fields
• Quantity → Number of units to add.
• Column → Column or “MACRO” to calculate on all price columns of the item.
• Operator → +, -, = to update the total.
💾 Actions
• Save → Updates the list.
• Cancel → Closes the window without changes.