Update problem with financial fields

[joebordes]

I don't see anything wrong with that SQL. At most, it is odd that you added a related field to contacts on the invoice when there was already one there for that. But, unless you have deleted the custom field (cf_832) and the system is still looking for it, that SQL should work.

have you tried executing it directly in MySQL, to see if it gives you some error?