---
id: post/aardvarklabs-blog/2467
type: post
title: Enhancing Business Central with Address Validation AI
summary: Address validation using Azure OpenAI compares user-entered addresses against existing Business Central address records to identify matches and preserve associated metadata. The solution uses a system prompt to guide AI in matching addresses semantically rather than character-by-character, returning match confidence scores.
tier: community
language: en
tags:
  - address validation
  - ai matching
  - azure openai
  - copilot
  - data quality
  - json integration
system: copilot
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:59:35.159Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 87086bf7b8e655f77d7df6e15f1402e30898b6c39623413f1c274ed563b02647
evidence:
  - kind: blog
    url: https://aardvarklabs.blog/2025/08/29/enhancing-business-central-with-address-validation-ai/
    title: Enhancing Business Central with Address Validation AI
    date: "2025-08-29"
    commit: null
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "2467"
source_id: aardvarklabs-blog
source_name: Aardvark Labs
url: https://aardvarklabs.blog/2025/08/29/enhancing-business-central-with-address-validation-ai/
published_at: "2025-08-29T12:00:00.000Z"
author: Marcel Chabot
full_text: false
words: 1214
quotes: []
code_objects_mentioned: []
systems:
  - copilot
  - integration
  - sales
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://aardvarklabs.blog/2025/08/29/enhancing-business-central-with-address-validation-ai/embed/
  image: https://aardvarklabs.blog/wp-content/uploads/2025/08/15c40588-0b02-46be-8971-4bb6f305ca70.jpeg
  image_alt: null
  image_w: 1024
  image_h: 1024
  site_name: Aardvark Labs
  favicon: https://aardvarklabs.blog/wp-content/uploads/2024/04/design-1.png?w=32
  probed_at: "2026-10-07T11:51:40.363Z"
---

# Enhancing Business Central with Address Validation AI

[Read the post](https://aardvarklabs.blog/2025/08/29/enhancing-business-central-with-address-validation-ai/) · Aardvark Labs (Marcel Chabot) · 2025-08-29 · 1214 words · tier community · reviewed (checked by Opus)

> Address validation using Azure OpenAI compares user-entered addresses against existing Business Central address records to identify matches and preserve associated metadata. The solution uses a system prompt to guide AI in matching addresses semantically rather than character-by-character, returning match confidence scores.

## Key points

- Free-text ship-to addresses lose extra data tied to stored Business Central addresses, such as salesperson or regional details, so matching to an existing address code helps keep it
- The user address and the customer's known addresses are sent as JSON to Azure OpenAI, which returns a match score between 0 and 1 for each address
- The system prompt carries the logic: ignore abbreviation and line-order differences, and treat a state mismatch as strongly non-matching
- In a test, a near-identical address scored 1, while the same street in Atlanta GA versus Atlanta TX scored 0.6, low enough to reject but high enough to flag for review
- The author's earlier rule-based approach using USPS CASS, Levenshtein distance and hard-coded rules only reached about 70% accuracy

## Context

- Features: Address matching with AI, Confidence scoring, System prompt engineering, JSON data formatting, Ship-to address validation, Sales quote integration

Source: Aardvark Labs, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.