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 ?
