Hello,
I am in the process of planning our migration to Business Central. I am currently looking at how best to implement Sales Order and Inventory management within our cement products division. We sell a lot of concrete panels. They come in standard heights (500mm, 600mm, 1,000mm, etc.) and standard thickness (90 mm and 140mm). However, we can make panels of any length (500mm to 10,000m). Weight is a significant consideration when planning the delivery of panels; we have weight charts for all combinations of heights and thickness for 1m lengths used to calculate the weight of items ordered.
Customers tend to order several panels of a certain length/height and thickness, i.e. "I want 10 5m long panels of a thickness of 140mm and a height of 1,000mm."
My initial thought was to create items based on height and thickness combinations, i.e. 500mm x 140mm and use variants for the custom lengths. The unit of measurement would be PCS. However, calculating the weight becomes difficult as the item card has gross and net weight, but the quantity is the number of panels, not the length.
I also considered not using variants and changing the unit of measurement to meters. The salesperson would enter the total meters of a required height and thickness, i.e. 50m of 140mm thick and 1,000mm high panels. Calculating the weight would be a simple calculation, but we have no way of recording the length of each panel.
I am unsure how to proceed; am I missing an obvious solution?
I appreciate any guidance you can provide.
Michael
