EDI Sales Order has incorrect city in AX

(0) Share

Report

Posted on by Community Member

Hello,

We just implemented EDI and noticied that a few of our sales orders have the wrong city. We verified our EDI mapping and the correct city is being sent, also, this is not happening on all orders, just a handful.

When I create the order manually and enter the zip code, AX shows the 2 cities, Fort Mills and Tega Cay. My EDI transaction is for Tega Cay, but AX is setting it to Fort Mills.

In Organization Administration, Addresses, Address Setup. I do not have any of the validation checks enabled for: Zip/postal code, District, or City.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Mea_ 60,286 on at

Like (0)

Report
Copy link

Link copied!

Hi ITFoam,

If same ZipCode has multiple cities AIF can initialize city from it and pick a wrong one. There are multiple conditions that need to be fulfilled to get there, so it's easier to debug and see what happens than try to check it from UI.

Was this reply helpful? Yes No
André Arnaud de Cal... 304,323 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi ITFoam,

What software are you using for EDI? Is the mapping trying to get the city based on the ZIP code or does it read it from the addresses table linked on this order itself?

Was this reply helpful? Yes No
Suggested answer

Sagar Suman 6,729 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi ITFoam ,

What I see as an issue is that you have mapped two cities to one zip code as mentioned by you.

In the address setup where zipcodes are managed they are tagged to a city. Try updating individual zipcodes for both cities and try EDI import again.

Also check the address format of the country and if it has zipcode added as an address application object.

Was this reply helpful? Yes No