Question

Is there a way to have postal code not be validated when uploading customer information since i keep getting errors for my foreign customers list?

  • 9 March 2023
  • 5 replies
  • 150 views
G
Rank
Userlevel 2

I’m trying to upload my customer information list and I keep getting an error in my import by scenario. I just want a way where Acumatica doesn’t pay attention to the way the postal code is written and have it upload the format that I have it as.

This is just one example but I have many other countries as well

5 replies

Laura02
Rank
Badge +18

Hello,

Postal code validation comes from States & countries screen:

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Z
Rank
Userlevel 1

Hi,

 

After testing, I can confirm that - If you remove postal code input mask and validation regexp, you should be able to put any postal code with no problem.

 

manikantad18
Rank
Userlevel 7
Badge +12

hI @garcimig09 

I hope the below article will provide you some insight https://www.augforums.com/acumatica-input-validation-and-regular-expressions/

Acumatica Functional Consultant
G
Rank
Userlevel 2

@zhaot I tried removing the postal code input mask and validation regexp but I either get an error saying my postal code is invalid or my country code defaults to United States.

 

Here’s the Mapping of the file as well:

 

Chris Hackett
Rank
Userlevel 7
Badge

Hi @garcimig09 were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved