Skip to Content
Menu
This question has been flagged
2 Replies
2370 Views

We purchase fluids in many different container sizes, and they are sold/used in manufacturing by the Liter.

So for example we may purchase, all from the same vendor, a 20L drum, a 205L drum, a 1040L container - all of the same fluid, but with a different per liter cost for each. 

E.g. Vendor A sells:

  • 20L Drum @ $20

  • 205L Drum @ $200

  • 1040L Container @ $1000

I want to set up vendor pricing for each size, but once purchases I want the system to recognize how many liters we have, i.e. these should all be treated as the same product, just purchased in different package sizes at different unit prices. A purchaser should be able to select between the various packaging sizes and have the purchase price adjusted accordingly.

There doesn't appear to exist an option to purchase in multiple different UoMs.

Packaging options appear to only apply to Sales and not Purchases

Product variants don't work because they don't retain the relationship between the different packaging sizes


I am at a loss here - I don't think Odoo can do this without significant customization but thought I would ask...

Avatar
Discard
Author

I should add we are using Odoo v12

Best Answer

Hi Dan,

You can solve this by activating "Sell and purchase products in different units of measure", creating your own UOMs, based on Liters (Drum20, Drum205,  ) and when creating the product select the Liter unit and on the Tab Purchase (Products and Pricelists activated), specify different prices (and vendors if needed), for example 1l for $1 per liter, 200 for $0.95 per liter.

When you make the purchase and select your UOM (recipient) there will be the price for the specific quantity and your inventory will be calculated in liters.

BR

Ricardo

Avatar
Discard

Thanks Ricardo. This gets us part of the way there but still doesn't solve the issue. This doesn't allow us to purchase fluids in different package sizes since vendor pricelists don't consider the UOM/product packaging when calculating the cost.

We could set up the prices as you've described, but the cost on the PO still would not consider the packagings. Eg., if we buy 1 205L drum and 1 20L drum, the cost should be $220, but with the setup you described, the cost would be calculated at the 205L rate for a total of $219.51.

We are starting to look into setting up different products that get unpackaged into a single product (from a BOM?) with a uom of liters, but would appreciate any insight into the cleanest way to handle this.

Thanks again!

Best Answer

Hello Ricardo !
Did you find a solution to this problem ?
Thanks

Avatar
Discard