Address Data Initialization
The Address Data Initialization enables step-by-step processing of existing address data in Business Central to build the internal address dictionary and track usage.
Business Value
The batch-based initialization provides the following benefits:
- Uninterrupted Processing: Initialization occurs in configurable batches, allowing large data volumes to be processed reliably
- Error Tolerance: Errors in individual batches do not block processing of other source tables
- Progress Transparency: The current processing status is visible at all times and can be seamlessly resumed after interruptions
- Data Integrity: Already validated address data remains unchanged during initialization
Feature Description
The Address Data Initialization reads all relevant address data from the following source tables:
- Contacts
- Customers
- Vendors
- Employees
- Resources
- Sales Documents (Orders, Quotes, Invoices)
- Purchase Documents (Orders, Quotes, Invoices)
- Ship-To Addresses
- Order Addresses
- Alternative Addresses
Processing occurs in configurable batches. After each batch, progress is saved, allowing initialization to resume at the last position after interruptions (e.g., session end, task abort, errors).
Info
The initialization updates the internal address dictionary and usage tracking. No automatic address validations are performed. Address data already marked as "Validated" or "Manually Checked" remains unchanged.
Usage
1. Configure Batch Size
Open the Address Validation Setup and set the desired Initialization Batch Size:
- Default Value: 1,000 records per batch
- Range: 0 to 100,000 records
- Recommendation: For large data volumes (> 100,000 address records), we recommend batch sizes between 500 and 2,000
2. Start Initialization
- Open the Initialize Address Data page via search or from setup
- The page displays the current progress for each source table
- Click Initialize Address Data to start processing
3. Monitor Progress
The page displays the following information for each source table:
| Field | Description |
|---|---|
| Source Table | Name of the table being processed (e.g., "Customer", "Vendor") |
| Status | Current processing status (see below) |
| Processed Records | Number of records processed so far |
| Total Records | Total number of records to process |
| Progress % | Percentage progress |
| Error Message | Error message if any (only for status "Failed") |
4. Pause or Resume Processing
- Pause: Close the page or end the session. Current progress is automatically saved
- Resume: Reopen the page and click Run Next Batch. Processing continues from the last saved position
Important
Initialization does not process records twice. A restart resumes processing from the last saved position.
Status Overview
| Status | Description |
|---|---|
| Pending | The source table is waiting for processing |
| In Progress | The source table is currently being processed |
| Completed | Processing was completed successfully |
| Skipped | The source table was skipped (e.g., no data available) |
| Failed | Processing failed. The error message is displayed in the "Error Message" field |
Info
Errors in individual source tables do not block processing of other tables. You can re-run failed batches after resolving the cause.
Background Information
The initialization also cleans up orphaned records in the "Address Data Usage" and "Address Data Hash" tables that may have been created by earlier versions.