customer and pricing query
I am looking for a query to pull the following. Maybe someone already has query and can share with us
Only for active customers
Customer number
customer name
address
Price List from account level
Price List from bill to level
if the customer is a qualifier for any price list, either primary or secondary price list
thanks
Indira