Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Can i connect one dynamics sales database to multiple business central databases

(0) ShareShare
ReportReport
Posted on by 60

Hello,

Is it possible to connect one dynamics sales database to multiple business central databases. If yes, what to be considered in the process and before that?

  • DamjanZ_SP Profile Picture
    55 on at
    Can i connect one dynamics sales database to multiple business central databases
    Hi,
     
    I am about to start a project of implementing 366 Sales where customer has multiple BC databases, some of them OnPrem and others in SaaS Cloud.
     
    I have to map customer data to accounts, where customer in BC database 1 is inserted with customer no.=1, while same customer (content wise) is inserted with customer no.=2 on BC database 2. I was thinking of mapping both customers into table account in 365 Sales as number=00001 and then all related documents and records will be mapped to that account number.
     
    Can you please confirm that such mapping would work?
     
    Thank you
    BR Damjan 
     
  • Suggested answer
    Greg Enns Profile Picture
    1,102 on at
    RE: Can i connect one dynamics sales database to multiple business central databases

    The only issue I can see here is the ModifiedBy Filter that is used when searching for modified records in CRM which will then be synced to BC.

    But that is only an issue in BiDirectional mappings and can be overcome simply by having a single field mapping that is unidirectional--FromIntegrationTable.

    Here is the base code that determines if "ModifiedBy" should be a filter:

    codeunit 5340 "CRM Integration Table Synch."
    ...
        local procedure IsModifiedByFilterNeeded(IntegrationTableMapping: Record "Integration Table Mapping"): Boolean
        begin
            if IntegrationTableMapping."Delete After Synchronization" then
                exit(false);
            if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::Bidirectional then
                exit(not HasUnidirectionalFieldMappingFromIntegrationTable(IntegrationTableMapping));
            exit(true);
        end;

    Am I missing something else NorthW ?

  • Suggested answer
    Inge M. Bruvik Profile Picture
    999 Moderator on at
    RE: Can i connect one dynamics sales database to multiple business central databases

    That is not possible with the out of the box integration between sales & Business Central.

Under review

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

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

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

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,110 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,886 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans