Skip to main content

Notifications

Announcements

No record found.

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

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

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
    DamjanZ_SP 39 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
    Greg Enns 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
    Inge M. Bruvik 32,748 Super User 2024 Season 1 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans