Knowledgebase: Data & Table
[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 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. 

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

 

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