I have a company in which I sell paper by roll, but invoice it by another variable UoS (kilogram, meters) In Odoo v8, there is a multi UoM feature, but it is not quite right for my company's specification.
What I need is almost similar to "Catch Weight" in a different industry.
1 Roll = 2000 KG (average)
Price per KG = 0,5 $
I make a quotation for a customer by roll, and an average estimated quote price is calculated according to the number of rolls quoted.
10 rolls x 2000 KG = 20.000 KG
20.000 KG x 0,5 $ = 10.000$
The problem is, the product weight per piece varies, some are weighed at 2150, 1945, 2005KG, etc. And I only invoice based on the ACTUAL weight.
Currently, if I set product UoM and UoS to kg and unit respectively, when I deliver product using the actual weight, the unit is converted.
10 rolls, actual weight 21.500 kg
UoS is changed to 10,75 roll. (I do not want this to happen, I need it to stay at 10 rolls)
I need a module that has the following feature:
Sales and Purchase: Can order with both UNIT and WEIGHT value
Invoicing: Can invoice by variable weight with unit information. The piece/unit information is recorded into the database, along with the weight information.
Warehouse: In quants view, to be able to display BOTH units and weight column. The unit column DOES not get factored in the inventory valuations. Inventory valuations are based on the default UoM only.
If you have any other solution to the problem i face above, please feel free to include it in the proposal.