How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

(0) Share

Report

Posted on by Paul V

166

Hello Every One:

We are having issues when loaded address from external system (using Data Management), where a few addresses fail.

Is there a way to export all 50 states and foreign addresses in our system?

Thanks

Paul

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 299,576 Super User 2025 Season 2 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Hi Paul,

What is the exact error message you get? What steps did you perform to get the current result?

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Hi Andre.

At this point I'm just looking to export all address combinations (City, State, Zip, Etc) in D365.

Thanks

Paul

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,514 User Group Leader on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Hi Paul,

You can export all details from Global Address book:

Thanks,

Was this reply helpful? Yes No
Humphrey 210 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Add following line to the end of your environment URL to leverage table browser. Replace <> part with your own legal entity codes.

/?mi=SysTableBrowser&TableName=LogisticsPostalAddress&cmp=<YourLegalEntityCodes>&limitednav=true&lng=en-us

Then right click to export all.

Was this reply helpful? Yes No
Paul V 166 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Thanks!

But this will give me all addresses that are assigned to a party (i.e. customer, vendor, etc), but I also need the combination of addresses that are NOT assigned.

Was this reply helpful? Yes No
Suggested answer

Paul V 166 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

I believe the below will work:

?mi=SysTableBrowser&TableName=LogisticsAddressZipCode&cmp=<Legal Entity>&lng=en-us

Was this reply helpful? Yes No
AnithaEswaran 2,032 on at

Like (0)

Report

RE: How Can I Get A File of ALL Postal Addresses in our D365 F&O Environment (US and Non-US)

Hi,

Are you planning to import the postal zip codes with Country/state/county etc.

Was this reply helpful? Yes No