[QODBC-Desktop] Troubleshooting: Cannot Update Field Memo in Table Invoice in QBOE
Posted by Rajendra Dewani (QODBC Support) on 25 July 2012 12:46 PM
|
|
Cannot Update Field Memo in Table Invoice in QBOE Troubleshooting: Cannot Update Field Memo in Table Invoice in QBOEDescriptionI am using QuickBooks Online Edition, I was able to create an invoice using QODBC, and now I am trying to update the memo field using the query: UPDATE Invoice SET Memo=? WHERE TxnID=? But QODBC report error: 1030-Not Supported. View the Schema Rules using sp_columns Invoice, found that in QODBC, the memo field is insertable and updatable. Then why can't this field be updated? SolutionInvoiceMod ( invoice modification via SDK ) is not supported in QuickBooks Online Edition and is only available in QuickBooks desktop edition. Reference: https://idnforums.intuit.com/messageview.aspx?catid=17&threadid=17147&enterthread=y
How to get the table schema For the QuickBooks you are connected to. | |
|