Knowledgebase: Setup
[QODBC-ALL] QODBC Read-Only Table List
Posted by Jack - QODBC Support on 19 September 2017 09:42 AM

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. 

Table Name
AccountTaxLineInfo
Barcode
BillLinkedTxn
BillPaymentCheckLineLinkedTxn
BillPaymentCreditCardLineLinkedTxn
BillToPay
ChargeLinkedTxn
Company
CompanyActivity
CreditMemoLinkedTxn
CustomerShipToAddress
CustomField
EmployeeAddtionalNote
Entity
EntityAdditionalNote
EntityContacts
EntityShipToAddress
EstimateLinkedTxn
Host
HostMetaData
HostSupportedVersions
InvoiceLinkedTxn
Item
ItemAssembliesCanBuild
ItemReceiptLinkedTxn
ItemSites
JournalEntryLine
ListDeleted
PayrollItemNonWage
Preferences
PurchaseOrderLinkedTxn
ReceivePaymentLineLinkedTxn
ReceivePaymentToDeposit
Sales
SalesLine
SalesOrderLinkedTxn
SalesTaxPaymentCheck
SalesTaxPaymentCheckLine
Template
Transaction
TxnDeleted
VendorContacts
VendorCreditLinkedTxn
WorkersCompCodeRateHistory
 

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.

 

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