Finding Exclusive Parts for Customer

Thomas -



You could write a BAQ for tables OrderDtl, OrderHed, Customer and
display the columns Customer Name or ID and Part Number. Then export
the BAQ data to Excel and use a Pivot Table to see which parts are
bought by whom.



Thank you in advance,

Calvin Dekker

Email: calvin@... <mailto:calvin@...>

http://www.codabears.com <http://www.codabears.com>

<http://www.codabears.com/>

*New software/hardware Support & Maintenance Programs







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas
Sent: Wednesday, December 09, 2009 9:31 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Finding Exclusive Parts for Customer





Can anyone point me in the right direction. We have a customer that has
many part numbers that we sell to them exclusively and other parts dont.
I wanted to know if I can run a BAQ that will show What the customer
buys and all other customers by, then filter out the part numbers others
dont buy. Is this possible with PartTran and Customer tables?





[Non-text portions of this message have been removed]
Can anyone point me in the right direction. We have a customer that has many part numbers that we sell to them exclusively and other parts dont. I wanted to know if I can run a BAQ that will show What the customer buys and all other customers by, then filter out the part numbers others dont buy. Is this possible with PartTran and Customer tables?