How You Can Configure A Cabinet In Dynamics NAV With TRIMIT

Written on April 3, 2017 by Caterina Lyng

Configurable products such as kitchen cabinets can be both time-consuming and a challenge to create and manage in Microsoft Dynamics NAV. Because of this, we have developed TRIMIT Furniture, an industry-specific solution based on Dynamics NAV. Our solution automates and streamlines your business processes and makes it easy to manage product variants - from design to delivery.

In this blog post, we will take a look at how TRIMIT Furniture can be used to configure an order with two dimensions.

Products With Many Options

Cabinets can consist of elements with many different options such as:

  • Heights
  • Widths
  • Fronts
  • Handles
  • Drawers

In addition to all the options, there are restrictions as to what combinations are possible. For instance, the height of the cabinet influences the height and number of drawers, and also if it is possible to add doors and shelves.

Example of parts in a cabinet

Order Configuration in TRIMIT Furniture

In this example, we start with a sales order. The Furniture Shop UK wants to order kitchen cabinets, and these will be delivered from our location ORANGE.

Ordering a cabinet i TRIMIT Furniture

On the sales order line, we enter the master number of the cabinet that we want to configure.

Master number entered in TRIMIT Furniture

With the master number entered, a configuration page appears. Here we can specify the combinations for the cabinets. In this case the customer wants drawers in alternating colors. We can easily make this choice by using the 2nd dimension.

Cabinets with 2 dimensions

In the screenshot you can see the cabinet parts that have a front. These are white by default, and in this example we change the 2nd and 4th drawer into black.

Second dimension choices for a cabinet

On the configuration page, you can see that the choices of another front color has automatically added an additional amount on top of the basic unit price.

Additional amount automatically added

In this example, we say that the furniture company wants to order tree cabinets like we have just configured.

Ordering three cabinets

After the quantity has been entered, we get a message that tells us that the choices we have made during the configuration has also changed the unit cost for the kitchen cabinet.

Unit cost updated

Once the quantity has been entered, a related production order is automatically created.

Related production order for cabinets

In the screenshot, you can see the production order lines. Here we have all the item parts necessary for assembling the kitchen cabinets including the operations and machine setups. In the columns Measurement 1 and 2, you can see the length and width of the needed planks.

Production order lines for cabinets

With the order configuration in place, you can start the production process by checking if you have enough materials on stock for this production order, but that goes beyond what I wanted to show you in this blog post.

TRIMIT Furniture can handle the calculations of raw materials, inventory picks, put-aways etc. and for an in-depth presentation of our comprehensive solution, I recommend that you contact us for a free demo by one of our product specialists.

How To Make Changes?

Sometimes, you need to make changes to a configured order. To see how this works in TRIMIT Furniture, we will change the cabinet handle from number 03 to 05.

Handle selection in order

Because we made a change, we get a warning saying that the sales order line has related orders. The related orders need to be deleted before a new one can be created with the changed configuration.

Create new related order

Once we have confirmed that we want to delete related orders, we can see the new handle and also that the adjustment amount sales has changed from 2,00 to 1,00. Because of this, we can expect a different unit price. Since the new handle is also cheaper, we can also expect a different unit cost.

Updated change to cabinet

In the screenshot we can see the messages showing the changes to the unit price and unit cost because of the change of handle.

Automatic changes to unit price and unit cost

If we take a look at the production order, we can see that the handle we just selected is now a part of the Bill of Materials (BOM).

Production order for cabinet (BOM)

More Information

For more information about our Microsoft Dynamics NAV-based solution for the furniture and home furnishings industry, please see the page TRIMIT Furniture.

You are also welcome to request a free demo or to contact us at [email protected].

Powered by
TRIMIT Portal Software