Knowledgebase: Syntax
[QODBC-Online] Troubleshooting - How to create blank Invoice in QuickBooks Online using QODBC
Posted by Jack - QODBC Support on 02 March 2015 12:09 PM

Troubleshooting - How to create a blank Invoice in QuickBooks Online using QODBC

Problem Description:

How do I create a note (or a blank line) on the invoice? If I do it the same way that I do it using QODBC for QuickBooks, I get an error :

Error sending txn to QB: 2020: QuickBooks message: Required param missing. We need to supply the required value for the API. QuickBooks message: Required parameter Line.SalesItemLineDetail is missing in the request.


You can create a blank invoice from QODBC Online by using below sample query:

INSERT INTO "InvoiceLine" (CustomerRefFullName,"InvoiceLineItemRefFullName", RefNumber) VALUES ('Aadi Vanhorn','Test','Blank001' )

You must create an item without providing a price/rate in the Item module. Then it would be best if you delivered ItemName in your query. In this example, I have created the Item "Test" & use it in the question. You can use the RefNumber column to insert InvoiceNumber. If you don't want to provide InvoiceNumber, then QuickBooks Online automatically adds the Invoice number to the invoice. Please see the below query without including RefNumber:

INSERT INTO "InvoiceLine" (CustomerRefFullName,"InvoiceLineItemRefFullName") VALUES ('Aadi Vanhorn','Test')



Tags: QuickBooks Online, QBO, Create Blank Invoice, QODBC Online


(4 vote(s))
Not helpful

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