In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions "error Converting data type varchar to numeric" on GI that is filtering on UDF TRUE checkbox value
After we upgraded from 2019 R2--->2021 R1 we have this error: “Error converting data type varchar to numeric.” pop up every time we try to load a GI that is supposed to display sales orders that have a UDF checkbox checked and we have a filter setup on that GI looking for that true UDF checkbox. Anyone have any ideas?
Attached is a screenshot of the error and trace. This happens on all of the GIs that have filters setup looking for UDF true checkboxes.