After we upgraded from 2019 R2--->2021 R1 we have this error: “Error converting data type varchar to numeric.” pop every time we try to load a GI that is supposed to display sales orders that have a UDF checkbox checked. Anyone have any ideas?
Attached is a screenshot of the trace.
Best answer by Naveen BogaView original
Please provide the XML file for your GI to check further.
Thanks in advance for looking at this.
It looks like this error with UDF happens when we’re using the filters on the GI.
On the Midopt Order Status GI the error occurs on the following filter names:
On the Eval and Sample GI it happens on every filter...because they are all looking for TRUE value UDF checkboxes.
XMLs are attached. Thanks again,
@gd41 Unable to import the above provided xml files and receiving an error like below.
Re-exported them….any idea on why there would be an error?
No Luck, still getting the same issue.
I tried importing them into a test environment, imported without any issues.
Not sure if version matters? 2021 R1?
Thanks for looking into it.
@gd41 Sorry, I was tried in 2020 R2 version.
I worked on the above GI and I can able to execute the GI’s properly without any issues.
Have you enabled Manufacturing module in Enable/Disable screen?
The problem is specifically with UDF checkboxes and filtering on true values in the GI. Thats when the error occurs.
Oh okay. What are the type of these fields? (all fields are checkboxes at Attributes screen?)
I can able to replicate this issue and this might the limitation for User Defined fields.
I ran the request profiler and got the below details, hope this helps you to understand the issue with the screenshots.
The reason for the getting this:
Better you can submit a support case with Acumatica.
Yes, I have a ticket open with Acumatica but they have been very slow to respond and help. This is very helpful and have shared this with Acumatica on the open ticket. Thanks again for your help!