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 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, need to supply the required value for the API. QuickBooks message: Required parameter Line.SalesItemLineDetail is missing in the request

Solutions:

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

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

You first need to create any item without providing price/rate in Item module, then you need to provide ItemName in your query. In this example, I have created Item "Test" & use it in the query. You can use RefNumber column to insert InvoiceNumber. If you don't want to provide InvoiceNumber, then QuickBooks Online automatically add Invoice number to Invoice. Please see below query without including RefNumber:

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

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