QODBC Read-Only Table List

Problem Description:

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

I am getting "[QODBC] Not supported" error when trying to insert records.

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

Solution:

You may get "[QODBC] Not supported" error, If you are trying to insert the record in the Header/Master table directly without inserting the record in the Child/Detail table.

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

OR

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

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

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 "TABLE OVERVIEW" label & find the TableName for which you want to check schema and click the "Detail" link.

You will find QUERYABLE, UPDATEABLE, INSERTABLE, REQUIRED ON INSERT columns against each of the fields.

This will help you find out which of the fields are allowed in select, update and insert queries.