1. Home
  2. Point-Of-Sale Software
  3. sql to delete cashier sales

sql to delete cashier sales

Does anyone know how to create an SQL statement that would delete sales for a particular cashier. And can it be expanded to include delete only cash tender types?

Reply to
Roxanne
Loading thread data ...

Hi Roxanne - did you ever figure out how to do this?

Thanks, Chris

"Roxanne" wrote:

Reply to
bopper

Reply to
Roxanne

Can you explain what you are actually trying to accomplish.

The CashierID is recorded against the Transaction in RMS this can be changed.

If you delete a Cashier the CashierID still remains against the transaction.

Try this in Store Operations Administrator

SELECT Cashier.Number, Cashier.Name, [Transaction].Time, [Transaction].TransactionNumber, [Transaction].Total, [Transaction].SalesTax, [Transaction].CashierID FROM Cashier RIGHT JOIN [Transaction] ON Cashier.ID [Transaction].CashierID

Reply to
Michael

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.