Hi Naveenskris,
I'll do my best to answer your questions below:
"How can i make use of customfields in the table Customer in Method Integration"
-The "custom fields" you are seeing in the customer table, are actually the custom fields found from QuickBooks. There are up to 15 custom fields in QuickBooks that can be used by customers, vendors, employees and items. If the field is in use, i.e. the QuickBooks user has activated it and given it a lable, then it should appear in Method with the actual label. If the field is not in use, you'll see either "customfield1" or "hiddencustomfield1".
Unless you are already using these custom fields in QuickBooks, I suggest you simply make your own fields, of whatever datatype you like directly in Method, under Customize > Tables / fields. This currently is done directly in Method, and not using the MethodAPI (not yet anyway). The benefit is that you have as many fields as you like, and you can define the datatype, and once they are created they are exposed to the MethodAPI for read and write.
"Here in arrInsertFieldsArray , i tried to pass CustomField2 with corresponding arrInsertValueArray .. But its not inserting the value in CustomField2 "
-If you are going to use QuickBooks custom fields, use the same label as you see in QuickBooks, not "CustomField2". In the MethodAPI Documentation, check out the API call for "MethodAPIFieldList". This will give you a list of the fields in each table, and the names of the fields.
"How can i pass some field values like TotalBalance? TotalBalance datatype is Money.."
-Don't worry about the datatypes. We do the conversion for you in the MethodAPI. So if you pass a numeric value like Rate or Qty as a string, we'll convert it in the API to be numeric before it hits the database.
-Fields like TotalBalance are read only. In the MethodAPI Documentation, check out the API call for "MethodAPIFieldList". This will give you a list of the fields in each table, and whether or not the fields supports edits or adds. As you can see from the "Customer" table in TotalBalance is False for supporting edits or adds.
Also, as per the MethodAPI documentation:
"How do I get more information about the meaning of these fields and tables? The fields and tables from Method that come from QuickBooks conform to the QuickBooks SDK. You can visit http://developer.intuit.com/qbsdk-current/Common/newOSR/index.html and go through the OnScreen Reference guide to find out what is supported from each version of QuickBooks. "
If you go there, you'll see which QuickBooks fields are available for writing and which ones are merely calculated fields.
I hope that helps.
Paul