Knowledgebase: Data & Table
[QODBC-Desktop] How can I add blank InvoiceLine in QuickBooks using QODBC.
Posted by Jack - QODBC Support on 30 October 2015 09:14 AM

Problem Description:

How can I add a blank InvoiceLine in QuickBooks using QODBC?

Solution:

You can create an empty Invoice, neither in QODBC nor QuickBooks. But in QuickBooks, you could leave lines blank and ensure at least one line with data in your invoice to create open line records.



You can create the same from QODBC by using the below queries. Please note you need to create one line of sufficient data. For the rest line, you can add a description & keep other fields blank.

When the line record is null, there will be no record for the newly created invoice, which is not allowed by QuickBooks.

INSERT INTO InvoiceLine (CustomerRefListID, RefNumber, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('670000-1071517519', '71099', '320000-1071525597', 'POWERTRAK-2000', 200.00000, 200.00, '20000-999022286',1)

INSERT INTO InvoiceLine (InvoiceLineDesc, FQSaveToCache) VALUES ('POWERTRAK-3000', 1)

INSERT INTO InvoiceLine (InvoiceLineDesc, FQSaveToCache) VALUES ('POWERTRAK-4000', 0)

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