Knowledgebase
[QODBC-Desktop] Troubleshooting - How do I void an Invoice?
Posted by Jack - QODBC Support on 09 March 2016 01:06 PM

Troubleshooting - How do I void an Invoice?

Problem Description:

I don't see any indicator in the Invoice table. How do I void an Invoice? And How do I query for invoices that have been voided? 

Solution:

You can use SP_VOID just like you would use DELETE. It will void the invoice instead of deleting it.

For Example:

SP_VOID FROM Invoice WHERE TxnID = '1B03F-1513346399'



You can use the below query to get a list of Voided Invoices.

Select RefNumber, CustomerRefFullName, and Memo from Invoice, like 'VOID:%.'

If no InvoiceLine is returned, you can resync your optimized InvoiceLine table by running:



(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).