Hi Folks
Once in a while, we do trade shows and use the off-line mode. I would like to have the ability to simulate z-report - in order to know how well I did at the show. I would be interested in knowing what other people are doing...
Not sure which of the transaction tables to use... Transaction, TransactionEntry , TransactionHold, TransactionHoldEntry
I did a few tsql report scripts - this is what I have so far -
\ - listing of stuff sold.. SELECT [Transaction].Time, [Transaction].TransactionNumber, item.ItemLookUpCode, TransactionEntry.Price, TransactionEntry.Quantity, Item.Description FROM TransactionEntry INNER JOIN [Transaction] ON TransactionEntry.TransactionNumber [Transaction].TransactionNumber INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID LEFT JOIN Item ON TransactionEntry.ItemID = Item.ID
\ list of total sales SELECT [Transaction].TransactionNumber, [Transaction].Time, [Transaction].Total, [Transaction].SalesTax, [Customer].FirstName FROM [Transaction] INNER JOIN Customer ON [Transaction].CustomerID=Customer.ID
This appears to work but not user friendly for some of my satff. Can any of the POS reports be called from a VB .net app - Any other options or suggestions would be appreciated....
Danny