QODBC Read-Only Table List

Problem Description:

I am using QODBC & trying to modify data in QuickBooks. In a few tables, I can't insert/update records.

I am getting a "[QODBC] Not supported" error when inserting records.

Also, I have noticed "Error Modify not supported on this table" in QODBC Logs when trying to update records.

Solution:

You may get a "[QODBC] Not supported" error if you try to insert the record in the Header/Master table directly without inserting the form in the Child/Detail table.

For Example, You may get a "[QODBC] Not supported" error if you try to insert a record directly Invoice/Bill/SalesOrder/PurchaseOrder, etc... table without inserting a document, the child table InvoiceLine/BillExpenseLine/BillItemLine/SalesOrderLine/PurchaseOrderLine.

OR

You may get the "[QODBC] Not supported" error or "Error Modify not supported on this table" in QODBC Logs If you trying to insert/update the record in the Read-Only table.

Below is the list of Read-Only which does not support insert/update operations. 

To know which tables/fields support insert/update. Please visit QODBC Data Layouts.

Click on the region of the QuickBooks edition you are using. Click "ALPHABETICAL LISTING OF ALL TABLES" under the "TABLE OVERVIEW" label & find the TableName for which you want to check the schema, and click the "Detail" link.

You will find QUERYABLE, UPDATEABLE, INSERTABLE, and REQUIRED ON INSERT columns against each field.

This will help you determine which fields are allowed in select, update, and insert queries.