QODBC XML Error on Write
QODBC error on writing Invoice records could be a result of creating a custom field in QuickBooks that is named the same as that used internally by QODBC.
Example of the error message:
[insert into "Invoice" ("CustomerRefListID", "CustomerRefFullName", "ARAccountRefListID", "ARAccountRefFullName", "TemplateRefListID", "TemplateRefFullName", "TxnDate", "RefNumber", "BillAddressAddr1", "BillAddressAddr2", "BillAddressAddr3", "BillAddressAddr4", "BillAddressAddr5", "BillAddressCity", "BillAddressState", "BillAddressPostalCode", "BillAddressCountry", "BillAddressNote", "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressAddr3", "ShipAddressAddr4", "ShipAddressAddr5", "ShipAddressCity", "ShipAddressState", "ShipAddressPostalCode", "ShipAddressCountry", "ShipAddressNote", "IsPending", "PONumber", "TermsRefListID", "TermsRefFullName", "DueDate", "ShipDate", "Memo", "IsToBePrinted", "IsToBeEmailed", "CustomFieldOther") values ('1AD0000-1121966609', 'Girkin Development:Minit Mart #89', '70000-1103659046', 'Accounts Receivable', '10000-1103658884', 'Intuit Product Invoice', {d'2013-07-01'}, '2481', 'Minit Mart #89', '1051 Fairview Avenue', '', '', '', 'Bowling Green', 'KY', '42103', '', '', 'Minit Mart #89', '1051 Fairview Avenue', '', '', '', 'Bowling Green', 'KY', '42103', '', '', 0, '', '20000-1103659053', 'Net 30', {d'2013-07-02'}, null, 'Mobile Sale', 1, 0, '')]
**WARNING** **Database Error ([QODBC] Error parsing complete XML return string.) S0000 Query=[insert into "Invoice" ("CustomerRefListID", "CustomerRefFullName", "ARAccountRefListID", "ARAccounAtRefFullName", "TemplateRefListID", "TemplateRefFullName", "TxnDate", "RefNumber", "BillAddressAddr1", "BillAddressAddr2", "BillAddressAddr3", "BillAddressAddr4", "BillAddressAddr5", "BillAddressCity", "BillAddressState", "BillAddressPostalCode", "BillAddressCountry", "BillAddressNote", "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressAddr3", "ShipAddressAddr4", "ShipAddressAddr5", "ShipAddressCity", "ShipAddressState", "ShipAddressPostalCode", "ShipAddressCountry", "ShipAddressNote", "IsPending", "PONumber", "TermsRefListID", "TermsRefFullName", "DueDate", "ShipDate", "Memo", "IsToBePrinted", "IsToBeEmailed", "CustomFieldOther") values ('1AD0000-1121966609', 'Girkin Development:Minit Mart #89', '70000-1103659046', 'Accounts Receivable', '10000-1103658884', 'Intuit Product Invoice', {d'2013-07-01'}, '2481', 'Minit Mart #89', '1051 Fairview Avenue', '', '', '', 'Bowling Green', 'KY', '42103', '', '', 'Minit Mart #89', '1051 Fairview Avenue', '', '', '', 'Bowling Green', 'KY', '42103', '', '', 0, '', '20000-1103659053', 'Net 30', {d'2013-07-02'}, null, 'Mobile Sale', 1, 0, '')]
In this case, the error was caused by creating a custom field "State" for the Quickbooks Customer table. Quickbooks does not trap this sort of error because it does not know the needs of QODBC.
Solution: Rename or delete the duplicately named custom field in QuickBooks.