Knowledgebase: TroubleShooting
[QODBC-Desktop] How to add blank InvoiceLine in QuickBooks using QODBC
Posted by Rajendra Dewani (QODBC Support) on 26 December 2013 10:07 AM

Problem Description:

How can I add blank InvoiceLine in QuickBooks using QODBC?

Solution:

There are empty Invoice line records in QuickBooks, and QODBC can view them too, but you may not be able to create an empty InvoiceLine in QODBC.

You cannot create an empty Invoice either in QODBC or in QuickBooks. But in QuickBooks, you could leave lines blank and ensure at least one line of data in your invoice to create empty line records.

But in QODBC, Invoice lines are inserted by single queries. When you insert a line record, QODBC will automatically generate an invoice to contain this line item.

When the line record is null, there will be no record of the new invoice, which is not allowed by QuickBooks. So QODBC could not create an empty InvoiceLine record.

The empty InvoiceLine record must be ItemGroup/InvoiceGroupLine. Please refer: To how to Invoice ItemGroups using QODBC.

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