Custom product in manufacturing

The role of custom product in manufacturing

In companies that are manufacturing custom products (and most of them are depending on high number of different parameter combinations), the main question is how long does it take to make a quote?

One of the example is manufacturing ALU/PVC windows and doors.

The cost depends on infinite combination of entry parameters (height, width, glass type, color, material, etc.). And, on number of positions in very bill of materials. Since each offer is unique, companies are losing hours and hours of engineering just to calculate the cost in order to make an adequate quote. The biggest problem are the small errors that can adversely affect the profit margin. Usually people ‘recycle’ the quotes! They are giving to customers quotes with similar parameters by default, without being aware that a lot of things have changed on the market.

There are ‘specialized’ solutions on the market that cover only a single type of manufacturing vertically. Such solutions are extremely expensive, so usually that’s not enough for the company. In our example we would need 2 solutions. One for PVC and another one for ALU manufacturing program.

One of such solutions is to enlist a software developer that will program the solution or upgrade the existing one. Not only that this solution is more expensive than the previous one, but the maintenance of such system will become a nightmare in a few years!

ERPAG has a solution to make the most complicated quote in just a few seconds.

That solution is ‘Custom product‘ item type.

In this blog we will explain how to use this option step by step. And, you can test it out on your own with demo data on this link: https://demo.erpag.com/demo.aspx?company=doorswindows .

Defining parameters for custom product

The first thing we need to do is to define ‘parameters’.

In our example, the parameters will be ‘window’ type (wood, aluminum), ‘glass type’ (standard, tempered). And also, two parameters with unlimited number of combinations – ‘width’ and ‘height’.

Enter these parameters in ERPAG in Custom fields that are Quotation type. To check more information about custom fields follow this link: https://www.erpag.com/news/custom-fields-upgraded

Note: You can only enter the custom field in Quotation! You can convert it manually to BOM (bill of materials). Or automatically when you create a Sales Order from the Quote. This is why we link the parameters to custom fields – quotation type.

Define them in ‘Document items’ section.

After setting up custom fields, the newly created fields will appear in Quotation. In section where you select items!

Note: The newly created fields will appear as last columns. So you probably have to set them to wanted position or even enable them to be visible. You can do that in More > Columns (in the very items table/section).

Defining logic of a custom product

We are defining logic through Blockly Script.

Note: Blockly is a Google Visual Programming Language ( https://developers.google.com/blockly ). You can check one of the blockly script integration with ERPAG on this link: https://www.erpag.com/news/how-to-calculate-commission-on-sales

In order to implement logic, we have to create ‘Custom product’ item type (Creating from Products and Services list).

You enter the logic in a blockly script in a separate panel.

More options in BLOCKLY

Besides standard Blockly options (Logic, Loops, Math, Text, etc), we added special options linked to manipulation through ERPAG.

Parameters

Here are blocks that mark the entry parameters – ‘custom fields’ (we previously explained in this blog how to define them), the elementary item data from quotation (SKU, Description, Unit of measure, Requested quantity). These blocks return value like text or numeric.

Generated item

This menu contains blocks that are used for logic check and setting value of generated product.

In picture above, the blocks marked red show the logic check of entry parameters. This disables generating new product if the logic requirement is not correct. In our example, ERPAG will show an error if width is less than 40. Which in practice means that this custom product’s width can’t be less than 40 cm. In order for this to function, you have to set ‘Error’ block value to ‘true’. And optionally, you can define ‘Error Message’ for easier managing.

The blocks marked green set product description. In our example, ERPAG will add width x height to the product description from Quotation. Which is actually the description of the custom product. For example, ‘Casement window double (180×150)’.

ERP – Functions

The special functions to create BOM (Bill of materials) are in this menu.

The block that adds product (component) based on SKU and quantity is marked green (in picture below).

In our example (on picture above, marked green) we are adding two times item (SKU 0116 – Float glass 3 mm) with calculated square meters. We are adding it two times because dual panel consists of 2 glasses. The square meters are calculated based on entry parameters and we are adding the result in ‘qt_m2’ variable.

With blue color we marked blocks that calculate girth based on entry parameters, and we are adding SKU 0118 (‘Spacer bar’).

If we record now this ‘custom product’ and activate BOM (Bill of materials) generating with entry parameters ‘Width (cm) = 180’ and ‘Height (cm) = 150’, we would get a new product with corresponding data.

Adding work operations

We can add work operations based on the same principle. But, as a parameter, we would take the work operation key and required time in days, hours and minutes.

In our example we added work operation ‘W002’ (‘Bonding glass’) which lasts for 1 hour and 15 minutes. But, only if the surface (variable ‘qt_m2’) is higher than 3, or 45 minutes if it’s not.

If entry parameters are ‘Width (cm) = 210’ and ‘Height (cm) = 160’ then the generated BOM would look like this:

Eg, the work operation ‘Bonding glass’ would last for 75 minutes (1 hour and 45 minutes). Because the square footage is higher than 3 m2.

Block ‘Custom product’ is for adding previously defined ‘Custom product’. With this block you are achieving a multilevel feature. Eg, You can add new custom product with appropriate parameters in existing Custom BOM based product.

Note: Adding custom product to a custom product is an advance option. We will try to explain it in one of our future blogs!

Generating BOM based custom product

You can’t use custom products in Sales Orders or Work Orders directly. However, there are two other ways! One is through Quotations (which we will explain further in this blog), or, to generate a BOM item from the custom product itself.

As you could see from previous examples, you do that through “Bill of materials’ button (picture above).

That’s when you will get a window to enter parameters.

And a new ‘tab’ with newly suggested item!

Note: Each item that you generate from Custom product is unique. It has it’s own SKU and corresponding BOM (bill of materials).

The new product will ‘inherit’ some data from custom product. Such as ‘tax category’ and ‘product category’.

We also set that the selling price is formed by ‘Markup/Margin’. The selling price is automatically calculated based on the estimated cost.

Further, you can use this generated product in Sales Orders, Work orders. And manipulated like all other, regular items!

Quotation and custom product

Another way of using is in when forming a quotation. Like we mentioned in the beginning of this blog – this is the most common way of using custom products.

You simply enter custom product items (like regular items), and set up corresponding custom fields value!

And that’s it! Once you save it, ERPAG will automatically recalculate cost! And if the selling price is set to ‘margin/markup’ – it will be automatically calculated as well.

Note: In order to avoid unnecessary ‘piling’ of items (coming from the assumption that not every quotation will be accepted, or, at least, not immediately), ERPAG won’t automatically create BOM (bill of materials) product! ERPAG will save such items as ‘drafted’.

By activating ‘link’ on the item you will open a drafted custom product.

Here you can define the product description. And, eventually, make some corrections!

Depending on the business type, closing a quotation can take months. During that time, prices can change on the market. For example, the price of aluminum can rise up! So, we also have update option (green arrow on the picture bellow). This option will recalculate all custom products. It will update the cost and price according to the new parameters.

Before we convert quotation to a Sales Order (‘Copy to new’ option), you have to convert custom product to BOM based product (red arrow on the picture above).

Then you can generate a Sale Order and start the production!

Note: You can individually convert each custom product from quotation to a BOM based product. Simply go to ‘draft’ product via hyperlink and hit ‘convert to – Bill of materials’ button.

Custom products on the customer portal

You can also use custom product in customer portal! They will appear like all regular items (if it’s allowed through the search scope). The only difference is that these items don’t have a selling price. Which is logical as we don’t know the parameters yet.

But, once the customer clicks on ‘add to cart’ button, then he will be able to choose the parameters. After that, he can ‘calculate’ the price!

Note: You will only have offered the data used in the custom product in the customer portal.

After the price is calculated, the customer can add the item to the cart!

Once the customer checks out, or places the order, the Sales Order will have BOM based products generated directly.

This option is also available in Customer Portal mobile app!

Erpag Support

October 2020.