Off-Line Simulate Z-report

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.... I know that once reconnected a z-report can be done but sometimes we are ar trade shows for three days...

Danny

Reply to
Danny
Loading thread data ...

Isn't MS suppose to monitor threads and answer within 48 hours - Isn't that part of the maintenance plan?

Danny

Reply to
Danny

Isn't MS suppose to monitor threads and answer within 48 hours - Isn't that part of the maintenance plan?

Danny

Reply to
CptSoft

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.