Knowledgebase
[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 QBOE

Description

I 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?

Solution

InvoiceMod ( 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


Also, Refer


The Schema Rules Differences Between Local QuickBooks and QBOE

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

(13 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).