Delete a voucher

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Delete a voucher Kakalina 06-08-2007  RE: Delete a voucher convoluted 06-11-2007
Posted by Kakalina on June 8, 2007, 3:05 pm Please log in for more thread options How can I delete a voucher that has a negative balance (failed experiment from two years ago)? Posted by convoluted on June 11, 2007, 11:37 pm Please log in for more thread options Hi Kakalina You can always query via administrator, but one of the things I've learned about RMS is you need to be aware of all the tables you should update or you'll risk creating orphaned records. Wait a few days for some additional feedback and suggestions to your question If you don't get any additional postings and you just must delete that voucher with a negative balance, run these queries select * from voucher where balance < 0; this will show you all vouchers with a negative balance; jot down the ID then run this query to delete it/them **BACKUP FIRST**and consider doing this after hours.... DELETE from voucher where id = x where "x" is the id you jotted down for that voucher with a negative balance; you can re-run the select query to make sure it's flushed out... Hope this helps..... "Kakalina" wrote: > How can I delete a voucher that has a negative balance (failed experiment > from two years ago)? Similar Threads Posted Redeemed voucher - voucher number on receipt with the balance deta September 24, 2008, 10:45 am Voucher October 4, 2005, 5:53 pm Voucher as payment June 5, 2006, 6:07 pm Voucher Balances May 14, 2007, 12:33 pm Close a Voucher December 15, 2007, 7:42 pm voucher creation at POS March 13, 2008, 2:48 am Voucher Sales April 1, 2008, 10:28 am MSR Voucher/Gift Card February 11, 2006, 7:27 pm Voucher as percent of transaction March 27, 2006, 7:13 am Voucher vs. Gift Card June 19, 2006, 7:54 pm