Skip to main content
Solved

Import Scenario for Canadian Customer Fails with Postal Code Error

  • Mar 25, 2025 2:42 PM UTC
  • 2 replies
  • 172 views
  • Translate All

Forum|alt.badge.img

Hi Acumatica Community,


With my customer master import scenario, my Canadian customer imports are failing as follows: 

Error: 

Field: Postal Code, Value: K1M 2C9, Error: The entered code doesn't match the required expression.

 

My American customer imports work fine.


On the countries screen, CS204000, I have this input mask and regular expression for the Canadians: 

-------------------------------------------------------
mask: 
>L#L #L#

Regular Expression: 
^[A-Z]\d[A-Z]\s?\d[A-Z]\d$

 

Here is the help entry for Canadian Mask and regex: 

 

Here is the help wiki for Masks, To Configure an Input Mask and a Display Mask for a Field

-------------------------------------------------------

FWIW, https://regex101.com/ tells me I have a match: 
 

 

Best answer by riglesias

Hello ​@PatrickBacon 

This could happen because US country defaults when creating a new customer. 
Please try moving Country mapping line above Postal code, this way, country will change to CA and then postal code should be valid:

 


Hope this helps
 

View original

2 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • Answer
  • Mar 25, 2025 2:48 PM UTC

Hello ​@PatrickBacon 

This could happen because US country defaults when creating a new customer. 
Please try moving Country mapping line above Postal code, this way, country will change to CA and then postal code should be valid:

 


Hope this helps
 

Translate

Forum|alt.badge.img
  • Author
  • Varsity II
  • Mar 25, 2025 2:54 PM UTC

Thank you Rodrigo! That works (and makes sense).

Translate