Skip to main content
Solved

Foreign characters in sales order data

  • February 14, 2025
  • 1 reply
  • 26 views

Forum|alt.badge.img

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?

Best answer by smuddurthi81

@johnw51 

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.

View original
Did this topic help you find an answer to your question?

1 reply

Forum|alt.badge.img
  • Jr Varsity I
  • 37 replies
  • Answer
  • February 17, 2025

@johnw51 

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings