How to Create Volumetric Unit Information for Product Sales (Multi-Dimensional Data / Product Unit Multipliers)?
Does anyone know or can assist in writing a module to create additional product quantity multiplier fields for sales orders that can carry throughout the Odoo system?
We are in manufacturing and buy raw materials by the kg/lbs and sell product based upon custom ordered dimensions and weight.
Plastics is purchased by the kg/lbs. A client would want to purchase a certain volume and density of material.
We would create a quotation or sales order. (In Order Line header, 'Quantity' would be changed to 'Extended Quantity').
In Open: Order Lines screen
Add the following fields and convert current 'Quantity' field into a calculated field as 'Extended Quantity':
- Base Quantity
- (multiplier 1) Width
- (multiplier 2) Length
- (multiplier 3) Height
- (multiplier 4) Density
We would again purchase by the kg/lbs a BoM product with base measure as Width=1m, Length=1m, Height=1m, Unit Weight=50kg.
We would then sell per customer specs: Base Qty: 80pcs @ Width=0.2m, Length=0.5m, Height=1.5m, Density=1.4
The sales form would then show an Extended Quantity=12m3 (base qty*width*length*height) for BoM=840kg(Extended Qty*Density*Unit Weight) ie [12m3*1.4*50kg]
I hope this makes sense. The concept can be used in most industries from metals, fluids, timber, glass, etc.