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

Publicaciones relacionadas	Respuestas	Vistas
[v19.sh] Critical Sync Issue: Data Inconsistency between Backend UI, Website, and SO Prints purchase	0 may 26	7
Product duplicated multiple times in "RFQ" created from approval module "PR" purchase	2 abr 26	1993
Can I Host Odoo on Hostinger purchase	1 abr 26	3923
Import Purchase Orders from Excel without creating duplicate Vendors or Products V19 purchase	1 abr 26	1369
Studio Approvals: After configuration I can only get a User Group (not a User) working. Has anyone addressed this? purchase	1 abr 26	2311

Esta pregunta ha sido marcada

¿Le interesa esta conversación? ¡Participe en ella!