Troubleshooting: Cannot Update Invoice in QuickBooks Online Edition - QBOE

Problem Description:

When trying to update memo field in the table Invoice or InvoiceLine, QODBC reports the error:

[QODBC]Error:1030-Not Support

It is not only in field memo but also in other fields in table Invoice and InvoiceLine.

Solution:

There is no InvoiceMod subject in Intuit SDK, which means that QBOE does not support any modification to Invoice. You may need to update the records in QBOE once it is created.

This limit is not only in the Invoice table. The schema rules in QBOE are different from what it is in Desktop QuickBooks, please refer to this article: The Schema Rules Differences Between Local QuickBooks and QBOE   for more information about the differences.

Also, Refer How to get the table schema For the QuickBooks you are connected to.