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

Похожие посты	Ответы	Просмотры
[v19.sh] Critical Sync Issue: Data Inconsistency between Backend UI, Website, and SO Prints purchase	0 мая 26	7
Product duplicated multiple times in "RFQ" created from approval module "PR" purchase	2 апр. 26	2330
Can I Host Odoo on Hostinger purchase	1 апр. 26	4335
Import Purchase Orders from Excel without creating duplicate Vendors or Products V19 purchase	1 апр. 26	1674
Studio Approvals: After configuration I can only get a User Group (not a User) working. Has anyone addressed this? purchase	1 апр. 26	2400

Этот вопрос был отмечен

Не оставайтесь в стороне – присоединяйтесь к обсуждению!