Knowledgebase
[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 QODBCNote: There are two columns in table Invoice called "IsPending" and "IsPaid", you could just give them the specified value to get the different status of Invoices. To print pending, unpaid and paid invoices to a file, you could try the queries as below. Queries in QODBCUnPending Invoice SELECT * FROM Invoice where IsPending=0 Pending Invoice SELECT * FROM Invoice where IsPending=1 UnPaid Invoice SELECT * FROM invoice where IsPaid=0 Paid Invoice SELECT * FROM invoice where IsPaid=1
| |
|
Comments (2)
Carlos Urquilla
19 April 2017 05:15 PM
How can I print a bunch of invoices using QODBC using a template from quickbooks?? The above sample is a "SELECT", I am assuming I have to design my own template, if data loaded into ms access
Jack
20 April 2017 06:58 AM
Hi Carlos,
I would like to share that there is no command available for printing Invoice through QuickBooks SDK. You can import Invoice in MS Excel/MS Access & use above query or can refer IsToBePrinted columns & filter IsToBePrinted columns whose value set true. After that, you can print Invoice from Print command. QODBC cannot invoke actions on QuickBooks UI.
I would like to share that there is no command available for printing Invoice through QuickBooks SDK. You can import Invoice in MS Excel/MS Access & use above query or can refer IsToBePrinted columns & filter IsToBePrinted columns whose value set true. After that, you can print Invoice from Print command. QODBC cannot invoke actions on QuickBooks UI.