Purchase History in HTML Status Window

Wow, great question for customer service and follow-up add-on sales.

As an extention, can a list of the last 5 items purchased be shown in this window?

Got to be a way!

Aloha, Miles

Pacific Computer Systems Miles Baidack snipped-for-privacy@pacificcomp.biz

Supporting Business Since 1985 Phone: (808)395-8156 or (808)277-8156

------------------------------------------------------------

"Haik" wrote:

Hi there,

Yeah, I think it can be done, all the information saved into the database of RMS SO, can be shown on the HTML screen. What You need is a programmer, that would change/modify the status HTML window (or create a new one), that will detect that a Customer is loaded into POS screen and search for the last purchase of this Customer and shw up the data...

It's a personalization, an add-on, that would probably has it's price ... not too much, but still...

Regards,

Its a really good way to sell...

I looked > Hi there,

Hi again,

Try connecting the CustomerID field You will find into the Transaction table with ID field from Customer table and then, use the TransactionNumber from Transaction table to connect with Transactionentry table (same field), and get all the Items (field ItemID) from TransactionEntry....

mail me if you need more help...

Regards, A.

Hi Haik,

Try this:

SELECT

FROM TransactionEntry LEFT JOIN [Transaction] ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber LEFT JOIN Customer ON [Transaction].CustomerID=Customer.ID

WHERE Customer.ID

It will give you all purchase history for specified customer. You can use fire events to get customer id and call that query. There is nice example how to use sql querys in html windows just in SO (.../store operations/html/drilldown.htm)

Regards, Arthur

Haik wrote:

Posting actually html would be great for everyone to learn from it.

Danny