How can I delete a voucher that has a negative balance (failed experiment from two years ago)?
Delete a voucher
Jun 08, 2007
1 Replies
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... H> How can I delete a voucher that has a negative balance (failed experiment
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required