Skip to Content
This question has been flagged
productbugfixUoM
1 Reply
2289 Views
Avatar
Auto Craft Engineering

For some product we have multiple vendors

Each vendor can have different price breaks based on quantity ordered

Each vendor can have different min order levels

Different vendors use different unit of measures

We often buy in Different UoM to What we sell


I am trying to add them as suppliers on a product, but some supplier sell their goods in different UoM to others, how do we do this?


Here is an example
supplier                     min order Qty                 UoM                         price (per pack)
Supplier CC              2 (packs of 4)                 pack of 4                   £1.82
Supplier CC              3 (packs of 4)                 pack of 4                   £1.56
Supplier CC.             5 (packs of 4)                 pack of 4                   £1.34
Supplier W                1 (Pack of 100)               100                            £54.77


So how do I add these (this is easier than some of the other products which have more UoM) Without making the PO look really confusing and without increasing to extra decimal points.
Seems this would be normal in any business


Attached  is an example of what i mean the top half of the image is how we have had to put products suppliers in and the bottom half of the image is how we would like it to be done


As you can see, ordering 0.08 of a product that comes in sets of 4, but is displayed in units of 100 is open to so many mistakes and problems. 


On our current system we would order....

2 lots of 4 (@ £1.82 per Pack of 4) = £3.64

On Odoo we would order need to order.... 

0.08 of 100 (@ £45.50 per 100) = £3.64



I hope this is clear we just feel this is going to be really difficult on our PO for suppliers to understand and will also cause issues internally
Please let me know if there is anything you are able to help with or if anyone else has had similar issues and what solution they use. Would it be able to be customised to display correctly for us or would this be a massive undertaking. Look forward to your really with a really easy solution hopefully


I hope this makes sense be great to hear some suggestions!

Avatar
Discard
Auto Craft Engineering
Author

Is Odoo really that broken it cant do this?

Avatar
Apiuser
Best Answer

You can create reordering rules that replenish multiples of 4 at each of those suppliers. I think you are abusing the use of UoM here, and I would keep it on a basic 'unit'. This will only work on Odoo 16.0, since it is the first version where you can assign a supplier to a rule.

If you don't have Odoo 16.0...

For other suppliers you can just play with packs (following your example):

supplier                     min order Qty                 UoM                         price (per pack)
Supplier CC              2 (packs of 4)                 pack of 4                   £1.82
Supplier CC              3 (packs of 4)                 pack of 4                   £1.56
Supplier CC.             5 (packs of 4)                 pack of 4                   £1.34
Supplier W                25 (Pack of 4)                pack of 4                   £54.77

Or play with units which is what I would recomend(following your example):

supplier                     min order Qty                 UoM                         price (per pack)
Supplier CC              8                                      units                          £1.82
Supplier CC              12                                    units                          £1.56
Supplier CC.             20                                    units                         £1.34
Supplier W                100                                  units                         £54.77

Hope that helps.



Avatar
Discard
Auto Craft Engineering
Author

Sorry little background to Add here v15 - we currently have over 4000 products many come from multiple suppliers based on availability and many supply in deferent quantities

Using the first way would cause problems i think Surly that is saying a pack of 4 sold by supplier W would cost £54.77 if you divide it by 4 you'd get too many decimal places what happens when you order 125 that supplier only supplies in packs of 100.

On the second method - I know this is not the case here (but if Supplier w was the cheaper and) someone wanted to order a 120 of these it would try to order off supplier W but they only sell in 100's. Meaning they would not ship 120 of these, and there would be confusion on the PO. Also if i sent a purchase order over to that company with a 100 units on they would most likely send out a 100 x 100packs they sell in 1 pack that contain 100

I really appreciate the time you have taken and if I've missed something i would love to here any suggestions or if i have just misunderstood

Odoo really does seem to be only half ready to use with some gapping problems
Would this be a good idea to get the customisation done you think?

Apiuser

I understand what you are saying and I understand you are descriving a complex scenario. Odoo may not have what you are looking for then, at least Odoo without costumisations. I guess what you really need is to make/look for a custom app that can use several purchasing UoM on different purchase lines, but on the same type of Unit (for example if you buy in packs of Units, different size packs; if you buy in Kg, different weight units...).

Related Posts Replies Views Activity
Unit of Measure Category Conflict in MRP Orders
UoM
Avatar
Avatar
2
Oct 24
157
Products Not Showing
product
Avatar
Avatar
Avatar
3
Aug 24
2849
Add field on product.template
product
Avatar
1
Apr 24
30
Modify field only if admin. Solved
product
Avatar
Avatar
Avatar
3
Apr 24
584
Unable to add some related products. v15
product
Avatar
Avatar
1
Jan 24
919