Troubleshooting - [QODBC] Error 3000 - The given object ID "in the field "list id" is invalid

Problem Description:

I get a generic error when using QODBC to create an invoice.

I am using the below query:

INSERT INTO InvoiceLine ("TemplateRefListID," "InvoiceLineItemRefListID," "InvoiceLineDesc," "InvoiceLineAmount," "InvoiceLineQuantity," "InvoiceLineSalesTaxCodeRefListID," "FQSaveToCache") VALUES ('80000011-1203804797', '80002C72-1345040417', 'My item 1',19.95, 1, '', 1)

INSERT INTO InvoiceLine ("TemplateRefListID," "InvoiceLineItemRefListID," "InvoiceLineDesc," "InvoiceLineAmount," "InvoiceLineQuantity," "InvoiceLineSalesTaxCodeRefListID," "FQSaveToCache") VALUES ('80000011-1203804797', '80003194-1404606055', 'My item 2',22.50, 1, '', 1)

INSERT INTO Invoice ("TemplateRefListID," "CustomerRefListID," "CustomerRefFullName," "BillAddressAddr1", "BillAddressAddr2", "BillAddressCity," "BillAddressState," "BillAddressPostalCode," "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressCity," "ShipAddressState," "ShipAddressPostalCode," "SalesRepRefFullName," "ShipMethodRefListID") VALUES ('80000011-1203804797', '80000440-1448981709', 'FAKEEBAY,' 'Someone,' 'Address 1 ', 'The city,' 'State,' 'Zip,' 'Someone,' 'Address 1', 'City,' 'State,' 'Zip,' 'Rep,' '80000004-1202486852')

The error is:

[QODBC] Error: 3000 - The given object ID "in the field "list id" is invalid.

Solution:

You are trying to insert a blank value for the field "InvoiceLineSalesTaxCodeRefListID."

To resolve this issue, insert a valid value for the InvoiceLineSalesTaxCodeRefListID field or remove the InvoiceLineSalesTaxCodeRefListID field from your insert statement.

Remove the LISTED field from the query. Example:
INSERT INTO InvoiceLine ("TemplateRefListID," "InvoiceLineItemRefListID," "InvoiceLineDesc," "InvoiceLineAmount," "InvoiceLineQuantity," "FQSaveToCache") VALUES ('80000011-1203804797', '80002C72-1345040417', 'My item 1',19.95, 1, 1)


Specify a value for LISTED field Example:
INSERT INTO InvoiceLine ("TemplateRefListID," "InvoiceLineItemRefListID," "InvoiceLineDesc," "InvoiceLineAmount," "InvoiceLineQuantity," "InvoiceLineSalesTaxCodeRefListID," "FQSaveToCache") VALUES ('80000011-1203804797', '80002C72-1345040417', 'My item 1',19.95, 1, '90000011-1234567800', 1)


So please insert a valid value in the InvoiceLineSalesTaxCodeRefListID field or remove the InvoiceLineSalesTaxCodeRefListID field from your insert query.