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.