Knowledgebase: Tutorials
[QODBC-Desktop] How to Insert Opening Balance in Customer Table using QODBC
Posted by Rajendra Dewani (QODBC Support) on 25 November 2013 10:38 AM

How to Insert Opening Balance in Customer Table using QODBC

Problem Description

Initially, I received the error "[QODBC] Field not allowed in insert" when I tried to insert data into the Customer table through QODBC. I was trying to insert customer data (Name, AccountNumber....., Balance, credit limit). But QODBC is not allowed me to insert data. When I attempted to insert received the below error:

 

Solutions

     Use the "OpenBalance" field instead of the "Balance" field, As QuickBooks SDK does not allow to insert value in the "Balance" field but uses "OpenBalance." After inserting the value in the "OpenBalance" field, the value is moved to the "Balance" field.

     Sample Query:

Insert into Customer
(AccountNumber,Name,BillAddressAddr1,BillAddressAddr2,BillAddressCity,BillAddressState,BillAddressPostalCode,BillAddressCountry,Phone,Fax,Email,Contact,Notes,SalesRepRefFullName,CustomerTypeRefFullName,TermsRefFullName,CreditLimit,OpenBalance,IsActive)
Values ('ABC-111', 'XYZ', 'DEF St. ', '', 'Minneapolis', 'MN', '55401', '', '999 999-9999', '', 'temp@xyz.com', 'XYZ', 'great guy', 'XYZ', '', 'COD', 0, 0, 1) 

     Note: Sample query contains dummy data. You can add/remove fields from the question as per your requirements. Ref fields are subject to change as per your company file.

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