Knowledgebase: Tutorials
[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 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 just make sure there is at least one line with data in your invoice to create empty line records.



You can create same from QODBC by using below queries. Please note you need to create one line of sufficient data. For rest line, you can just add 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).