By using this website, you agree to our Terms of Use (click here)
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 from 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.
oof..
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:
https://community.acumatica.com/maintenance-and-troubleshooting-15/after-an-upgrade-to-acumatica-erp-2020-r2-generic-inquiries-dashboards-and-widgets-using-ownerid-and-userid-won-t-open-due-to-the-error-437
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...
