@Jesse I read this posting, which is something closer:
How do I void tips after using Cancel Payment
And I saw that you were commenting that “are you giving that customer their money back”
What issue I’m having is is more like:
I have a ticket with 200.00 outstanding
I press the divide/x button and have a 100.00 balance… I enter 120.00, press cash, the 100 goes to the cheque, and the 20 is put in to a ‘cash tips’ account.
Then, I press 120 again, and push visa… 100.00 goes to the ticket, and the remaining 20.00 is in visa tips.
Now, Whatever reason, we need to cancel payments… the 200.00 to the ticket disapears… the 20.00 to the cash tip account disappears (it was the first tip)… but the 20.00 to the visa tip account hangs around.
So, its either a bug in ‘Cancel Ticket Payments’, or its something else.
I tried to remedy this with some custom SQL script, being:
(Note: $ used because ‘AT’ is a forum reserved symbol)
DECLARE $TempTXID AS int;
SELECT $TempTXID = [AccountTransaction_AccountTransactionDocumentId] FROM [Payments] WHERE [TicketID]=‘$1’;
DELETE FROM [AccountTransactions] WHERE AccountTransactionDocumentId = $TempTXID;
DELETE FROM [AccountTransactionDocuments] WHERE Id = $TempTXID;
DELETE FROM [Payments] WHERE AccountTransaction_AccountTransactionDocumentId = $TempTXID;
But that didn’t help, or seem to execute either.
Perhaps I should submit an issue report for Cancel Ticket Payments?