We have occasional orders coming in from our eCommerce platform with addresses using foreign characters and erroring in Acumatica. Is there a way to allow additional alphabet characters to be added to the allowed characters in Acumatica?
Foreign characters in sales order data
Best answer by smuddurthi81
Yes, Acumatica has character validation rules that may restrict certain foreign characters in address fields. Here’s how you can address this issue:
1. Check and Modify the Input Validation Rules:
Acumatica enforces input validation on certain fields. You may need to adjust the field settings in the Customization Project Editor to allow foreign characters.
Navigate to Customization > Customization Projects, open your project, and locate the address fields under the Data Access Classes (DACs).
Modify the field's data type or input validation rules to allow extended character sets.
2. Check System Locale and Encoding:
Ensure that Acumatica is configured to support UTF-8 encoding, which includes a wide range of foreign characters.
Verify that your eCommerce integration does not modify or restrict character sets before sending data to Acumatica.
3. Modify the eCommerce Integration Mapping:
If the issue is occurring with specific integrations (e.g., Shopify, Magento, or custom API integrations), check how the address data is mapped.
You may need to adjust the API mappings or data transformation rules to properly handle and pass foreign characters.
4. Use a Custom Business Event or Automation Rule:
If certain characters are causing errors, consider using a Business Event or Automation Rule to replace or sanitize invalid characters before they reach Acumatica.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.