Skip to main content

Microsoft Dynamics 365 Business Central Location TO iPaaS Mapping Documentation

Field-by-field mapping reference for syncing locations from Microsoft Dynamics 365 Business Central to iPaaS.com.

Contents

Summary

Microsoft Dynamics 365 Business Central warehouse and inventory locations can be transferred to iPaaS.com as location records through the integration's polling schedule or through Manual Sync. Each Business Central location is captured as a single iPaaS.com location, with its code recorded as the iPaaS.com location name, its name recorded as the description, and its address and contact details captured into the location's dedicated fields. Transferring locations keeps the warehouse and inventory locations aligned across the subscriber's connected systems.

This family is a single collection — Add/Update Dynamics 365 Business Central Location TO iPaaS.com — with no child collections. It supports a bulk initialization run so that an existing set of Business Central locations can be brought into iPaaS.com in one pass when the integration is first configured. The location records this collection captures are also used as a prerequisite by the product and product-inventory transfers, which transfer a location into iPaaS.com on demand if a product or inventory record references a location that does not yet exist there.

ID Format

Manual Sync ID Format

When transferring a Business Central location from the iPaaS.com Manual Sync page, enter the location identifier. Either of two values can be used:

  • The Business Central location internal ID — the unique ID (a GUID) that identifies the location record within Microsoft Dynamics 365 Business Central.

  • The Business Central location code — the short code that identifies the location, such as a warehouse code.

  • Example (internal ID): f99b2ee7-0195-ef11-8a6d-6045bdc8dfe6

  • Example (location code): MAIN

External ID Format

After a successful transfer, iPaaS.com saves the Business Central location internal ID as the external ID on a dedicated external-ID record. This external ID links every subsequent transfer of the same location to the same iPaaS.com location rather than creating a duplicate. The location's address and contact detail are read separately and merged onto the same record during the transfer, so the captured location reflects the full Business Central location data.

Deleted Record Support

Outbound delete is not supported for the location record. This collection captures and updates Business Central locations into iPaaS.com; it does not remove iPaaS.com records. Delete mappings are not included in the default templates, and deleting a location in Business Central does not remove the corresponding iPaaS.com location. Subscribers who need to retire an iPaaS.com location should manage that on the iPaaS.com side.

Custom Field Support

The address and contact detail for a location is captured into a set of dedicated location fields that ship with this integration's template — Dynamics Location AddressLine1, Dynamics Location AddressLine2, Dynamics Location Contact, Dynamics Location City, Dynamics Location State, Dynamics Location PostalCode, Dynamics Location Country, Dynamics Location PhoneNumber, Dynamics Location Email, and Dynamics Location Website. Each of these fields must exist on the iPaaS.com location for its mapping to store a value; a field that does not exist is left unset. These fields are listed in the field mapping table below.

Beyond these template fields, the integration does not provide a general subscriber-defined custom-field mechanism for the location collection. Subscribers or their MiSP should confirm that the listed location fields exist on the iPaaS.com side before relying on the captured address and contact detail, and can contact iPaaS.com Support for assistance.

Mapping Collection Status

  • Status: Enabled

  • Trigger Events: Location Create, Location Update, Location Poll. This collection uses the location scope set. Transfers happen automatically on the integration's polling schedule — there are no webhooks for this integration, so the integration periodically checks Business Central for new and changed locations — and a Manual Sync can be run at any time. Whether a detected location creates a new iPaaS.com location or updates an existing one depends on the external-ID link (the saved location internal ID) and on name matching, not on the change type — see ID Format and Duplicate or Conflicting Mappings.

No mapping filter is applied to this collection, so every Business Central location it processes is captured.

Duplicate or Conflicting Mappings

No other collection in this integration writes the same Business Central location into iPaaS.com, so there is no conflicting collection to coordinate with.

Collision Handling

This integration does not provide configurable collision-handling methods for the location collection. There is no subscriber-selectable conflict-resolution option (such as Error, Remap and Link, or Update and No Link) on this collection. Locations are instead matched to their iPaaS.com record by the saved external ID and by name — see Duplicate Matching below.

Duplicate Matching

To avoid creating duplicate locations in iPaaS.com, the integration matches an incoming Business Central location to an existing iPaaS.com location before recording a new one. When a location has no saved external ID yet, the integration looks for an existing iPaaS.com location whose name matches the Business Central location code. If a match is found, the integration links the external ID to that existing record so the location is updated rather than duplicated. The name used for matching is the Business Central location code, so keep location codes consistent to ensure the match resolves to the intended record.

This collection does not auto-transfer any related record as a prerequisite of a location transfer; the location is a standalone record. (The location is itself transferred as a prerequisite by the product and product-inventory collections when they reference a location that does not yet exist in iPaaS.com — see those collections' documentation.)

Supported Child Collections

None. This collection captures the location record only; it has no child collections.

System Caveats

Microsoft Dynamics 365 Business Central Caveats

  • Code as identifier: the Business Central location code is the value used to match the location to its iPaaS.com record, so it must be present on the Business Central location.

  • Code as fallback name: the iPaaS.com location name is set from the Business Central location code rather than the location name. If a Business Central location has no name, the code still serves as the iPaaS.com location name, and the description is left unset.

  • State and county source: the iPaaS.com location state field is captured from the Business Central county, state, or province value. Confirm this value carries the intended state or province where downstream systems expect a specific format.

  • Country is a code: the country value is captured from the Business Central country/region code. Where downstream systems expect a full country name rather than a code, confirm the value meets their needs.

iPaaS.com Caveats

  • Name is the routing key for matching: the iPaaS.com location name is set from the Business Central location code, and is the value used to match an incoming location to an existing iPaaS.com location. Locations that resolve to the same name in iPaaS.com are linked to a single location record rather than duplicated.

  • Location fields must exist first: the address and contact detail is stored only when the matching Dynamics Location field exists on the iPaaS.com location; otherwise the value is not stored. See Custom Field Support.

  • Bulk initialization is optional: a bulk initialization run is available to bring an existing set of Business Central locations into iPaaS.com in one pass. This is only relevant to subscribers who integrate locations; for subscribers who do not, running it has no effect.

Setup Requirements

Microsoft Dynamics 365 Business Central Configuration

  • Enable Web Services for Locations so the integration can read location records.

  • Ensure each location to be transferred has a valid location code; the code is required as the matching key and is used as the iPaaS.com location name.

  • Authentication uses OAuth 2.0; ensure credentials are stored securely in the iPaaS.com credential manager.

For the full installation walkthrough, see the Installation Instructions.

iPaaS.com Configuration

  • Ensure the Dynamics Location address and contact fields exist on the iPaaS.com location so the captured address and contact detail is stored. See Custom Field Support.

  • After completing the location mappings, run a bulk initialization if an existing set of Business Central locations should be brought into iPaaS.com at the start.

Subscribers or their MiSP can contact iPaaS.com Support for assistance configuring Business Central Web Services or the iPaaS.com location fields.

Integration Flow

  1. A location is created or updated in Business Central.

  2. The integration detects the location on its polling schedule, or a subscriber triggers a Manual Sync using the location internal ID or the location code.

  3. iPaaS.com authenticates with Business Central using OAuth 2.0 and reads the location — first resolving the location code, then reading the full location record with its address and contact detail.

  4. The integration checks whether the location is already linked to an iPaaS.com location by its external ID. If it is not, the integration looks for an existing iPaaS.com location whose name matches the Business Central location code and links to it when found, so the location is updated rather than duplicated.

  5. The collection records the location: the location name from the code, the description from the name, and the address and contact detail into the dedicated location fields.

  6. The iPaaS.com location is created on the first transfer or updated on subsequent transfers, matched by the saved external ID or by name.

  7. Transfer status and any errors are recorded in the iPaaS.com Dashboard under Integration Monitoring and the Error Logs.

A bulk initialization run follows the same per-location flow for every existing Business Central location in one pass when the integration is first configured.

Mappings

Add/Update Dynamics 365 Business Central Location TO iPaaS.com

iPaaS.com data type: Location

This collection captures the Business Central location as an iPaaS.com location. It has no mapping filter, so every location it processes is captured.

Mapping Type

Source Field (Microsoft Dynamics 365 Business Central)

Destination Field (iPaaS.com)

Description

Field

Code

Name

Required. The iPaaS.com location name, taken from the Business Central location code. The code is the value used to match the location to its iPaaS.com record. If the Business Central location has no name, the code is also used as the iPaaS.com location name. Keep location codes consistent so the match resolves to the intended record.

Field

Name

Description

Recommended. The iPaaS.com location description, taken from the Business Central location name. Left unset when the Business Central location has no name.

Field

Address

Dynamics Location AddressLine1

Recommended. The primary address line from the Business Central location. Stored on the iPaaS.com Dynamics Location AddressLine1 field; the field must exist on the location. Left unset when the source value is absent.

Field

Address2

Dynamics Location AddressLine2

Recommended. The secondary address line from the Business Central location. Stored on the iPaaS.com Dynamics Location AddressLine2 field; the field must exist on the location. Left unset when the source value is absent.

Field

Contact

Dynamics Location Contact

Recommended. The primary contact or company name for the Business Central location. Stored on the iPaaS.com Dynamics Location Contact field; the field must exist on the location. Left unset when the source value is absent.

Field

City

Dynamics Location City

Recommended. The city from the Business Central location. Stored on the iPaaS.com Dynamics Location City field; the field must exist on the location. Left unset when the source value is absent.

Field

County

Dynamics Location State

Recommended. The state, province, or county from the Business Central location. Stored on the iPaaS.com Dynamics Location State field; the field must exist on the location. Left unset when the source value is absent.

Field

PostCode

Dynamics Location PostalCode

Recommended. The postal code from the Business Central location. Stored on the iPaaS.com Dynamics Location PostalCode field; the field must exist on the location. Left unset when the source value is absent.

Field

CountryRegionCode

Dynamics Location Country

Recommended. The country/region code from the Business Central location. Stored on the iPaaS.com Dynamics Location Country field; the field must exist on the location. Where downstream systems expect a full country name rather than a code, confirm the value meets their needs. Left unset when the source value is absent.

Field

PhoneNo

Dynamics Location PhoneNumber

Recommended. The telephone number from the Business Central location. Stored on the iPaaS.com Dynamics Location PhoneNumber field; the field must exist on the location. Left unset when the source value is absent.

Field

Email

Dynamics Location Email

Recommended. The email address from the Business Central location. Stored on the iPaaS.com Dynamics Location Email field; the field must exist on the location. Left unset when the source value is absent.

Field

HomePage

Dynamics Location Website

Recommended. The website or home page address from the Business Central location. Stored on the iPaaS.com Dynamics Location Website field; the field must exist on the location. Left unset when the source value is absent.

Error Handling

For the complete catalog of error messages this integration can produce, see the Error Messages article. The conditions most relevant to the location transfer are:

  • Missing location code: the location code is required as the matching key and is used as the iPaaS.com location name. A location with no code cannot be matched or named. Resolution: ensure each Business Central location carries a valid code before transferring.

  • Unresolved duplicate match: when the integration finds an existing iPaaS.com location by name but cannot link the external ID to it, the transfer stops to avoid creating a duplicate location record. Resolution: subscribers or their MiSP should confirm the iPaaS.com location name and re-transfer; if a genuine duplicate already exists in iPaaS.com, reconcile it on the iPaaS.com side first.

Errors and transfer status for every location transfer are recorded in the iPaaS.com Dashboard under Integration Monitoring and the Error Logs.

Validation Rules

  • Code presence: the Business Central location code must be present; it is the matching key and the source of the iPaaS.com location name.

  • Name matching: an incoming location is matched to an existing iPaaS.com location by name (the location code) when no external-ID link exists yet, so the same location is updated rather than duplicated.

  • Field existence: the address and contact detail is stored only when the matching Dynamics Location field exists on the iPaaS.com location.

Testing and Validation

Test Scenarios

  1. Valid location transfer. Transfer a Business Central location that has a code, a name, and full address and contact detail (by polling or Manual Sync). Confirm the iPaaS.com location is created with the name set from the code, the description set from the name, and all address and contact fields populated.

  2. Code-as-name fallback. Transfer a Business Central location that has a code but no name. Confirm the iPaaS.com location name is set from the code and the description is left unset.

  3. ID format. From the Manual Sync page, transfer a specific location using its internal ID, then repeat using its location code. Confirm both identify the correct location.

  4. Duplicate matching. Ensure an iPaaS.com location already exists whose name matches a Business Central location code, then transfer that Business Central location. Confirm the existing iPaaS.com location is linked and updated rather than a duplicate being created.

  5. Repeat transfer / external ID. Transfer the same location twice. Confirm the second transfer updates the existing iPaaS.com location (matched by the saved external ID) rather than creating a duplicate.

  6. Bulk initialization. With the location mappings in place, run a bulk initialization. Confirm the existing set of Business Central locations is brought into iPaaS.com in one pass.

Validation Checklist

  • Every Business Central location to be transferred carries a valid location code.

  • Web Services are enabled for Locations in Business Central.

  • The Dynamics Location address and contact fields exist on the iPaaS.com location for the address and contact mappings in use.

  • Location names (the location codes) are consistent so duplicate matching resolves to the intended iPaaS.com record.

Additional Notes

  • The iPaaS.com location name is set from the Business Central location code, not the location name; the location name becomes the description. Keep this in mind when reading location records downstream.

  • A bulk initialization run is available for an initial migration of existing Business Central locations; it is only relevant to subscribers who integrate locations.

  • Outbound delete is not supported for the location record; deletions in Business Central do not propagate to iPaaS.com.

Related Documents

External References

Did this answer your question?