"error Converting data type varchar to numeric" on GI that is filtering on UDF TRUE checkbox value

Hi @gd41 

Please provide the XML file for your GI to check further. 

Regards,

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: 

FilterName="BLNKT"

FilterName="Confirm(RTS)"

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, 

Georgy

Hi @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. 

Hi @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. 

Hi @gd41 ,

Oh okay. What are the type of these fields? (all fields are checkboxes at Attributes screen?)

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!