Skip to Content
0
Former Member
Sep 30, 2013 at 10:22 PM

Query price list with BP catalog no.

62 Views

I hope someone can help me with this query.


We need a pricelist that also list the BP catalog numbers in additon to our numbers and prices from 2 pricelists. (1 & 2)

If we are able to choose BP when running the query it would have been great. We can then can use this on all customers
using BP catalog numbers. It would be an great advantage to query only one BP at the time.

Field that we need is BP code, Itemcode, BP itemcode, Item description, Price 1 & Price 2.

I am stuck on this query so I would be really greatful if someone can help me out.