List of customers who have bought an item

In HQ run the Detail Sales Report (Reports - Sales - Detailed Sales) and select the timeframe you are interested in and add the ITEM as a filter.

"Philip Gass" wrote:

Doh!

How did i miss that!!! :)

Ahhhh, i knew there was something more to my question than i had realised!! :)

What i actually want is to pull up all transactions containing a certain item....

In effect, i want to be able to analyise the effect of a loyalty coupon scheme, and see if people are buying other items as well as the free coffee etc etc.

Can anyone think of a report which can manage this?

Thanks!

What you would want to do is pull up a report that shows all transactions that had the loyalty item on it. The attached report has that option.

begin 666 Memorized-Item Sales Report.qrp M+R\M+2T@4F5P;W)T(%-U;6UA

Maurice,

thanks for the report, but i want it to show all other items in the transaction too, not just a list of transactions which contained this item....

I need to see a list of all transactions 'Containing' that item. That way i can determine if there was a spend up and above that of the free items.

Thanks again

Phil

Click on the transaction number in the report.

Hi Philip - see if this works for you - put your "loyalty" itemlookupcode where you see XXX - the below query returned all items that were on the same transaction as 'XXX' - tested on my laptop and it seemed to work to the T

select transactionentry.transactionnumber, itemlookupcode, description, transactionentry.quantity from transactionentry left join item on transactionentry.itemid = item.id left join [transaction] on transactionentry.transactionnumber [transaction].transactionnumber where transactionentry.transactionnumber in (select transactionnumber from transactionentry left join item on transactionentry.itemid = item.id where itemlookupcode = 'XXX') and itemlookupcode 'XXX' order by transactionentry.transactionnumber

You can also try adding some date constraints, ie and itemlookupcode 'XXX' and [transaction].time > '11/20/07' (to see transactions after nov 27th)

H> Maurice,

Thanks for this! I will test shortly! :)