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,CreditLimit). But QODBC is not allowed me to insert data. When I attempt to insert received below error:

 

Solutions

     Use "OpenBalance" field instead of "Balance" field, As QuickBooks SDK does not allow to insert value in "Balance" field but uses "OpenBalance". After inserting value in "OpenBalance" field, the value is moved to "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 Ref field are subject to change as per your company file. You can add/remove fields from the query as per your requirements.

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