Acumatica 2020 R2 OwnerID Field
If you get one of these error messages in Acumatica 2020 R2:
Operand type clash: uniqueidentifier is incompatible with int Conversion failed when converting the nvarchar value '' to data type int
Then it's probably due to a change that was made to the OwnerID field.
OwnerId changed form uniqueidentifier (a really long GUID identified) to an int (a simple integer number).
Checkout page 31 of the Acumatica 2020 R2 Release Notes (click here) for more information, including a list of the tables and columns affected.
Thank you for the heads up
Thank you, Tim. Just faced this problem in a customized SO Invoice form and your post was a big help, pointing to the right direction 🙂
Thanks Tim - found this post a month too late haha
I also just went down a rabbit hole of a forum post by a developer:
Looks like they may be removing Owner description as well. I haven't done enough GI work lately beyond the fixes to get R2 working with my GIs/Dashboards but I experience exactly what this user did (IE: @me not working anymore). Just as an FYI if you are utilizing this column you may want to look at alternatives now and stop using it...