[QODBC-Desktop] How to Print Invoices with Different Status using QODBC
Posted by Juliet (QODBC Support) on 30 August 2011 08:35 AM
How to Print Invoices with Different Status using QODBC
Note: There are two columns in the invoice table called "IsPending" and "IsPaid" you could give them the specified value to get the different statuses of Invoices.
You could try the queries below to print pending, unpaid, and paid invoices to a file.
Queries in QODBC
SELECT * FROM Invoice where IsPending=0
SELECT * FROM Invoice where IsPending=1
SELECT * FROM invoice where IsPaid=0
SELECT * FROM invoice where IsPaid=1