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 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

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).