V18 picking the wrong line for a PO

Question

We buy a product from the same vendor under 2 different vendor part numbers, depending what is in stock. They are slightly different but interchangeable for our purposes. For products we buy from different vendors I just put the vendor I want on top in the purchase tab of the product page and the PO is generated with that vendor and number. In this case it always picks the first one that was entered, not the one on top. I want to buy the one ending in 604 but it always puts the 603 one on the PO.

It does not seem to matter which one of these I choose:

Is there any way to get this to work without having to set start and end dates? TIA.

Debbie · Answer

Odoo does NOT let you manually choose between two vendor part numbers for the same product. By default, it always picks the vendor line with the lowest price (or the first one if prices are equal).
*The only workaround without dates:*
Set different prices for each vendor line (even $0.01 difference)
Odoo will then select the one with the lower price
*Better solutions:*
Create the product as two separate products (e.g., "Product - 603" and "Product - 604") with their own vendor codes
Use Purchase

Publications associées	Réponses	Vues
[v19.sh] Critical Sync Issue: Data Inconsistency between Backend UI, Website, and SO Prints purchase	0 mai 26	7
Product duplicated multiple times in "RFQ" created from approval module "PR" purchase	2 avr. 26	1979
Can I Host Odoo on Hostinger purchase	1 avr. 26	3904
Import Purchase Orders from Excel without creating duplicate Vendors or Products V19 purchase	1 avr. 26	1360
Studio Approvals: After configuration I can only get a User Group (not a User) working. Has anyone addressed this? purchase	1 avr. 26	2311

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !