Is there a way to “filter” out alphanumeric characters from an INT field? Somehow, our Parent.BAccountID field has aat least four customer numbers, such as AAMISC, C000001, INTMISC, and KCTEST which, when I do a GI linking Parent accounts with Child accounts it continually throws an error message:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/095d437d-de69-4cb0-b908-219a2fe4d476.png)
I’ve tried filtering out the “bad” customer numbers in various ways without any success. For example and I am only using two of the four for now:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2abe8a06-6c95-42f0-9e76-c73782fd74f3.png)
Any help, if it is possible, would be appreciated. I suspect that these were imported into the system because I didn’t think it was possible to do this as a manual entry.