Several Price Lists for Purchase Orders

[projay]

I am setting up a purchase order and we purchase from different companies and of course that means different price lists.

I have set this up similar to invoicing sample from "comment"'s layout out. Which is 4 tables:

Customer Info

Invoice(renamed to purchase order)

Linitems

Products

Is their a way to do a look up on different price lists from each vendor?

Thanks.

Jay

[comment]

In principle, if you have a Prices table with fields for ProductID and VendorID, you can look up the price (after selecting the product and the vendor) through a relationship matching these two fields.

In practice, this often needs to be modified slightly - depending on how you obtain vendors' prices.

[projay]

I just have it setup just like the invoice_demo file...which allows one set of products. We order from several vendors with different products and price list.

Jay.