Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Importing Zipcodes into NAV

(0) ShareShare
ReportReport
Posted on by

Hi,

I am newbie to this system. I need to import the zipcodes (USA and CANADA) into the software.

Any assistance would be helpful.

Thanks

*This post is locked for comments

  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    Miguel Llorca Gómez 7,019 User Group Leader on at
    RE: Importing Zipcodes into NAV

    With your version you can also copy and paste from Excel. Export first and update Excel with correct ZIP codes, then paste into NAV.

    Good luck!!

  • charlie111 Profile Picture
    charlie111 5 on at
    RE: Importing Zipcodes into NAV

    If you have any problems with importing the zip codes try this product: zipcodedownload.com/.../Overview

    Saved me a lot of time...

  • Suggested answer
    RE: Importing Zipcodes into NAV

    Hi,

    Thank you for your solutions.

    I finally managed to import the zip codes.

    In the Role Center / Worksheets I added Zip Code table and imported the Zip Code template with all the zip codes and applied to the database and IT WORKED...

    Tested the zip codes in the normal environment and its working fine.

    Thanks for your support.

  • Suggested answer
    RE: Importing Zipcodes into NAV

    In Denmark we can get an Excel sheet with ZIP-codes from Post Danmark (the national mail handler).

    I only needed to modify this Excel sheet so it contained the same columns as NAV and then I was able to copy/paste it into the page directly in RTC: right click left to the zip-code and choose "insert rows" (if my memory is correct - I was doing it in a Danish NAV, so it was probably not called "insert row" but You'll get the idea :-) ).

    This was done i NAV 2013 R2 - quite easy actually.

    Made a how-to for our other customers - so they can do it themselves.

    Table need to be "empty" or at least not containing any rows with same primary key.

  • RE: Importing Zipcodes into NAV

    In 2009 we had to locate a zipcode file, convert it to Excel, and then import it.

    In 2013 I imagine it won't be that 'easy'.

    In either version, it involves a consultant because after 20 years of NAV, Microsoft still hasn't realized that people use Zipcode information for anything...

  • Mohana Yadav Profile Picture
    Mohana Yadav 60,161 Super User 2025 Season 1 on at
    RE: Importing Zipcodes into NAV

    We can create our own configurations and Packages as per our requirements..

  • RE: Importing Zipcodes into NAV

    Hi,

    I am using Dynamics NAV 2013 R2.

    I used Rapidstart for initial configuration but couldn't see anything which can update the Zipcodes.

    Please advise

    Thanks

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 60,161 Super User 2025 Season 1 on at
    RE: Importing Zipcodes into NAV

    Which Version are you using?

    Depending upon the version you can use rapidstart services or dataport/xmlport.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans