I have an import scenario to create sales orders from a file where I’m trying to replace special characters like 'é' and á with e and a, respectively. I’ve tried using the Replace() function but it is still populating those fields with ‘??’ instead of those replacement characters. Any idea if this is even possible with import scenarios?
Example - this formula:
Results in this:
Where the first name from the file is José and Acumatica doesn’t seem to know what to do with that special character from the data provider.