{"id":10365,"date":"2024-03-06T17:37:40","date_gmt":"2024-03-06T15:37:40","guid":{"rendered":"https:\/\/www.geopostcodes.com\/en-GB\/?p=10365"},"modified":"2026-04-01T07:01:01","modified_gmt":"2026-04-01T07:01:01","slug":"microsoft-dynamics-business-central-address-validation-tutorial","status":"publish","type":"post","link":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/","title":{"rendered":"Microsoft Dynamics Business Central: Address Validation Tutorial"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Key Takeaways<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">Address validation<\/a> in Dynamics 365 Business Central ensures data accuracy and delivery.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GeoPostcodes integration prevents errors and improves delivery accuracy.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Implementation requires table ID setup and data import via Excel.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Validation enhances data quality and customer interactions.<\/li>\n<\/ul>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">Address validation<\/a> ensures accurate and standardized postal data, which is critical for efficient delivery and customer satisfaction. It becomes even more important when <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/international-address-validation\/\" target=\"_blank\" rel=\"noreferrer noopener\">operating globally<\/a> due to varying <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/international-zip-code-format\/\" target=\"_blank\" rel=\"noreferrer noopener\">Postcodes<\/a> and <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/international-address-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">address formats<\/a>.<\/p>\n\n\n\n<p>When combined with <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/the-quickest-way-to-build-an-address-autocomplete-api\/\" target=\"_blank\" rel=\"noreferrer noopener\">address autocomplete<\/a>, it further boosts data accuracy. Many businesses incorporate <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">address validation<\/a> into their <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/erp-tms\/\">ERP<\/a> and CRM systems as part of their <u><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/defining-your-master-data-management-strategy\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">master data management (MDM) strategy<\/span><\/a><\/u>.<\/p>\n\n\n\n<p>This guide shows you how to implement <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">address validation<\/a> in Microsoft Dynamics 365 Business Central using <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/postal-zip-code-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">GeoPostcodes&#8217; Postcode database<\/a>. Working with D365 Finance &amp; Operations instead? We&#8217;ve built a <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/global-address-validation-in-dynamics-365\/\">native integration<\/a> with a complete <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-setup-module-in-dynamics-365\/\">setup guide<\/a> to get you started.<\/p>\n\n\n\n<p class=\"has-background\" style=\"background-color:#d7efff\">\ud83d\udca1 Access the world&#8217;s most comprehensive <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/postal-zip-code-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">Postcode database<\/a>, trusted by enterprises for 15+ years. Start transforming your address management with our free trial \u2013 <strong><a href=\"https:\/\/public.geopostcodes.com\/portal-signup\" target=\"_blank\" rel=\"noreferrer noopener\">browse our data today<\/a>.<\/strong><\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Steps of The Tutorial<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up prerequisites: Microsoft Dynamics 365 Business Central (BC) and GeoPostcodes accounts<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use MS Dynamics BC to locate the Postcodes table ID<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set up a configuration package using the table ID<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Export existing Postcodes and replace them with GeoPostcodes data<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Upload and apply the updated data in MS Dynamics BC<\/li>\n<\/ul>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Scenario: How Can We Ensure Complete Addresses to Avoid Delivery Errors?<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>The international courier company you work for has been plagued with unnecessary costs for as long as you can remember because of incorrect delivery addresses.<\/p>\n\n\n\n<p>Between clients and administrative staff, typos and incomplete addresses abound. It\u2019s not uncommon for drivers to arrive at the completely wrong side of town\u2014or even in the wrong city or state.<\/p>\n\n\n\n<p>Management has decided it\u2019s enough. They\u2019re implementing a policy that clients&#8217; addresses in your ERP, Microsoft Dynamics 365 Business Central (MS Dynamics BC), may never be typed in manually, but the address database must always be used.<\/p>\n\n\n\n<p>Unfortunately, they soon discover that the prepopulated address data in MS Dynamics BC is incomplete.<\/p>\n\n\n\n<p>For instance, your company regularly ships between Mexico and the United States. Consider the example of shipping from Cavalia, Mexico, to Jamestown, Illinois, in the United States. MS Dynamics only has a few locations for Mexico, and they don\u2019t include Cavalia:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"568\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes-1024x568.webp\" alt=\"Microsoft Dynamics Mexico zip codes\" class=\"wp-image-10390\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes-1024x568.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes-300x166.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes-768x426.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes-1536x852.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-mexico-zip-codes.webp 1755w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>MS Dynamics\u2019 list of locations for the United States is longer, but it doesn\u2019t include Jamestown, Illinois:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes-1024x575.webp\" alt=\"Microsoft Dynamics US zip codes\" class=\"wp-image-10389\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes-1024x575.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes-300x168.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes-768x431.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes-1536x862.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-us-zip-codes.webp 1760w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Even if you shipped to a well-known location like New York, MS Dynamics BC only provides six possible Postcodes while the actual range extends from 00501 to 14925.<\/p>\n\n\n\n<p>Thankfully, you can use GeoPostcodes\u2019 <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/postal-zip-code-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">postal code database<\/a> to solve the problems you\u2019re facing in finding accurate address data in Microsoft Dynamics Business Central.<\/p>\n\n\n\n<p>The rest of this article will show you how to do it.<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Prerequisites for Dynamics 365 Business Central Address Validation<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To follow along with this tutorial, you need a Microsoft Dynamics 365 Business Central account and a GeoPostcodes account.<\/p>\n\n\n\n<p>Both offer free trials that you can use to follow along, but remember that GeoPostcodes\u2019 free trial provides a limited data set.<\/p>\n\n\n\n<p>If you don\u2019t have an MS Dynamics account, navigate to the <a href=\"https:\/\/dynamics.microsoft.com\/en-us\/business-central\/overview\/\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Dynamics 365 Business Central website<\/a> and click <strong>Try for free<\/strong>. Sign up for an account by providing the required details as prompted.<\/p>\n\n\n\n<p>Once your account is created, click <strong>Get Started<\/strong> and log in to your account.<\/p>\n\n\n\n<p>If you already have an account, you can sign in from the <a href=\"https:\/\/dynamics.microsoft.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">MS Dynamics 365 website<\/a> to see your dashboard:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"518\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-1024x518.webp\" alt=\"Microsoft Dynamics Business Central dashboard\" class=\"wp-image-10368\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-1024x518.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-300x152.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-768x389.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-1536x777.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-business-central-dashboard-2048x1036.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To sign up for a free trial of GeoPostcodes, navigate to the <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/\" target=\"_blank\" rel=\"noreferrer noopener\">GeoPostcodes website<\/a> and click <strong>Start for free<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-1024x396.webp\" alt=\"GeoPostcodes free trial\" class=\"wp-image-10388\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-1024x396.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-300x116.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-768x297.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-1536x594.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-free-trial-2048x792.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Enter your name and email, and click Get Started. Take note that you need to use a business email address.<\/p>\n\n\n\n<p>Verify your account via an email, after which you\u2019ll be redirected to create a password.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-1024x442.png\" alt=\"GeoPostcodes set password\" class=\"wp-image-10532\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-1024x442.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-300x129.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-768x331.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-1536x663.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/GeoPostcodes-set-password-1-2048x884.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click <strong>Confirm password<\/strong> to log in to your account and see your GeoPostcodes dashboard:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"367\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-1024x367.webp\" alt=\"GeoPostcodes dashboard\" class=\"wp-image-10382\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-1024x367.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-300x107.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-768x275.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-1536x550.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-dashboard-2048x734.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:90px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Download GeoPostcodes Postal Data<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>For illustrative purposes, you\u2019ll stick to the example of delivering a package from Mexico to the US, so you\u2019ll only work with the data for those countries during this tutorial.<\/p>\n\n\n\n<p>On your GeoPostCodes <a href=\"https:\/\/portal.geopostcodes.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">dashboard<\/a>, navigate to <strong>Download Center<\/strong> and select <strong>postal database<\/strong>.<\/p>\n\n\n\n<p>The postal database provides a comprehensive list of postal codes, essential for accurately sorting and delivering mail and packages to the correct geographical areas.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"346\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-1024x346.webp\" alt=\"GeoPostCodes postal database\" class=\"wp-image-10383\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-1024x346.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-300x101.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-768x260.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-1536x519.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/geopostcodes-postal-database-2048x693.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Look for the <strong>United States<\/strong> in the list of countries.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"333\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-1024x333.webp\" alt=\"United States data set\" class=\"wp-image-10384\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-1024x333.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-300x98.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-768x250.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-1536x499.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/united-states-data-set-2048x666.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Open <strong>United States<\/strong> and click <strong>Download<\/strong> to download the file with US postal data to your local machine.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"458\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-1024x458.webp\" alt=\"Download US data set\" class=\"wp-image-10385\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-1024x458.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-300x134.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-768x343.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-1536x687.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/download-us-data-set-1-2048x916.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>When you unzip the folder, you\u2019ll see various subfolders that contain the same geographical postal data in different formats, such as ASC, DAT, JSON, KML, GML, XLSX, and CSV. You\u2019ll use the CSV file later in this guide.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"321\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/data-set-folder-structure-1024x321.webp\" alt=\"Data set folder structure\" class=\"wp-image-10386\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/data-set-folder-structure-1024x321.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/data-set-folder-structure-300x94.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/data-set-folder-structure-768x241.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/data-set-folder-structure.webp 1460w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Follow the same steps above to download the database for Mexico.<\/p>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Import Data to Microsoft Dynamics Business Central<\/h2>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Now that you have the data sets, you need to import them to your Microsoft Dynamics Business Central account.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Find the Table ID for Postcodes<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>First, you need to find the table ID in MS Dynamics that defines Postcodes so that you can add the data from GeoPostcodes to it.<\/p>\n\n\n\n<p>In your Microsoft Dynamics BC dashboard, click the <strong>?<\/strong> icon on the top navigation bar and then <strong>Help &amp; Support<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"562\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-1024x562.png\" alt=\"Microsoft Dynamics help and support\" class=\"wp-image-10531\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-1024x562.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-300x165.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-768x422.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-1536x843.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-help-and-support-2048x1125.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click <strong>Inspect pages and data<\/strong> on the left side of the page.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-1024x539.webp\" alt=\"Microsoft Dynamics inspect pages and data\" class=\"wp-image-10370\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-1024x539.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-300x158.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-768x405.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-1536x809.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-inspect-pages-and-data-2048x1079.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><strong>Page Inspection<\/strong> will open on the right of your screen. You will use it to determine the table ID.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"561\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-1024x561.png\" alt=\"Microsoft Dynamics page inspection\" class=\"wp-image-10525\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-1024x561.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-300x164.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-768x421.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-1536x841.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Microsoft-Dynamics-page-inspection-2048x1122.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Use the Microsoft Dynamics BC search bar to look for <strong>Postcodes<\/strong>, then click on the result to open it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"321\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-1024x321.webp\" alt=\"Microsoft Dynamics search zip codes\" class=\"wp-image-10372\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-1024x321.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-300x94.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-768x240.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-1536x481.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-search-zip-codes-2048x641.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>When the <strong>Postcodes<\/strong> table opens, its table ID will appear in <strong>Page Inspection<\/strong>. In this case, it\u2019s <strong>225<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-1024x269.webp\" alt=\"MS Dynamics inspect pages and data\" class=\"wp-image-10373\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-1024x269.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-300x79.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-768x202.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-1536x403.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-inspect-pages-and-data-1-2048x537.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Create a Configuration Package<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To upload Postcodes into Microsoft Dynamics Business Central, you must establish a configuration package to upload data into a designated table ID.<\/p>\n\n\n\n<p>Use the Microsoft Dynamics BC search bar to look for <strong>Configuration Packages<\/strong>. Click to open it, then click <strong>New<\/strong> to create a new package.<\/p>\n\n\n\n<p>Use <strong>GeoPostcodes<\/strong> for the <strong>Code<\/strong> and <strong>Package Name<\/strong> fields, and add the table ID, which is <strong>225<\/strong> in this case.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"560\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-1024x560.webp\" alt=\"Microsoft Dynamics configuration package\" class=\"wp-image-10374\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-1024x560.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-300x164.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-768x420.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-1536x840.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-configuration-package-2048x1120.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Populate the Template with GeoPostcodes Data<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Next, navigate to the <strong>Excel<\/strong> tab and click <strong>Export to Excel<\/strong> to export the existing Postcodes by downloading them as an Excel file to your machine.<\/p>\n\n\n\n<p>After downloading the file, open it and remove all the current data, leaving only the header intact. The header will serve as the template to adapt the new postal data you obtained from GeoPostcodes into the Microsoft Dynamics BC format.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"512\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-excel-for-zip-codes.webp\" alt=\"MS Dynamics Excel for zip codes\" class=\"wp-image-10375\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-excel-for-zip-codes.webp 789w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-excel-for-zip-codes-300x195.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-excel-for-zip-codes-768x498.webp 768w\" sizes=\"(max-width: 789px) 100vw, 789px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>To add the GeoPostcodes data to the Microsoft Dynamics BC file, navigate to the folders you downloaded from GeoPostcodes earlier. In the CSV folder, open the following files: <strong>GPC-PLACES-GEO-SAMPLE.MX.csv<\/strong> and <strong>GPC-PLACES-GEO-SAMPLE.US.csv<\/strong>.<\/p>\n\n\n\n<p>Use the data in these files to repopulate the Microsoft Dynamics BC Excel file:<\/p>\n\n\n\n<p>| MS Dynamics | GeoPostcodes | Notes |<\/p>\n\n\n\n<p>| \u2014 | \u2014 | \u2014 |<\/p>\n\n\n\n<p>| <span class=\"highlight\">Code <\/span>| <span class=\"highlight\">postcode <\/span>| |<\/p>\n\n\n\n<p>| <span class=\"highlight\">City <\/span>| <span class=\"highlight\">locality <\/span>| |<\/p>\n\n\n\n<p>| <span class=\"highlight\">Search City<\/span> | <span class=\"highlight\">locality <\/span>| Same as <span class=\"highlight\">City <\/span>|<\/p>\n\n\n\n<p>| <span class=\"highlight\">Country\/Region<\/span> | <span class=\"highlight\">MX <\/span>or <span class=\"highlight\">US<\/span> | Add manually |<\/p>\n\n\n\n<p>| <span class=\"highlight\">State<\/span> | <span class=\"highlight\">region1<\/span>| |<\/p>\n\n\n\n<p>Your file should look <a href=\"https:\/\/github.com\/See4Devs\/sample-file-ms-dynamics-zipcodes\/blob\/main\/Default04_12_2023_12_30_41.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">similar to this one<\/a> when you\u2019re done.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Import the Updated File and Apply the Package<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Navigate back to Microsoft Dynamics BC. In the <strong>Excel<\/strong> tab that is still open, click <strong>Import from Excel<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"255\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-1024x255.webp\" alt=\"MS Dynamics import from Excel\" class=\"wp-image-10376\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-1024x255.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-300x75.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-768x191.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-1536x382.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-import-from-excel-2048x510.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>In the dialog that opens, upload your file and click <strong>Import<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"528\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-1024x528.png\" alt=\"MS Dynamics import zip codes\" class=\"wp-image-10526\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-1024x528.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-300x155.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-768x396.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-1536x792.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/MS-Dynamics-import-zip-codes-2048x1056.png 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Finally, to apply this package, click on <strong>Validate Package<\/strong> and then <strong>Apply Package<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"561\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-1024x561.webp\" alt=\"MS Dynamics new zip codes\" class=\"wp-image-10378\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-1024x561.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-300x164.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-768x421.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-1536x842.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/ms-dynamics-new-zip-codes-2048x1122.webp 2048w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:80px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Test Uploaded Data<\/h3>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Microsoft Dynamics BC will now use the postal data you uploaded when you create customer addresses.<\/p>\n\n\n\n<p>For instance, if you create a new customer card and select <strong>Mexico<\/strong> in <strong>Country\/Region Code<\/strong>, <strong>Cavalia<\/strong> will now appear in the city lists.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"268\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City-1024x268.png\" alt=\"Excel Mexico Cavalia City\" class=\"wp-image-10528\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City-1024x268.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City-300x79.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City-768x201.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City-1536x402.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Mexico-Cavalia-City.png 1936w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:60px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>If you follow the same steps for the United States, you also have postal code data for Jamestown, Illinois:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city-1024x574.webp\" alt=\"Excel Jamestown City\" class=\"wp-image-10380\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city-1024x574.webp 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city-300x168.webp 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city-768x431.webp 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city-1536x862.webp 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/excel-jamestown-city.webp 1754w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>When you add the city, other fields, such as <strong>State<\/strong> and <strong>Postcode<\/strong>, also autopopulate in the client card based on your uploaded data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"380\" src=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois-1024x380.png\" alt=\"Excel Jamestown, Illinois\" class=\"wp-image-10529\" srcset=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois-1024x380.png 1024w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois-300x111.png 300w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois-768x285.png 768w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois-1536x569.png 1536w, https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/Excel-Jamestown-Illinois.png 1654w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:90px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Using accurate postal code data in your ERP <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/international-address-validation\/\" target=\"_blank\" rel=\"noreferrer noopener\">prevents manual errors<\/a> and improves efficiencies, especially if you work internationally. It enhances customer satisfaction by ensuring timely and accurate deliveries and reducing return shipments. Integrating correct Postcodes enhances overall data quality, enabling better analytics, segmentation, and targeted marketing efforts within your Dynamics 365 ecosystem.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\" target=\"_blank\" rel=\"noreferrer noopener\">GeoPostcodes<\/a> combines 15 years of experience in Enterprise integration, counting many <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">address validation<\/a> cases for Microsoft Dynamics. Our data covers 247 countries in a standardized address database, including street names, Postcodes, cities, administrative areas, and official address formats. Try our <a href=\"https:\/\/public.geopostcodes.com\/portal-signup\" target=\"_blank\" rel=\"noreferrer noopener\">data for free<\/a> now. You can use GeoPostcodes with Power Apps to ensure your address entry process is efficient. If you need data for visualization purposes, our lightweight <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/boundaries-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">boundary files<\/a> are ready to support your business case.<\/p>\n\n\n\n<p>This article showed you how to integrate GeoPostcodes\u2019 postal code data with Microsoft Dynamics 365 Business Central to validate addresses.<\/p>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">FAQ<\/h2>\n\n\n\n<div id=\"wp-block-themeisle-blocks-accordion-aa5641a4\" class=\"wp-block-themeisle-blocks-accordion exclusive is-style-default  has-light-content-bg\">\n<details class=\"wp-block-themeisle-blocks-accordion-item\"><summary class=\"wp-block-themeisle-blocks-accordion-item__title\"><div><strong><strong>What Is Address Validation for Dynamics?<\/strong><br><\/strong><\/div><\/summary><div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">Address validation<\/a> for Dynamics refers to the process of address verification and correction in Microsoft Dynamics. When configured correctly, it\u2019s particularly cost-effective when combined with address prediction, phone validation, and email validation.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/details>\n\n\n\n<details class=\"wp-block-themeisle-blocks-accordion-item\"><summary class=\"wp-block-themeisle-blocks-accordion-item__title\"><div><strong><strong><strong>What Does Address Validation in Microsoft Dynamics 365 Business Central Do?<\/strong><\/strong><\/strong><\/div><\/summary><div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p><a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">Address validation<\/a> in Microsoft Dynamics 365 Business Central ensures that the addresses you enter into the system are accurate and standardized to have complete address data. It checks whether the address is written correctly, has all the necessary details, and matches a trusted address list. This helps maintain accurate contact data, ensures reliable customer interactions, and improves user experience.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/details>\n\n\n\n<details class=\"wp-block-themeisle-blocks-accordion-item\"><summary class=\"wp-block-themeisle-blocks-accordion-item__title\"><div><strong><strong><strong>What Is the Address Validation Process?<\/strong><\/strong><\/strong><\/div><\/summary><div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>The <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">address validation<\/a> process involves checking the accuracy and format of postal addresses against a recognized database or address standard. Software like Microsoft Dynamics 365 allows you to automate this process by, for example, providing lookup functionality of these addresses to ensure they exist.<\/p>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/details>\n\n  \n  <details class=\"wp-block-themeisle-blocks-accordion-item\">\n    <summary class=\"wp-block-themeisle-blocks-accordion-item__title\">\n      <div><strong>How can I implement address validation in Dynamics 365?<\/strong><\/div>\n    <\/summary>\n    <div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n      \n      <div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n\n      \n      <p>GeoPostcodes provides an <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">address validation service<\/a> that can be integrated with Dynamics 365.<\/p>\n      \n\n      \n      <p>Our database includes comprehensive <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/address-validation-service\/\">postal address validation<\/a> capabilities.<\/p>\n      \n\n      \n      <div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n    <\/div>\n  <\/details>\n  \n\n  \n  <details class=\"wp-block-themeisle-blocks-accordion-item\">\n    <summary class=\"wp-block-themeisle-blocks-accordion-item__title\">\n      <div><strong>Can I validate international addresses in Dynamics 365?<\/strong><\/div>\n    <\/summary>\n    <div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n      \n      <div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n\n      \n      <p>Yes, GeoPostcodes&#8217; <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/international-address-verification\/\">international address validation<\/a> solution works seamlessly with Dynamics 365, supporting <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/international-address-verification\/\">foreign address verification<\/a> for global operations.<\/p>\n      \n\n      \n      <div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n    <\/div>\n  <\/details>\n  \n\n  \n  <details class=\"wp-block-themeisle-blocks-accordion-item\">\n    <summary class=\"wp-block-themeisle-blocks-accordion-item__title\">\n      <div><strong>Is bulk address processing available for Dynamics 365?<\/strong><\/div>\n    <\/summary>\n    <div class=\"wp-block-themeisle-blocks-accordion-item__content\">\n      \n      <div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n\n      \n      <p>GeoPostcodes offers <a href=\"https:\/\/www.geopostcodes.com\/en-GB\/bulk-address-validation\/\">bulk address validation<\/a> that can process your entire Dynamics 365 database, ensuring all addresses meet postal standards.<\/p>\n      \n\n      \n      <div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n      \n    <\/div>\n  <\/details>\n  \n<\/div>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Enhance your data accuracy with our Microsoft Dynamics 365 integration: Offering Address Validation capabilities for efficient and error-free input.<\/p>\n","protected":false},"author":29,"featured_media":11550,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[41],"tags":[38],"class_list":["post-10365","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-address-validation","tag-address-validation-page"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Microsoft Dynamics 365 : Address Validation and Auto Complete<\/title>\n<meta name=\"description\" content=\"How to build address validation into Microsoft Dynamics 365 Business Central. Enhance your data accuracy for efficient and error-free input.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft dynamics 365 : Address Validation and Auto Complete\" \/>\n<meta property=\"og:description\" content=\"Enhance your data accuracy with our Microsoft Dynamics 365 integration: Offering Address Validation capabilities for efficient and error-free input.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\" \/>\n<meta property=\"og:site_name\" content=\"GeoPostcodes\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-06T15:37:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-01T07:01:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"327\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Lucien Chemaly\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Microsoft dynamics 365 : Address Validation and Auto Complete\" \/>\n<meta name=\"twitter:description\" content=\"Enhance your data accuracy with our Microsoft Dynamics 365 integration: Offering Address Validation capabilities for efficient and error-free input.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Lucien Chemaly\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\"},\"author\":{\"name\":\"Lucien Chemaly\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/e2f89d767358799582b38db3b2c235e0\"},\"headline\":\"Microsoft Dynamics Business Central: Address Validation Tutorial\",\"datePublished\":\"2024-03-06T15:37:40+00:00\",\"dateModified\":\"2026-04-01T07:01:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\"},\"wordCount\":1691,\"publisher\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\",\"keywords\":[\"Address validation page\"],\"articleSection\":[\"Address Validation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\",\"name\":\"Microsoft Dynamics 365 : Address Validation and Auto Complete\",\"isPartOf\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\",\"datePublished\":\"2024-03-06T15:37:40+00:00\",\"dateModified\":\"2026-04-01T07:01:01+00:00\",\"description\":\"How to build address validation into Microsoft Dynamics 365 Business Central. Enhance your data accuracy for efficient and error-free input.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\",\"contentUrl\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp\",\"width\":800,\"height\":327,\"caption\":\"GeoPostcodes-microsoft-dynamics-365-address-validation-and-autocomplete\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.geopostcodes.be\/en-GB\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Dynamics Business Central: Address Validation Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#website\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/\",\"name\":\"GeoPostcodes\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.geopostcodes.com\/en-GB\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#organization\",\"name\":\"GeoPostcodes\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2021\/04\/cropped-GeoPostcodes-color@2x-png.webp\",\"contentUrl\":\"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2021\/04\/cropped-GeoPostcodes-color@2x-png.webp\",\"width\":1331,\"height\":207,\"caption\":\"GeoPostcodes\"},\"image\":{\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/e2f89d767358799582b38db3b2c235e0\",\"name\":\"Lucien Chemaly\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/cropped-Lucien-Chemaly.png\",\"contentUrl\":\"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/cropped-Lucien-Chemaly.png\",\"caption\":\"Lucien Chemaly\"},\"description\":\"I'm Lucien Chemaly, a Lead Software Engineer. With more than 9 years of experience as a software engineer and technical lead, I have developed expertise in analyzing and modeling various data sources (acoustic, telecom, health, and postal data) and leading data projects. I was in charge of building SCADA platforms, SaaS solutions for the United Nations (WFP), and migrating old structures (monolithic applications) to the latest architecture (eg, microservices, Docker, Kubernetes, CI\/CD). I\u2019m also the co-founder and builder of Dentiflow, a SaaS platform for dentists. I hold a Master's and Engineering Degree in IT and Telecommunications from the University of Rennes, France. During my free time, I teach seasonal courses for engineering students at the Saint Joseph University of Beirut and have been involved in programming training for private companies.\",\"url\":\"https:\/\/www.geopostcodes.com\/en-GB\/blog\/author\/lucien-chemaly\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Dynamics 365 : Address Validation and Auto Complete","description":"How to build address validation into Microsoft Dynamics 365 Business Central. Enhance your data accuracy for efficient and error-free input.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft dynamics 365 : Address Validation and Auto Complete","og_description":"Enhance your data accuracy with our Microsoft Dynamics 365 integration: Offering Address Validation capabilities for efficient and error-free input.","og_url":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/","og_site_name":"GeoPostcodes","article_published_time":"2024-03-06T15:37:40+00:00","article_modified_time":"2026-04-01T07:01:01+00:00","og_image":[{"width":800,"height":327,"url":"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","type":"image\/webp"}],"author":"Lucien Chemaly","twitter_card":"summary_large_image","twitter_title":"Microsoft dynamics 365 : Address Validation and Auto Complete","twitter_description":"Enhance your data accuracy with our Microsoft Dynamics 365 integration: Offering Address Validation capabilities for efficient and error-free input.","twitter_image":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","twitter_misc":{"Written by":"Lucien Chemaly","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#article","isPartOf":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/"},"author":{"name":"Lucien Chemaly","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/e2f89d767358799582b38db3b2c235e0"},"headline":"Microsoft Dynamics Business Central: Address Validation Tutorial","datePublished":"2024-03-06T15:37:40+00:00","dateModified":"2026-04-01T07:01:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/"},"wordCount":1691,"publisher":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/#organization"},"image":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","keywords":["Address validation page"],"articleSection":["Address Validation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/","url":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/","name":"Microsoft Dynamics 365 : Address Validation and Auto Complete","isPartOf":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage"},"image":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage"},"thumbnailUrl":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","datePublished":"2024-03-06T15:37:40+00:00","dateModified":"2026-04-01T07:01:01+00:00","description":"How to build address validation into Microsoft Dynamics 365 Business Central. Enhance your data accuracy for efficient and error-free input.","breadcrumb":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#primaryimage","url":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","contentUrl":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","width":800,"height":327,"caption":"GeoPostcodes-microsoft-dynamics-365-address-validation-and-autocomplete"},{"@type":"BreadcrumbList","@id":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/address-validation-microsoft-dynamics-365\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.geopostcodes.be\/en-GB\/"},{"@type":"ListItem","position":2,"name":"Microsoft Dynamics Business Central: Address Validation Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#website","url":"https:\/\/www.geopostcodes.com\/en-GB\/","name":"GeoPostcodes","description":"","publisher":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.geopostcodes.com\/en-GB\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#organization","name":"GeoPostcodes","url":"https:\/\/www.geopostcodes.com\/en-GB\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/logo\/image\/","url":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2021\/04\/cropped-GeoPostcodes-color@2x-png.webp","contentUrl":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2021\/04\/cropped-GeoPostcodes-color@2x-png.webp","width":1331,"height":207,"caption":"GeoPostcodes"},"image":{"@id":"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/e2f89d767358799582b38db3b2c235e0","name":"Lucien Chemaly","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.geopostcodes.com\/en-GB\/#\/schema\/person\/image\/","url":"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/cropped-Lucien-Chemaly.png","contentUrl":"https:\/\/www.geopostcodes.com\/wp-content\/uploads\/2024\/01\/cropped-Lucien-Chemaly.png","caption":"Lucien Chemaly"},"description":"I'm Lucien Chemaly, a Lead Software Engineer. With more than 9 years of experience as a software engineer and technical lead, I have developed expertise in analyzing and modeling various data sources (acoustic, telecom, health, and postal data) and leading data projects. I was in charge of building SCADA platforms, SaaS solutions for the United Nations (WFP), and migrating old structures (monolithic applications) to the latest architecture (eg, microservices, Docker, Kubernetes, CI\/CD). I\u2019m also the co-founder and builder of Dentiflow, a SaaS platform for dentists. I hold a Master's and Engineering Degree in IT and Telecommunications from the University of Rennes, France. During my free time, I teach seasonal courses for engineering students at the Saint Joseph University of Beirut and have been involved in programming training for private companies.","url":"https:\/\/www.geopostcodes.com\/en-GB\/blog\/author\/lucien-chemaly\/"}]}},"jetpack_featured_media_url":"https:\/\/www.geopostcodes.com\/en-GB\/wp-content\/uploads\/2024\/01\/microsoft-dynamics-365-address-validation-and-autocomplete.webp","_links":{"self":[{"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/posts\/10365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/comments?post=10365"}],"version-history":[{"count":0,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/posts\/10365\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/media\/11550"}],"wp:attachment":[{"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/media?parent=10365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/categories?post=10365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.geopostcodes.com\/en-GB\/wp-json\/wp\/v2\/tags?post=10365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}