Problem Description:

I am attempting to add InvoiceLine records to a sample company. I exported 15 InvoiceLine records from QuickBooks via QODBC, then built a table with these records trimmed down to what I believe are the minimum required fields, then appended this table back to the QODBC InvoiceLine linked table.

I received the following error message: ODBC - insert on a linked table "InvoiceLine" failed.
[QODBC]Field not allowed in insert (#10046)

Solution:

A few column values are automatically generated by QuickBooks SDK and are not allowed during Insert/Update. Example ListID or TxnID

You can get more information about whether a column is allowed during Insert/Update or not by typing the below command in QODBC Test Tool:

sp_columns TableName

For Example, sp_columns InvoiceLine

The command will return the schema rules of the selected table (In this example, it is InvoiceLine), including information about whether a column is updatable or insertable.

When you try to insert the non-insertable field in your query, QODBC will show the error "[QODBC]Field not allowed in insert. "

So when you get the "Field not allowed in insert" error, please check your insert statement. It may contain one or more non-insertable fields. Please remove non-insertable fields from the query and try to execute the SQL statement again.

When you try to update the non-updateable field in your query, QODBC will show the error "[QODBC]Field not allowed an update. " So when you get the "Field not allowed in update" error, please check your update statement. It may contain one or more non-updateable fields. Please remove non-updateable fields from the query and try to execute the SQL statement again.

Tags: Table Field Types, Field Types, What does field type mean