Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Updating custom fields in an existing invoice fails |
Author |
Message |
|
Posted : 2008-11-06 08:07:29 |
I'm trying to update a custom field for an existing invoice. For a multi-line invoice, changing the custom field value with:
myRecordset.Fields("MyCustomFieldName").Value = "New Value"
fails with:
Exception: Multiple-step operation generated errors. Check each status value.
Checking the SDK output shows these errors:
20081105.145029 I 3680 QBSDKMsgSetHandler MODIFY: Invoice 20081105.145029 E 3680 InvoiceStorage::BuildInvoiceLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527 20081105.145029 E 3680 InvoiceStorage::BuildInvoiceLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527 20081105.145029 E 3680 InvoiceStorage::BuildInvoiceLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527 20081105.145029 E 3680 InvoiceStorage::BuildInvoiceLine This feature is not enabled or not available in this version of QuickBooks. HRESULT=0x80040527
I've tried updating Invoice and also updating the individual invoiceLines, but the failure is the same.
I'm running QB Pro 2008 v.18.0.4005.0 and QODBC v8.00.00.242 |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-11-06 09:21:13 |
Normally you would use UPDATE statements like these:
UPDATE InvoiceLIne SET CustomFieldInvoiceLIneColor = 'Blue Item Line' where TxnId='2B55-1071523067' and InvoiceLineTxnLineID = '2B57-1071523067'
or
UPDATE Invoice SET CustomFieldColor = 'Red Invoice' where TxnId='2B55-1071523067'
The first UPDATE sets the Color for the ONE InvoiceLine only while the second updates the color for the Invoice. |
|
|
|
|