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.
Without creating a new module, i think this can be achieved by combining some features from different modules (from standard addons and extra addons).
Try to see what you can get with the following modules by just creating a new product or product variant for each Density of product with some attributes:
You can find the above modules at https://www.odoo.com/apps (if not let me know, i will submit the needed links).
Added after comment:
This is the easiest and quickest way to fulfil your needs. The other way is to build a new module (a new vertical app from scratch) like you stated in your question, this is possible but involves time and some skills. On my side i will continue (when i can during my free time) exploring the first approach and keep you informed.
You can start by studying the code of the next module to see if it can serve as a basis for the second approach:
New modules to test:
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/28/14, 8:08 AM|
|Seen: 1768 times|
|Last updated: 8/5/16, 12:53 PM|