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 QODBC

Note: 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 QODBC

UnPending 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

 

(79 vote(s))
Helpful
Not helpful
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.

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