I have a product which when created from the MO pulls inventory raw materials by weight. However my final cured product varies in weight. No two are exactly the same weight. Which means (currently) I will need to create endless varied products each with different weights which is ridiculous. I need to invoice these products out per kg basis. How can I set this up so I can invoice the product out priced per kg?
Create your product like this:
REF: E000123 (or whatever ref code you use)
LABEL: MOZZARELLA CHEESE 1KG (or LB, or GR, or Ton, or whatever weight unit you use)
PRICE: $4.75
When you are filling out the invoice (in the invoice module or in TakePOS), use decimals for the quantity to sell. If the cured cheese weighs 1.33 kg, then you should put 1.33 in the quantity.
If I go this route, say my product uses 1kg as a weight. When I sell 0.80kg. I will have a 0.20kg of the product left in stock, repeat this a hundred transactions and I will have 20kg of stock left when infact I have nothing left. This is the concern.
OK, I see.
Here is the closest thing that I know of for what you’re trying to get. It is only an approximation, because losses by drying or similar processes are not always exactly the same, but it will then give you an approximate control that is much closer to reality than the no-loss model that you seem to have.
In the “Bill of Materials” page, where you define the list of products for your finished product, there is a field for “efficiency” of each product. In the case of “cheese 1kg”, for example, in the “milk” row, I would put an efficiency of around 0.1, because it takes 10 lt of milk to make 1 kg of cheese. Then, dolibarr will subtract the extra nine kg of production materials in every kg of cheese, and the correlation will be kept approximately correct.
If the curing process is very much different every time it is done, you would need to adjust finished weight of your product in inventory after every production run to keep your inventory in control.
