Variant Configuration Addon in SAP B1 | Product Configurator
Introduction of Variant Configuration Addon in SAP B1
Kabeer Consulting Group’s Variant Configuration Addon for SAP B1 is designed to help manufacturing and automotive businesses efficiently manage complex product variants with ease.
This powerful solution enables dynamic configuration of product attributes at the sales order level, seamless handling of multiple SKUs, and complete visibility across production processes. From attribute management to batch creation and delivery, the addon ensures accurate, flexible, and streamlined operations within SAP Business One.
Built to extend the standard capabilities of SAP B1, this addon empowers businesses to handle configurable products, optimize production workflows, and improve overall operational efficiency.
The Challenge: Struggling to Manage Product Variants in SAP B1?
Manufacturing and automotive companies often face challenges such as:
- Handling multiple product variants (size, color, specifications)
- Managing SKU-level complexity in sales orders
- Lack of flexibility in configuring products per customer requirement
- No visibility into stage-wise production progress
- Manual batch creation and tracking
- Inefficient coordination between sales, production, and inventory
Standard SAP Business One capabilities are not designed to handle highly configurable products with dynamic attributes.
The Solution: A Powerful Variant Configuration Addon Built for SAP B1
Kabeer Consulting Group’s Variant Configuration Addon enables businesses to:
- Configure products dynamically at the sales order level
- Manage multiple SKUs within a single order
- Track production processes stage-by-stage
- Automate batch creation and inventory flow
- Ensure complete visibility from order to delivery
This addon is purpose-built for complex manufacturing environments where flexibility and precision are critical.
How Works Variant Configuration Addon for SAP B1
Proposed Solution in SAP B1
- ID: Non- Editable Unique Code of Attribute.
- Name: Name of Attribute.
- Type: This is type of Attribute Fixed (which are Unique for a Sales Order like Country of Origin) & Runtime (Which are different for SKUs in the Sales Order like Size, Color).
- Characteristics: The value type of an attribute like Numeric & Alpha-Numeric, used in later stages for calculation purpose.
- Code: Running Internal Code of Processes.
- Name: Name of Production Process.
These Processes & Attributes are then linked with Item Master. A Button named “Item Attribute/Process” is given on Item Master which will open another custom window where user will link Item Attributes & Item production process.
There is a process of item duplication is also given to make multiple items with same attribute & process list. The attributes/process of base item is copied same to the newly created item automatically.
As shown in screenshot user will add/remove the attribute/process here. When User will create sales order for an Item the Attribute present in Item Master will copied/reflected to Sales order, same is the case of process list and process list will copied/reflected to Production Order for the particular item.
These attributes or process list can be changed as per the customer’s requirements. Any changes to attribute or process list reflected only on new sales orders created afterwards.
The “Pack Size” attribute must be present as last attribute because its last location is required to create the batch number at the time of receipt from production.
The “Ready” process must be present as last process because its last location is required to determine the batch quantity at the time of receipt from production.
The Items attributes and processes are updated as per customer requirement from time to time. The sales order window has a custom button as “Item Attribute” which records the attributes of that item for that sales order. A maximum of 20 attribute types can be saved with a sales order.
When user creates sales order for an item the attributes present at that time on item master are copied to a custom window as shown in screenshot.
Here user will define the number of attribute size which is the type of SKU required for an item. Equivalent number of rows will be inserted in upper portion to let user define the different value of
A custom menu as “Production Order-Process” is given in add-on to open the Production Order window. On right click a custom option “Process List” is given to access the production process list of that item and its stage wise status update.
As user creates the Production Order from Sales Order the processes of item on item master are saved in Process list window.
The process list window saves the process list and process wise production status.
User needs to double click on the left corner of process to open the Process Status of Production.
The attribute details are copied from sales order attribute window. User needs to enter the SKU completed quantity in every stage. The completed quantity of one stage is the available quantity for the next stage. As described earlier the “Ready” is final stage for an item’s production process, here user will enter the pack size attribute value which must be a whole number. Depending on pack size number the SKU quantity is divided into batch numbers, e.g. any SKU having 150 quantity and 100 pack size will result in 2 batch creation as 100 & 50 quantity respectively.
Plan quantity is the SKU SO quantity, available quantity is the quantity available for process in this stage and this comes from the completed quantity of previous stage. Complete quantity is the stage completed quantity manually input by user. Total complete quantity is the running total of sku& stage wise completed quantity. Balance quantity is the stage balance quantity yet to process.
The last process is “Ready” for all the Production Orders, while user update the completed quantity in the Ready process user need to input the Pack Size according to the SKU.
When user processing Receipt from Production the ready quantity is calculated from Ready Stage and the SKU Information copied to Batch Creation window automatically.
The Sales Order can be processed through Purchase/Production.
Purchase order is created using “Procurement Confirmation Wizard” from sales order. There is a custom button “Item Attribute” is given to view the item attributes.
This is custom screen which copy the sales order attribute from base sales order by clicking the button “Fill Attribute”. Quantity is the SO quantity, User need to input complete quantity before proceeding for GRPO. Return Quantity is the SKU wise returned Quantity. Ready Quantity is the quantity which is already received from GRPO. Balance Quantity is quantity pending for GRPO.
While doing the GRPO the Ready Quantity is calculated and copied to GRPO quantity. The SKU attributes are copied accordingly to Batch Creation window automatically. The Batches are created in running number to the SO Number i.e. for SO number 190199999 the Batches will be created as SO 190199999-1, SO 190199999-2……….. SO 190199999-N.
The Batch Numbers of items are packed in master carton and master carton number holds the information of batch number & quantity. The Barcode sticker is generated for these master cartons which is further scanned on delivery for automatic stock selection as per master carton details.
The Delivery Batch Selection screen has the functionality to scan the Master Carton Number and the Batches of that master carton will selected automatically on delivery.
User need to put the Master Carton number and press enter or need to scan the Barcode with scanner and the Batches of that carton will be selected automatically.
