1. Home
  2. Point-Of-Sale Software
  3. adding SQL Query to make Custom POS button

adding SQL Query to make Custom POS button

Is there anyway i can access a customers Purchase History in my database and write a Query to display specific information that i want

Reply to
Shoby
Loading thread data ...

Shoby,

SELECT [Transaction].Time, [Transaction].TransactionNumber, [Transaction].StoreID, IsNull(Store.Name, '''') AS StoreName, [Transaction].ReferenceNumber, Item.ItemLookUpCode, TransactionEntry.Price, TransactionEntry.Quantity, Item.Description FROM TransactionEntry INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber AND TransactionEntry.StoreID = [Transaction].StoreID INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID LEFT JOIN Store ON TransactionEntry.StoreID = Store.ID WHERE Customer.AccountNumber='0000001'

- Evan Culver New West Technologies

Shoby wrote:

Reply to
Evan Culver

Were you able to create custom button with sql query.

How can i create custom butt> Shoby,

Reply to
Sam Thakkar

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.