Delete a voucher

How can I delete a voucher that has a negative balance (failed experiment from two years ago)?

Reply to
Kakalina
Loading thread data ...

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

Reply to
convoluted

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.