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

Powiązane posty	Odpowiedzi	Widoki
[v19.sh] Critical Sync Issue: Data Inconsistency between Backend UI, Website, and SO Prints purchase	0 maj 26	7
Product duplicated multiple times in "RFQ" created from approval module "PR" purchase	2 kwi 26	1977
Can I Host Odoo on Hostinger purchase	1 kwi 26	3903
Import Purchase Orders from Excel without creating duplicate Vendors or Products V19 purchase	1 kwi 26	1360
Studio Approvals: After configuration I can only get a User Group (not a User) working. Has anyone addressed this? purchase	1 kwi 26	2311

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!