[ORDR.DocRate], Field cannot be updated ( ODBC -1029 )

[Former Member]

Hi,

I am getting this error message while I am trying to update document expenses.

[ORDR.DocRate], Field cannot be updated ( ODBC -1029 )

Please help

Satish.

[FOA · Accepted solution]

Hi Satish,

When you try to add a document within B1 you will be promted to update the Exchange Rate. The same check is done by the SDK before adding a document.

Check the properti DocRate of the Documents object to set it correctly.

Hope this helps,

Regards,

Felipe

DocRate Property

Description

Returns or sets a double integer that specifies the exchange rate with local currency for the document.

Property type

Read-write property

Syntax (Visual Basic)

Public Property DocRate() As Double

Remarks

Not relevant for documents that use local currency.

If the document does not use local currency, you must specify an exchange rate for this document. To get a recommended exchange rate, use the GetCurrencyRate method.

[Former Member]

I'm getting the same error when trying to update UDFs of an invoice.

It seems that there is something fishy here: when the invoice is not based on another doc then I do not get this error. But when it is then I get the error.

In addition to this it seems that I can't update the UDFs using DIAPI. Someone wrote in SDN that the base documents' UDF values persist in target docs, which is ... hmmm ... interesting.

So, I have to take my knife and go directly to DB using SQL.

Juha