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?
sql to delete cashier sales
Jun 18, 2008
3 Replies
Hi Roxanne - did you ever figure out how to do this?
Thanks, Chris
"Roxanne" wrote:
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required