Codeunit 5330 CRM Integration Management
src/Layers/W1/BaseApp/Integration/Dataverse/CRMIntegrationManagement.Codeunit.al4,272 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Dataverse;using Microsoft.CRM.Comment;using Microsoft.CRM.Contact;using Microsoft.CRM.Opportunity;using Microsoft.CRM.Profiling;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Foundation.UOM;using Microsoft.Integration.D365Sales;using Microsoft.Integration.SyncEngine;using Microsoft.Inventory.Item;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Archive;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Pricing;using Microsoft.Utilities;using System;using System.Apps;using System.Environment;using System.Environment.Configuration;using System.Media;using System.Reflection;using System.Telemetry;using System.Threading;using System.Utilities;codeunit 5330 "CRM Integration Management"{ SingleInstance = true; InherentEntitlements = X; InherentPermissions = X; Permissions = tabledata "Sales Invoice Header" = rm, tabledata "CDS Connection Setup" = r, tabledata "CRM Connection Setup" = r; trigger OnRun() begin CheckOrEnableCRMConnection(); end; var CRMProductName: Codeunit "CRM Product Name"; CachedCoupledToCRMFieldNo: Dictionary of [Integer, Integer]; CachedDisableEventDrivenSynchJobReschedule: Dictionary of [Integer, Boolean]; CachedIsCRMIntegrationRecord: Dictionary of [Integer, Boolean]; CachedDoesJobActOnTable: Dictionary of [Text, Boolean]; CRMEntityUrlTemplateTxt: Label '%1/main.aspx?pagetype=entityrecord&etn=%2&id=%3', Locked = true; NewestUIAppIdParameterTxt: Label '&appid=%1', Locked = true; UnableToResolveCRMEntityNameFrmTableIDErr: Label 'The application is not designed to integrate table %1 with %2.', Comment = '%1 = table ID (numeric), %2 = Dataverse service name'; CouplingNotFoundErr: Label 'The record is not coupled to %1.', Comment = '%1 = Dataverse service name'; NoCardPageActionDefinedForTableIdErr: Label 'The open page action is not supported for Table %1.', Comment = '%1 = Table ID'; IntegrationTableMappingNotFoundErr: Label 'No %1 was found for table %2.', Comment = '%1 = Integration Table Mapping caption, %2 = Table caption for the table which is not mapped'; UpdateNowUniDirectionQst: Label 'Send data update to Dataverse.,Get data update from Dataverse.'; UpdateNowBiDirectionQst: Label 'Send data update to Dataverse.,Get data update from Dataverse.,Merge data.'; UpdateOneNowTitleTxt: Label 'Synchronize data for %1?', Comment = '%1 = Table caption and value for the entity we want to synchronize now.'; UpdateMultipleNowTitleTxt: Label 'Synchronize data for the selected records?'; ManageCouplingQst: Label 'The %1 record is not coupled to %2. Do you want to create a coupling?', Comment = '%1=The record caption (type), %2 = Dataverse service name'; SyncNowFailedMsg: Label 'The synchronization failed.'; SyncNowScheduledMsg: Label 'The synchronization has been scheduled.'; SyncNowSkippedMsg: Label 'The synchronization has been skipped.'; SyncMultipleMsg: Label 'The synchronization has been scheduled for %1 of %4 records. %2 records failed. %3 records were skipped.', Comment = '%1,%2,%3,%4 are numbers of records'; SyncSkippedMsg: Label 'The record will be skipped for further synchronization due to a repeatable failure.'; SyncRestoredMsg: Label 'The record has been restored for synchronization.'; SyncMultipleRestoredMsg: Label '%1 records have been restored for synchronization.', Comment = '%1 - an integer, a count of records.'; UncoupleFailedMsg: Label 'The uncoupling failed.'; UncoupleScheduledMsg: Label 'The uncoupling has been scheduled.'; UncoupleSkippedMsg: Label 'The uncoupling has been skipped.'; UncoupleMultipleMsg: Label 'The uncoupling has been scheduled for %1 of %4 records. %2 records failed. %3 records were skipped.', Comment = '%1,%2,%3,%4 are numbers of records'; CouplingFailedMsg: Label 'The coupling failed.'; CouplingScheduledMsg: Label 'The coupling has been scheduled.'; CouplingSkippedMsg: Label 'The coupling has been skipped.'; CouplingMultipleMsg: Label 'The coupling has been scheduled for %1 of %4 records. %2 records failed. %3 records were skipped.', Comment = '%1,%2,%3,%4 are numbers of records'; DetailsTxt: Label 'Details.'; UpdateOneNowToCRMQst: Label 'Send data update to %2 for %1?', Comment = '%1 = Table caption and value for the entity we want to synchronize now., %2 = Dataverse service name'; UpdateOneNowToModifiedCRMQst: Label 'The %3 record coupled to %1 contains newer data than the %2 record. Do you want to overwrite the data in %3?', Comment = '%1 = Table caption and value for the entity we want to synchronize now. %2 - product name, %3 = Dataverse service name'; UpdateOneNowFromCRMQst: Label 'Get data update from %2 for %1?', Comment = '%1 = Table caption and value for the entity we want to synchronize now., %2 = Dataverse service name'; UpdateOneNowFromOldCRMQst: Label 'The %2 record %1 contains newer data than the %3 record. Get data update from %3, overwriting data in %2?', Comment = '%1 = Table caption and value for the entity we want to synchronize now. %2 - product name, %3 = Dataverse service name'; UpdateMultipleNowToCRMQst: Label 'Send data update to %1 for the selected records?', Comment = '%1 = Dataverse service name'; UpdateMultipleNowFromCRMQst: Label 'Get data update from %1 for the selected records?', Comment = '%1 = Dataverse service name'; AccountStatisticsUpdatedMsg: Label 'The customer statistics have been successfully updated in %1.', Comment = '%1 = Dataverse service name'; BothRecordsModifiedBiDirectionalConflictMsg: Label 'Both the %1 record and the %3 %2 record have been changed since the last synchronization, or synchronization has never been performed. Bi-directional synchronization is forbidden as a changed bidirectional field was detected, but you can continue continue with uni-derictional synchronization. If you continue, data on one of the records will be lost and replaced with data from the other record.', Comment = '%1 and %2 area captions of tables such as Customer and CRM Account, %3 = Dataverse service name'; BothRecordsModifiedBiDirectionalNoConflictMsg: Label 'Both the %1 record and the %3 %2 record have been changed since the last synchronization, or synchronization has never been performed. No one changed bidirectional field was detected, therefore you can continue continue with both bi- and uni-directional synchronization. If you continue, data will be updated in accordance with the chosen synchronization direction and fields mapping.', Comment = '%1 and %2 area captions of tables such as Customer and CRM Account, %3 = Dataverse service name'; BothRecordsModifiedToCRMQst: Label 'Both %1 and the %4 %2 record have been changed since the last synchronization, or synchronization has never been performed. If you continue with synchronization, data in %4 will be overwritten with data from %3. Are you sure you want to synchronize?', Comment = '%1 is a formatted RecordID, such as ''Customer 1234''. %2 is the caption of a Dataverse table. %3 - product name, %4 = Dataverse service name'; BothRecordsModifiedToNAVQst: Label 'Both %1 and the %4 %2 record have been changed since the last synchronization, or synchronization has never been performed. If you continue with synchronization, data in %3 will be overwritten with data from %4. Are you sure you want to synchronize?', Comment = '%1 is a formatted RecordID, such as ''Customer 1234''. %2 is the caption of a Dataverse table. %3 - product name, %4 = Dataverse service name'; CRMIntegrationEnabledState: Option " ","Not Enabled",Enabled,"Enabled But Not For Current User"; CDSIntegrationEnabledState: Option " ","Not Enabled",Enabled,"Enabled But Not For Current User"; NotEnabledForCurrentUserMsg: Label '%3 Integration is enabled.\However, because the %2 Users Must Map to %4 Users field is set, %3 integration is not enabled for %1.', Comment = '%1 = Current User Id %2 - product name, %3 = CRM product name, %4 = Dataverse service name'; CRMIntegrationEnabledLastError: Text; ImportSolutionConnectStringTok: Label '%1api%2/XRMServices/2011/Organization.svc', Locked = true; UserDoesNotExistCRMErr: Label 'There is no user with email address %1 in %2. Enter a valid email address.', Comment = '%1 = User email address, %2 = Dataverse service name'; EmailAndServerAddressEmptyErr: Label 'The Integration User Email and Server Address fields must not be empty.'; CRMSolutionFileNotFoundErr: Label 'A file for a CRM solution could not be found.'; MicrosoftDynamicsNavIntegrationTxt: Label 'MicrosoftDynamicsNavIntegration', Locked = true; AdminEmailPasswordWrongErr: Label 'Enter valid %1 administrator credentials.', Comment = '%1 = CRM product name'; OrganizationServiceFailureErr: Label 'The setup failed due to a generic error. Please sign in to the Dataverse organization with an account that has the System Administrator role. Ensure that no other import or deletion of a PowerApps solution is currently in progress. Additionally, verify that the solution file is not broken and that the specified administrator has sufficient privileges.'; InvalidUriErr: Label 'The value entered is not a valid URL.'; MustUseHttpsErr: Label 'The application is set up to support secure connections (HTTPS) to %1 only. You cannot use HTTP.', Comment = '%1 = CRM product name'; MustUseHttpOrHttpsErr: Label '%1 is not a valid URI scheme for %2 connections. You can only use HTTPS or HTTP as the scheme in the URL.', Comment = '%1 is a URI scheme, such as FTP, HTTP, chrome or file, %2 = CRM product name'; ReplaceServerAddressQst: Label 'The URL is not valid. Do you want to replace it with the URL suggested below?\\Entered URL: "%1".\Suggested URL: "%2".', Comment = '%1 and %2 are URLs'; CRMConnectionURLWrongErr: Label 'The URL is incorrect. Enter the URL for the %1 connection.', Comment = '%1 = CRM product name'; NoOf: Option ,Scheduled,Failed,Skipped,Total; NotEnabledMsg: Label 'To perform this action you must be connected to %1. You can set up the connection to %1 from the %2 page. Do you want to open it now?', Comment = '%1 = Dataverse service name, %2 = Assisted Setup page caption.'; ConnectionStringFormatTok: Label 'Url=%1; UserName=%2; Password=%3; ProxyVersion=%4; %5', Locked = true; OAuthConnectionStringFormatTok: Label 'Url=%1; AccessToken=%2; ProxyVersion=%3; %4', Locked = true; CRMDisabledErrorReasonNotificationIdTxt: Label 'd82835d9-a005-451a-972b-0d6532de2072'; ConnectionBrokenMsg: Label 'The connection to Dynamics 365 Sales is disabled due to the following error: %1.\\Please contact your system administrator.', Comment = '%1 = Error text received from D365 for Sales'; ConnectionDisabledNotificationMsg: Label 'Connection to Dynamics 365 is broken and that it has been disabled due to an error: %1', Comment = '%1 = Error text received from D365 for Sales'; CRMConnectionSetupTxt: Label 'Set up %1 connection', Comment = '%1 = CRM product name'; VideoUrlSetupCRMConnectionTxt: Label '', Locked = true; ConnectionDisabledReasonTxt: Label 'The connection to %1 was disabled because integration user %2 has insufficient privileges to run the synchronization.', Comment = '%1 = a URL, %2 - an email address'; CannotAssignRoleToTeamErr: Label 'Cannot assign role %3 to team %1 for business unit %2.', Comment = '%1 = team name, %2 = business unit name, %3 = security role name'; CannotAssignRoleToTeamTxt: Label 'Cannot assign role to team.', Locked = true; IntegrationRoleNotFoundErr: Label 'There is no integration role %1 for business unit %2.', Comment = '%1 = role name, %2 = business unit name'; TeamNotFoundErr: Label 'Cannot find the default owning team for the coupled business unit %1 selected on page %2. To continue, you can select another business unit or revert to the default business unit that was created during setup.', Comment = '%1 = business unit name, %2 = setup page caption'; TeamNotFoundTxt: Label 'The team was not found.', Locked = true; RoleNotFoundForBusinessUnitTxt: Label 'Integration role is not found for business unit.', Locked = true; CategoryTok: Label 'AL Dataverse Integration', Locked = true; TimeoutTxt: Label 'timeout', Locked = true; RetryAfterTimeoutErr: Label 'The operation timed out. Try again.\\%1', Comment = '%1 - exception message '; ConnectionFailureTxt: Label 'Connection failure.', Locked = true; DisableIntegrationTxt: Label 'Disable integration.', Locked = true; ClearDisabledReasonTxt: Label 'Clear disabled reason.', Locked = true; IntegrationDisabledTxt: Label 'Integration is disabled.', Locked = true; IntegrationNotConfiguredTxt: Label 'Integration is not configured.', Locked = true; NoPermissionsTxt: Label 'No permissions.', Locked = true; NotLocalTableTxt: Label 'Table %1 is not local.', Locked = true; UpdateConflictHandledFromIntTxt: Label 'Update conflict handled by getting update from Dynamics 365 Sales.', Locked = true; UpdateConflictHandledToIntTxt: Label 'Update conflict handled by sending update to Dynamics 365 Sales.', Locked = true; UpdateConflictHandledSkipTxt: Label 'Update conflict handled by skipping the updated record.', Locked = true; DeletionConflictHandledRemoveCouplingTxt: Label 'Deletion conflict handled by removing the coupling to the deleted record.', Locked = true; DeletionConflictHandledRestoreRecordTxt: Label 'Deletion conflict handled by restoring the deleted record.', Locked = true; ResetAllCustomIntegrationTableMappingsLbl: Label 'One or more of the selected integration table mappings is custom.\\Restoring the default table mapping for a custom table mapping will restore all custom table mappings to their default.\\Do you want to continue?'; DeletedRecordWithZeroTableIdTxt: Label 'CRM Integration Record with zero Table ID has been deleted. Integration ID: %1, CRM ID: %2', Locked = true; AllRecordsMarkedAsSkippedTxt: Label 'All of selected %1 records are marked as skipped.', Comment = '%1 = table caption'; RecordMarkedAsSkippedTxt: Label 'The %1 record is marked as skipped.', Comment = '%1 = table caption'; AllRecordsAlreadyCoupledTxt: Label 'All of the selected records are already coupled.', Comment = '%1 = table caption'; RecordAlreadyCoupledTxt: Label 'The record is already coupled.', Comment = '%1 = table caption'; DetailedNotificationMessageTxt: Label '%1 %2', Comment = '%1 - notification message, %2 - details', Locked = true; CommonNotificationNameTxt: Label 'Notify the user about scheduled Dataverse synchronization jobs.', Comment = 'Dataverse is a name of a Microsoft service and must not be translated.'; SkippedRecordsNotificationNameTxt: Label 'Notify the user about records that are skipped during Dataverse synchronization jobs.', Comment = 'Dataverse is a name of a Microsoft service and must not be translated.'; CommonNotificationDescriptionTxt: Label 'Turns the user''s attention to the Integration Synchronization Jobs page.'; SkippedRecordsNotificationDescriptionTxt: Label 'Turns the user''s attention to the Coupled Data Synchronization Errors page.'; UserDisabledNotificationTxt: Label 'The user disabled notification ''%1''.', Locked = true; DisableNotificationTxt: Label 'Disable this notification.'; UserOpenedIntegrationSynchJobListViaNotificationTxt: Label 'User opened Integration Synchronization Pobs via the notification.', Locked = true; BrokenCouplingsFoundAndMarkedAsSkippedForMappingTxt: Label 'Broken couplings were found and marked as skipped. Mapping: %1 - %2. Direction: %3. Count: %4.', Locked = true; BrokenCouplingsFoundAndMarkedAsSkippedTotalTxt: Label 'Broken couplings were found and marked as skipped. Total count: %1.', Locked = true; NoBrokenCouplingsFoundTxt: Label 'No broken couplings were found.', Locked = true; AccountRelationshipTypeNotSupportedErr: Label 'Dynamics 365 Sales account should have relationship type of Customer or Vendor.'; ProductTypeNotSupportedErr: Label 'Dynamics 365 Sales product should have type of Sales Inventory or Services.'; UpdateUnitGroupMappingJQEDescriptionTxt: Label 'Updating CRM Unit Group Mapping'; RescheduledTaskTxt: label 'Rescheduled task %1 for Job Queue Entry %2 (%3) to run not before %4', Locked = true; SalesProDefaultSettingsPrivilegeNameTxt: label 'prvReadmsdynce_salesprodefaultsettings', Locked = true; SalesProIntegrationSolutionImportedTxt: label 'Integration solution for Sales Professional is imported.', Locked = true; CompanyParameterTok: label '?company=', Locked = true; MultipleCompanyLinkLbl: Label 'https://go.microsoft.com/fwlink/?linkid=2259003', Locked = true; FSIntegrationAppSourceLinkTxt: Label 'https://go.microsoft.com/fwlink/?linkid=2277825', Locked = true; FieldServiceIntegrationAppIdLbl: Label '1ba1031e-eae9-4f20-b9d2-d19b6d1e3f29', Locked = true; procedure IsCRMIntegrationEnabled(): Boolean var CRMConnectionSetup: Record "CRM Connection Setup"; begin if not CRMConnectionSetup.ReadPermission() then exit(false); if CRMIntegrationEnabledState = CRMIntegrationEnabledState::" " then begin ClearLastError(); CRMIntegrationEnabledState := CRMIntegrationEnabledState::"Not Enabled"; Clear(CRMIntegrationEnabledLastError); if CRMConnectionSetup.Get() then begin CRMConnectionSetup.RestoreConnection(); if CRMConnectionSetup."Is Enabled" then begin if not HasTableConnection(TABLECONNECTIONTYPE::CRM, GetDefaultTableConnection(TABLECONNECTIONTYPE::CRM)) then CRMConnectionSetup.RegisterConnection(); CRMIntegrationEnabledState := CRMIntegrationEnabledState::Enabled; OnAfterCRMIntegrationEnabled(); end; end; end; exit(CRMIntegrationEnabledState = CRMIntegrationEnabledState::Enabled); end; procedure IsCDSIntegrationEnabled(): Boolean var isEnabled: Boolean; initConnectionHandled: Boolean; ConnectionName: text; begin OnIsCDSIntegrationEnabled(isEnabled); if isEnabled then begin OnInitCDSConnection(ConnectionName, initConnectionHandled); CDSIntegrationEnabledState := CDSIntegrationEnabledState::Enabled; end else CDSIntegrationEnabledState := CDSIntegrationEnabledState::"Not Enabled"; exit(isEnabled); end; [Scope('OnPrem')] procedure IsIntegrationEnabled(): Boolean var CRMConnectionSentup: Record "CRM Connection Setup"; begin if not CRMConnectionSentup.ReadPermission() then exit(false); if not CRMConnectionSentup.Get() then exit(false); if not CRMConnectionSentup."Is Enabled" then exit(false); exit(true); end; [IntegrationEvent(false, false)] local procedure OnIsCDSIntegrationEnabled(var isEnabled: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnInitCDSConnection(var ConnectionName: Text; var handled: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnGetCDSIntegrationUserId(var IntegrationUserId: Guid; var handled: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnGetCDSServerAddress(var CDSServerAddress: Text; var handled: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnTestCDSConnection(var handled: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnCloseCDSConnection(ConnectionName: Text; var handled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnAfterCRMIntegrationEnabled() begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenRecordCardPage(RecordID: RecordID; var IsHandled: Boolean) begin end; procedure IsCRMSolutionInstalled(): Boolean begin if TryTouchCRMSolutionEntities() then exit(true); ClearLastError(); exit(false); end; [Scope('OnPrem')] procedure CheckSolutionVersionOutdated(): Boolean var CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; NavTenantSettingsHelper: DotNet NavTenantSettingsHelper; Version: DotNet Version; SolutionVersion: Text; begin if CDSIntegrationMgt.GetSolutionVersion(MicrosoftDynamicsNavIntegrationTxt, SolutionVersion) then if Version.TryParse(SolutionVersion, Version) then exit(Version.CompareTo(NavTenantSettingsHelper.GetPlatformVersion()) < 0); exit(true); end; [TryFunction] local procedure TryTouchCRMSolutionEntities() var CRMNAVConnection: Record "CRM NAV Connection"; CRMAccountStatistics: Record "CRM Account Statistics"; Cnt: Integer; begin Cnt := CRMAccountStatistics.Count(); Cnt := CRMNAVConnection.Count(); if Cnt > 0 then exit; end; procedure SetCRMNAVConnectionUrl(WebClientUrl: Text[250]) var CRMNAVConnection: Record "CRM NAV Connection"; HttpUtility: DotNet HttpUtility; NewConnection: Boolean; begin if StrPos(WebClientUrl, CompanyParameterTok) = 0 then WebClientUrl += CompanyParameterTok + HttpUtility.UrlPathEncode(CompanyName()); CRMNAVConnection.SetRange("Dynamics NAV URL", WebClientUrl); if not CRMNAVConnection.FindFirst() then begin CRMNAVConnection.Init(); NewConnection := true; end; CRMNAVConnection."Dynamics NAV URL" := WebClientUrl; CRMNAVConnection.Name := CopyStr(CompanyName(), 1, MaxStrLen(CRMNAVConnection.Name)); if NewConnection then CRMNAVConnection.Insert() else CRMNAVConnection.Modify(); end; internal procedure RemoveCRMNAVConnectionUrl(WebClientUrl: Text[250]): Boolean var CRMConnectionSetup: Record "CRM Connection Setup"; begin if CRMConnectionSetup.Get() then if CRMConnectionSetup."Is Enabled" then exit(TryRemoveCRMNAVConnectionUrl(CRMConnectionSetup, WebClientUrl)); end; [TryFunction] local procedure TryRemoveCRMNAVConnectionUrl(var CRMConnectionSetup: Record "CRM Connection Setup"; WebClientUrl: Text[250]) var CRMNAVConnection: Record "CRM NAV Connection"; HttpUtility: DotNet HttpUtility; begin if CRMConnectionSetup.Get() then if CRMConnectionSetup."Is Enabled" then begin if not HasTableConnection(TABLECONNECTIONTYPE::CRM, GetDefaultTableConnection(TABLECONNECTIONTYPE::CRM)) then CRMConnectionSetup.RegisterConnection(); if StrPos(WebClientUrl, CompanyParameterTok) = 0 then WebClientUrl += CompanyParameterTok + HttpUtility.UrlPathEncode(CompanyName()); CRMNAVConnection.SetRange("Dynamics NAV URL", WebClientUrl); if not CRMNAVConnection.FindFirst() then exit; CRMNAVConnection.Delete(); end; end; procedure UpdateMultipleNow(RecVariant: Variant) begin UpdateMultipleNow(RecVariant, false); end; procedure UpdateMultipleNow(RecVariant: Variant; IsOption: Boolean) var RecRef: RecordRef; RecordCounter: array[4] of Integer; begin RecordCounter[NoOf::Total] := GetRecordRef(RecVariant, RecRef); if RecordCounter[NoOf::Total] = 0 then exit; if RecRef.Number = DATABASE::"CRM Integration Record" then UpdateCRMIntRecords(RecRef, RecordCounter) else if IsOption then UpdateOptions(RecRef, RecordCounter) else UpdateRecords(RecRef, RecordCounter); end; local procedure UpdateCRMIntRecords(var RecRef: RecordRef; var RecordCounter: array[4] of Integer) var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; SourceRecRef: RecordRef; RecId: RecordId; SelectedDirection: Integer; Direction: Integer; Unused: Boolean; LocalTableId: Integer; MappingName: Code[20]; RecordCount: Integer; TotalCount: Integer; IdFilter: Text; IdFilterList: List of [Text]; LocalTableList: List of [Integer]; LocalIdList: List of [Guid]; CRMIdList: List of [Guid]; MappingDictionary: Dictionary of [Integer, Code[20]]; LocalIdDictionary: Dictionary of [Code[20], List of [Guid]]; CRMIdDictionary: Dictionary of [Code[20], List of [Guid]]; TableCaption: Text; begin if RecordCounter[NoOf::Total] = 1 then begin RecRef.SetTable(CRMIntegrationRecord); LocalTableId := CRMIntegrationRecord."Table ID"; CRMIntegrationRecord.FindRecordId(RecId); GetIntegrationTableMapping(IntegrationTableMapping, RecId); SourceRecRef.Get(RecId); SelectedDirection := GetSelectedSingleSyncDirection(IntegrationTableMapping, SourceRecRef, CRMIntegrationRecord."CRM ID", Unused) end else begin IntegrationTableMapping.Direction := IntegrationTableMapping.Direction::Bidirectional; SelectedDirection := GetSelectedMultipleSyncDirection(IntegrationTableMapping); end; if SelectedDirection < 0 then exit; // The user cancelled repeat RecRef.SetTable(CRMIntegrationRecord); CRMIntegrationRecord.FindRecordId(RecId); LocalTableId := CRMIntegrationRecord."Table ID"; if not MappingDictionary.ContainsKey(LocalTableId) then begin GetIntegrationTableMapping(IntegrationTableMapping, RecId); MappingDictionary.Add(LocalTableId, IntegrationTableMapping.Name); end; MappingName := MappingDictionary.Get(LocalTableId); if not LocalIdDictionary.ContainsKey(MappingName) then begin Clear(LocalIdList); LocalIdDictionary.Add(MappingName, LocalIdList); end; if not CRMIdDictionary.ContainsKey(MappingName) then begin Clear(CRMIdList); CRMIdDictionary.Add(MappingName, CRMIdList); end; LocalIdList := LocalIdDictionary.Get(MappingName); CRMIdList := CRMIdDictionary.Get(MappingName); LocalIdList.Add(CRMIntegrationRecord."Integration ID"); CRMIdList.Add(CRMIntegrationRecord."CRM ID"); TotalCount += 1; until RecRef.Next() = 0; if TotalCount = 0 then begin if MappingDictionary.Keys().Count() = 1 then TableCaption := GetTableCaption(MappingDictionary.Keys().Get(1)); if RecordCounter[NoOf::Total] > 1 then SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, StrSubstNo(AllRecordsMarkedAsSkippedTxt, TableCaption))) else SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, StrSubstNo(RecordMarkedAsSkippedTxt, TableCaption))); exit; end; LocalTableList := MappingDictionary.Keys(); foreach LocalTableId in LocalTableList do begin MappingName := MappingDictionary.Get(LocalTableId); LocalIdList := LocalIdDictionary.Get(MappingName); RecordCount := LocalIdList.Count(); if RecordCount > 0 then begin CRMIdList := CRMIdDictionary.Get(MappingName); IntegrationTableMapping.Get(MappingName); if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::Bidirectional then Direction := SelectedDirection else Direction := IntegrationTableMapping.Direction; if EnqueueSyncJob(IntegrationTableMapping, LocalIdList, CRMIdList, Direction, false) then begin IntegrationRecordSynch.GetIdFilterList(LocalIdList, IdFilterList); foreach IdFilter in IdFilterList do if IdFilter <> '' then begin CRMIntegrationRecord.SetFilter("Integration ID", IdFilter); CRMIntegrationRecord.ModifyAll(Skipped, false); end; RecordCounter[NoOf::Scheduled] += RecordCount; end else RecordCounter[NoOf::Failed] += RecordCount; end; end; SendSyncNotification(RecordCounter); end; local procedure UpdateRecords(var LocalRecordRef: RecordRef; var RecordCounter: array[4] of Integer) var IntegrationTableMapping: Record "Integration Table Mapping"; SelectedDirection: Integer; CRMID: Guid; Unused: Boolean; Skipped: Boolean; RecordCount: Integer; LocalId: Guid; LocalIdList: List of [Guid]; CRMIdList: List of [Guid]; begin GetIntegrationTableMapping(IntegrationTableMapping, LocalRecordRef.RecordId()); if RecordCounter[NoOf::Total] = 1 then if GetCoupledCRMID(LocalRecordRef.RecordId(), CRMID) then SelectedDirection := GetSelectedSingleSyncDirection(IntegrationTableMapping, LocalRecordRef, CRMID, Unused) else begin DefineCouplingIfNotCoupled(LocalRecordRef.RecordId(), CRMID); exit; end else SelectedDirection := GetSelectedMultipleSyncDirection(IntegrationTableMapping); if SelectedDirection < 0 then exit; // The user cancelled repeat Skipped := false; if RecordCounter[NoOf::Total] > 1 then begin Skipped := not GetCoupledCRMID(LocalRecordRef.RecordId(), CRMID); if not Skipped then Skipped := WasRecordModifiedAfterLastSynch(IntegrationTableMapping, LocalRecordRef, CRMID, SelectedDirection); end; if not Skipped then Skipped := IsRecordSkipped(LocalRecordRef.RecordId()); if Skipped then RecordCounter[NoOf::Skipped] += 1 else begin LocalId := LocalRecordRef.Field((LocalRecordRef.SystemIdNo())).Value(); LocalIdList.Add(LocalId); CRMIdList.Add(CRMID); end; until LocalRecordRef.Next() = 0; RecordCount := LocalIdList.Count(); if RecordCount = 0 then begin if RecordCounter[NoOf::Total] > 1 then SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, StrSubstNo(AllRecordsMarkedAsSkippedTxt, GetTableCaption(LocalRecordRef.Number())))) else SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, StrSubstNo(RecordMarkedAsSkippedTxt, GetTableCaption(LocalRecordRef.Number())))); exit; end; if EnqueueSyncJob(IntegrationTableMapping, LocalIdList, CRMIdList, SelectedDirection, IntegrationTableMapping."Synch. Only Coupled Records") then RecordCounter[NoOf::Scheduled] += RecordCount else RecordCounter[NoOf::Failed] += RecordCount; SendSyncNotification(RecordCounter); end; local procedure UpdateOptions(var RecRef: RecordRef; var RecordCounter: array[4] of Integer) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMOptionMapping: Record "CRM Option Mapping"; SelectedDirection: Integer; CRMOptionId: Integer; CRMOptionIds: List of [Integer]; LocalIds: List of [Guid]; begin GetIntegrationTableMapping(IntegrationTableMapping, RecRef.RecordId()); if RecordCounter[NoOf::Total] = 1 then if not GetMappedCRMOptionId(RecRef.RecordId(), CRMOptionId) then begin DefineOptionMappingIfNotMapped(RecRef.RecordId(), CRMOptionId); exit; end; SelectedDirection := GetSelectedMultipleSyncDirection(IntegrationTableMapping); if SelectedDirection < 0 then exit; // The user cancelled if SelectedDirection = IntegrationTableMapping.Direction::FromIntegrationTable then begin repeat if GetMappedCRMOptionId(RecRef.RecordId(), CRMOptionId) then CRMOptionIds.Add(CRMOptionId) else RecordCounter[NoOf::Skipped] += 1 until RecRef.Next() = 0; if EnqueueOptionSyncJobFromIntegrationTable(IntegrationTableMapping, CRMOptionIds, SelectedDirection, true) then RecordCounter[NoOf::Scheduled] += CRMOptionIds.Count() else RecordCounter[NoOf::Failed] += CRMOptionIds.Count(); end; if SelectedDirection = IntegrationTableMapping.Direction::ToIntegrationTable then begin repeat CRMOptionMapping.SetRange("Record ID", RecRef.RecordId()); if not CRMOptionMapping.IsEmpty() then LocalIds.Add(RecRef.Field(RecRef.SystemIdNo).Value()) else RecordCounter[NoOf::Skipped] += 1 until RecRef.Next() = 0; if EnqueueOptionSyncJobToIntegrationTable(IntegrationTableMapping, LocalIds, SelectedDirection, true) then RecordCounter[NoOf::Scheduled] += LocalIds.Count() else RecordCounter[NoOf::Failed] += LocalIds.Count(); end; SendSyncNotification(RecordCounter); end; procedure UpdateOneNow(RecordID: RecordID) begin // Extinct method. Kept for backward compatibility. UpdateMultipleNow(RecordID) end; procedure UpdateSkippedNow(var CRMIntegrationRecord: Record "CRM Integration Record") begin UpdateSkippedNow(CRMIntegrationRecord, false); end; procedure UpdateSkippedNow(var CRMIntegrationRecord: Record "CRM Integration Record"; var CRMOptionMapping: Record "CRM Option Mapping") begin UpdateSkippedNow(CRMIntegrationRecord, CRMOptionMapping, false); end; procedure UpdateSkippedNow(var CRMIntegrationRecord: Record "CRM Integration Record"; SkipNotification: Boolean) var CRMOptionMapping: Record "CRM Option Mapping"; begin UpdateSkippedNow(CRMIntegrationRecord, CRMOptionMapping, SkipNotification); end; procedure UpdateSkippedNow(var CRMIntegrationRecord: Record "CRM Integration Record"; var CRMOptionMapping: Record "CRM Option Mapping"; SkipNotification: Boolean) var RecId: RecordId; RecRef: RecordRef; RestoredRecCounter: Integer; begin if CRMIntegrationRecord.FindSet() then repeat if CRMIntegrationRecord.Skipped then if CRMIntegrationRecord.FindRecordId(RecId) then begin CRMIntegrationRecord.Validate(Skipped, false); CRMIntegrationRecord.Modify(); RestoredRecCounter += 1; end; until CRMIntegrationRecord.Next() = 0; if CRMOptionMapping.FindSet() then repeat if CRMOptionMapping.Skipped then begin RecRef.Open(CRMOptionMapping."Table ID"); if RecRef.Get(CRMOptionMapping."Record ID") then begin CRMOptionMapping.Skipped := false; CRMOptionMapping.Modify(); RestoredRecCounter += 1; end; end; until CRMOptionMapping.Next() = 0; if not SkipNotification then SendRestoredSyncNotification(RestoredRecCounter); end; procedure UpdateAllSkippedNow() var CRMIntegrationRecord: Record "CRM Integration Record"; CRMOptionMapping: Record "CRM Option Mapping"; RestoredRecCounter: Integer; begin CRMIntegrationRecord.SetRange(Skipped, true); CRMOptionMapping.SetRange(Skipped, true); RestoredRecCounter := CRMIntegrationRecord.Count() + CRMOptionMapping.Count(); if CRMIntegrationRecord.Count() > 0 then CRMIntegrationRecord.ModifyAll(Skipped, false); if CRMOptionMapping.Count() > 0 then CRMOptionMapping.ModifyAll(Skipped, false); SendRestoredSyncNotification(RestoredRecCounter); end; local procedure WasRecordModifiedAfterLastSynch(IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef; CRMID: Guid; SelectedDirection: Option): Boolean var IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; CRMRecordRef: RecordRef; RecordModified: Boolean; CRMRecordModified: Boolean; begin RecordModified := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, RecRef); IntegrationTableMapping.GetRecordRef(CRMID, CRMRecordRef); CRMRecordModified := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, CRMRecordRef); exit( ((SelectedDirection = IntegrationTableMapping.Direction::ToIntegrationTable) and CRMRecordModified) or ((SelectedDirection = IntegrationTableMapping.Direction::FromIntegrationTable) and RecordModified)) end; procedure CheckOrEnableCRMConnection() var CDSIntegrationImpl: Codeunit "CDS Integration Impl."; GuidedExperience: Codeunit "Guided Experience"; FeatureTelemetry: Codeunit "Feature Telemetry"; AssistedSetup: Page "Assisted Setup"; GuidedExperienceType: Enum "Guided Experience Type"; begin if IsCDSIntegrationEnabled() then exit; if IsCRMIntegrationEnabled() then exit; if CRMIntegrationEnabledLastError <> '' then Error(CRMIntegrationEnabledLastError); if GuiAllowed then if CRMIntegrationEnabledState = CRMIntegrationEnabledState::"Enabled But Not For Current User" then Message(NotEnabledForCurrentUserMsg, UserId, PRODUCTNAME.Short(), CRMProductName.SHORT(), CRMProductName.CDSServiceName()) else begin FeatureTelemetry.LogUptake('0000H7D', 'Dynamics 365 Sales', Enum::"Feature Uptake Status"::Discovered); FeatureTelemetry.LogUptake('0000H7E', 'Dataverse', Enum::"Feature Uptake Status"::Discovered); if Confirm(StrSubstNo(NotEnabledMsg, CRMProductName.CDSServiceName(), AssistedSetup.Caption())) then begin CDSIntegrationImpl.RegisterAssistedSetup(); GuidedExperience.Run(GuidedExperienceType::"Assisted Setup", ObjectType::Page, Page::"CDS Connection Setup Wizard"); if IsCDSIntegrationEnabled() then exit; end; end; Error(''); end; local procedure GetRecordRef(RecVariant: Variant; var RecordRef: RecordRef): Integer begin case true of RecVariant.IsRecord: RecordRef.GetTable(RecVariant); RecVariant.IsRecordId: if RecordRef.Get(RecVariant) then RecordRef.SetRecFilter(); RecVariant.IsRecordRef: RecordRef := RecVariant; else exit(0); end; if RecordRef.FindSet() then exit(RecordRef.Count); exit(0); end; procedure CreateNewRecordsInCRM(RecVariant: Variant) var IntegrationTableMapping: Record "Integration Table Mapping"; RecordRef: RecordRef; LocalIdListDictionary: Dictionary of [Code[20], List of [Guid]]; LocalIdList: List of [Guid]; LocalId: Guid; begin if GetRecordRef(RecVariant, RecordRef) = 0 then exit; GetIntegrationTableMappingFromCRMRecord(IntegrationTableMapping, RecordRef); LocalIdListDictionary.Add(IntegrationTableMapping.Name, LocalIdList); repeat LocalId := RecordRef.Field(RecordRef.SystemIdNo()).Value(); LocalIdList.Add(LocalId); until RecordRef.Next() = 0; CreateNewRecordsInCRM(LocalIdListDictionary); end; procedure CreateNewOptionsInCRM(RecVariant: Variant) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMOptionMapping: Record "CRM Option Mapping"; RecRef: RecordRef; RecordCounter: array[4] of Integer; LocalIdList: List of [Guid]; begin if GetRecordRef(RecVariant, RecRef) = 0 then exit; GetIntegrationTableMapping(IntegrationTableMapping, RecRef.RecordId()); repeat RecordCounter[NoOf::Total] += 1; CRMOptionMapping.SetRange("Record ID", RecRef.RecordId()); if not CRMOptionMapping.IsEmpty() then RecordCounter[NoOf::Skipped] += 1 else LocalIdList.Add(RecRef.Field(RecRef.SystemIdNo()).Value()); until RecRef.Next() = 0; if EnqueueOptionSyncJobToIntegrationTable(IntegrationTableMapping, LocalIdList, IntegrationTableMapping.Direction::ToIntegrationTable, false) then RecordCounter[NoOf::Scheduled] += LocalIdList.Count() else RecordCounter[NoOf::Failed] += LocalIdList.Count(); SendCreateNewNotification(RecordCounter); end; procedure CreateNewOptionsInCRM(var LocalIdListDictionary: Dictionary of [Code[20], List of [Guid]]) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMOptionMapping: Record "CRM Option Mapping"; LocalRecordRef: RecordRef; IntegrationTableMappingName: Code[20]; LocalId: Guid; RecordCounter: array[4] of Integer; IntegrationTableMappingNameList: List of [Code[20]]; LocalIdList: List of [Guid]; SynchronizeLocalIdList: List of [Guid]; begin IntegrationTableMappingNameList := LocalIdListDictionary.Keys(); foreach IntegrationTableMappingName in IntegrationTableMappingNameList do begin IntegrationTableMapping.Get(IntegrationTableMappingName); LocalIdList := LocalIdListDictionary.Get(IntegrationTableMappingName); foreach LocalId in LocalIdList do begin RecordCounter[NoOf::Total] += 1; LocalRecordRef.Open(IntegrationTableMapping."Table ID"); LocalRecordRef.GetBySystemId(LocalId); CRMOptionMapping.SetRange("Record ID", LocalRecordRef.RecordId()); if not CRMOptionMapping.IsEmpty() then RecordCounter[NoOf::Skipped] += 1 else SynchronizeLocalIdList.Add(LocalId); LocalRecordRef.Close(); end; end; if EnqueueOptionSyncJobToIntegrationTable(IntegrationTableMapping, SynchronizeLocalIdList, IntegrationTableMapping.Direction, false) then RecordCounter[NoOf::Scheduled] += SynchronizeLocalIdList.Count() else RecordCounter[NoOf::Failed] += SynchronizeLocalIdList.Count(); SendCreateNewNotification(RecordCounter); end; [Scope('OnPrem')] procedure CreateNewRecordsInCRM(var LocalIdListDictionary: Dictionary of [Code[20], List of [Guid]]) var CRMIdListDictionary: Dictionary of [Code[20], List of [Guid]]; begin CreateNewRecords(LocalIdListDictionary, CRMIdListDictionary); end; [Scope('Cloud')] procedure CreateNewRecordsFromSelectedCRMOptions(RecVariant: Variant) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMOptionMapping: Record "CRM Option Mapping"; RecRef: RecordRef; RecordCounter: array[4] of Integer; CRMOptionIds: List of [Integer]; CRMOptionId: Integer; begin if GetRecordRef(RecVariant, RecRef) = 0 then exit; GetIntegrationTableMappingFromCRMOption(IntegrationTableMapping, RecRef); repeat RecordCounter[NoOf::Total] += 1; CRMOptionId := GetOptionIdFieldRef(RecRef).Value(); if CRMOptionMapping.FindRecordID(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMOptionId) then RecordCounter[NoOf::Skipped] += 1 else CRMOptionIds.Add(CRMOptionId); until RecRef.Next() = 0; if EnqueueOptionSyncJobFromIntegrationTable(IntegrationTableMapping, CRMOptionIds, IntegrationTableMapping.Direction::FromIntegrationTable, false) then RecordCounter[NoOf::Scheduled] += CRMOptionIds.Count() else RecordCounter[NoOf::Failed] += CRMOptionIds.Count(); SendCreateNewNotification(RecordCounter); end; procedure EnqueueOptionSyncJobFromIntegrationTable(IntegrationTableMapping: Record "Integration Table Mapping"; CRMOptionIds: List of [Integer]; Direction: Integer; SynchronizeOnlyCoupledRecords: Boolean): Boolean var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; begin IntegrationTableMapping.Direction := Direction; if Direction = IntegrationTableMapping.Direction::FromIntegrationTable then begin IntegrationTableMapping.SetIntegrationTableFilter(GetTableViewForCRMOptionIds(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMOptionIds)); AddIntegrationTableMapping(IntegrationTableMapping, SynchronizeOnlyCoupledRecords); Commit(); exit(CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping)); end; end; procedure EnqueueOptionSyncJobToIntegrationTable(IntegrationTableMapping: Record "Integration Table Mapping"; LocalIdList: List of [Guid]; Direction: Integer; SynchronizeOnlyCoupledRecords: Boolean): Boolean var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin IntegrationTableMapping.Direction := Direction; if Direction = IntegrationTableMapping.Direction::ToIntegrationTable then begin IntegrationTableMapping.SetTableFilter(IntegrationRecordSynch.GetTableViewForSystemIds(IntegrationTableMapping."Table ID", LocalIdList)); AddIntegrationTableMapping(IntegrationTableMapping, SynchronizeOnlyCoupledRecords); Commit(); exit(CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping)); end; end; local procedure EnqueueOptionSyncJob(IntegrationTableMapping: Record "Integration Table Mapping"; RecordId: RecordId; CRMOptionId: Integer; Direction: Integer): Boolean var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin IntegrationTableMapping.Direction := Direction; IntegrationTableMapping.SetIntegrationTableFilter(GetTableViewForCRMOptionId(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMOptionId)); IntegrationTableMapping.SetTableFilter(IntegrationRecordSynch.GetTableViewForRecordID(RecordId)); AddIntegrationTableMapping(IntegrationTableMapping); Commit(); exit(CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping)); end; procedure CreateNewRecordsFromCRM(RecVariant: Variant) var IntegrationTableMapping: Record "Integration Table Mapping"; RecordRef: RecordRef; CRMIdListDictionary: Dictionary of [Code[20], List of [Guid]]; CRMIdList: List of [Guid]; CRMID: Guid; begin if GetRecordRef(RecVariant, RecordRef) = 0 then exit; GetIntegrationTableMappingFromCRMRecord(IntegrationTableMapping, RecordRef); CRMIdListDictionary.Add(IntegrationTableMapping.Name, CRMIdList); repeat CRMID := RecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No.").Value(); CRMIdList.Add(CRMID); until RecordRef.Next() = 0; CreateNewRecordsFromCRM(CRMIdListDictionary); end; [Scope('OnPrem')] procedure CreateNewRecordsFromCRM(var CRMIdListDictionary: Dictionary of [Code[20], List of [Guid]]) var LocalIdListDictionary: Dictionary of [Code[20], List of [Guid]]; begin CreateNewRecords(LocalIdListDictionary, CRMIdListDictionary); end; [Scope('OnPrem')] procedure CreateNewRecords(var LocalIdListDictionary: Dictionary of [Code[20], List of [Guid]]; var CRMIdListDictionary: Dictionary of [Code[20], List of [Guid]]) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationRecord: Record "CRM Integration Record"; CRMRecordRef: RecordRef; RecordCounter: array[4] of Integer; LocalId: Guid; CRMId: Guid; LocalIdCount: Integer; CRMIdCount: Integer; MappingDictionary: Dictionary of [Code[20], Boolean]; ToCRMMappingList: List of [Code[20]]; FromCRMMappingList: List of [Code[20]]; MappingList: List of [Code[20]]; LocalIdList: List of [Guid]; CRMIdList: List of [Guid]; MappingName: Code[20]; I: Integer; J: Integer; begin ToCRMMappingList := LocalIdListDictionary.Keys(); FromCRMMappingList := CRMIdListDictionary.Keys(); MappingList.AddRange(ToCRMMappingList); MappingList.AddRange(fromCRMMappingList); foreach MappingName in MappingList do if not MappingDictionary.ContainsKey(MappingName) then MappingDictionary.Add(MappingName, true); MappingList := MappingDictionary.Keys(); foreach MappingName in MappingList do begin Clear(LocalIdList); Clear(CRMIdList); IntegrationTableMapping.Get(MappingName); if ToCRMMappingList.Contains(MappingName) then begin LocalIdList := LocalIdListDictionary.Get(MappingName); LocalIdCount := LocalIdList.Count(); if LocalIdCount > 0 then begin J := LocalIdCount + 1; for I := 1 to LocalIdCount do begin J -= 1; LocalId := LocalIdList.Get(J); RecordCounter[NoOf::Total] += 1; CRMIntegrationRecord.SetCurrentKey("Integration ID"); CRMIntegrationRecord.SetFilter("Integration ID", LocalId); if CRMIntegrationRecord.FindFirst() then begin if CRMIntegrationRecord.GetCRMRecordRef(IntegrationTableMapping."Integration Table ID", CRMRecordRef) then begin RecordCounter[NoOf::Skipped] += 1; LocalIdList.RemoveAt(J); end else if not IsNullGuid(CRMIntegrationRecord."CRM ID") then // found the corrupt coupling CRMIntegrationRecord.Delete(); CRMRecordRef.Close(); end; end; end; end; if FromCRMMappingList.Contains(MappingName) then begin CRMIdList := CRMIdListDictionary.Get(MappingName); CRMIdCount := CRMIdList.Count(); if CRMIdCount > 0 then begin J := CRMIdCount + 1; for I := 1 to CRMIdCount do begin J -= 1; CRMID := CRMIdList.Get(J); RecordCounter[NoOf::Total] += 1; if CRMIntegrationRecord.FindValidByCRMID(CRMID) then begin RecordCounter[NoOf::Skipped] += 1; CRMIdList.RemoveAt(J); end else if not IsNullGuid(CRMIntegrationRecord."CRM ID") then // found the corrupt coupling CRMIntegrationRecord.Delete(); end; end; end; EnqueueCreateNewJob(LocalIdList, CRMIdList, RecordCounter, IntegrationTableMapping); end; SendCreateNewNotification(RecordCounter); end; local procedure EnqueueCreateNewJob(var LocalIdList: List of [Guid]; CRMIdList: List of [Guid]; var RecordCounter: array[4] of Integer; var IntegrationTableMapping: Record "Integration Table Mapping") var LocalIdCount: Integer; CRMIdCount: Integer; Direction: Option; begin LocalIdCount := LocalIdList.Count(); CRMIdCount := CRMIdList.Count(); if (LocalIdCount > 0) or (CRMIdCount > 0) then begin if CRMIdCount = 0 then Direction := IntegrationTableMapping.Direction::ToIntegrationTable else if LocalIdCount = 0 then Direction := IntegrationTableMapping.Direction::FromIntegrationTable else Direction := IntegrationTableMapping.Direction; if EnqueueSyncJob(IntegrationTableMapping, LocalIdList, CRMIdList, Direction, false) then RecordCounter[NoOf::Scheduled] += LocalIdCount + CRMIdCount else RecordCounter[NoOf::Failed] += LocalIdCount + CRMIdCount; end; end; local procedure SendCreateNewNotification(var RecordCounter: array[4] of Integer) begin if RecordCounter[NoOf::Total] = RecordCounter[NoOf::Skipped] then begin if RecordCounter[NoOf::Total] > 1 then SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, AllRecordsAlreadyCoupledTxt)) else SendNotification(StrSubstNo(DetailedNotificationMessageTxt, SyncNowSkippedMsg, RecordAlreadyCoupledTxt)); exit; end; SendSyncNotification(RecordCounter); end; [Scope('OnPrem')] procedure CreateNewRecordsFromSelectedCRMRecords(RecVariant: Variant) begin CreateNewRecordsFromCRM(RecVariant); end; local procedure PerformInitialSynchronization(RecordID: RecordID; CRMID: Guid; Direction: Option) var IntegrationTableMapping: Record "Integration Table Mapping"; RecordCounter: array[4] of Integer; begin RecordCounter[NoOf::Total] := 1; GetIntegrationTableMapping(IntegrationTableMapping, RecordID); if EnqueueSyncJob(IntegrationTableMapping, RecordID, CRMID, Direction) then RecordCounter[NoOf::Scheduled] += 1 else RecordCounter[NoOf::Failed] += 1; SendSyncNotification(RecordCounter); end; local procedure PerformInitialOptionSynchronization(RecordId: RecordId; CRMOptionId: Integer; Direction: Option) var IntegrationTableMapping: Record "Integration Table Mapping"; RecordCounter: array[4] of Integer; begin RecordCounter[NoOf::Total] := 1; GetIntegrationTableMapping(IntegrationTableMapping, RecordID.TableNo()); if EnqueueOptionSyncJob(IntegrationTableMapping, RecordId, CRMOptionId, Direction) then RecordCounter[NoOf::Scheduled] += 1 else RecordCounter[NoOf::Failed] += 1; SendSyncNotification(RecordCounter); end; internal procedure MarkLocalDeletedAsSkipped() var IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationRecord: Record "CRM Integration Record"; RecordRef: RecordRef; FieldRef: FieldRef; TableFilter: Text; Count: Integer; TotalCount: Integer; begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetFilter(Direction, '<>%1', IntegrationTableMapping.Direction::Bidirectional); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetFilter("Table ID", '<>%1', Database::"Sales Header"); if not IntegrationTableMapping.FindSet() then exit; repeat Count := 0; TableFilter := IntegrationTableMapping.GetTableFilter(); CRMIntegrationRecord.SetRange("Table ID", IntegrationTableMapping."Table ID"); CRMIntegrationRecord.SetRange(Skipped, false); if CRMIntegrationRecord.FindSet() then repeat RecordRef.Open(IntegrationTableMapping."Table ID"); RecordRef.SetView(TableFilter); FieldRef := RecordRef.Field(RecordRef.SystemIdNo()); FieldRef.SetRange(CRMIntegrationRecord."Integration ID"); if RecordRef.IsEmpty() then begin CRMIntegrationRecord.Skipped := true; CRMIntegrationRecord.Modify(); Count += 1; end; RecordRef.Close(); until CRMIntegrationRecord.Next() = 0; TotalCount += Count; if Count > 0 then Session.LogMessage('0000F26', StrSubstNo(BrokenCouplingsFoundAndMarkedAsSkippedForMappingTxt, GetTableCaption(IntegrationTableMapping."Table ID"), GetTableCaption(IntegrationTableMapping."Integration Table ID"), IntegrationTableMapping.Direction, Count), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); until IntegrationTableMapping.Next() = 0; if TotalCount > 0 then Session.LogMessage('0000F27', StrSubstNo(BrokenCouplingsFoundAndMarkedAsSkippedTotalTxt, TotalCount), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok) else Session.LogMessage('0000F28', NoBrokenCouplingsFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; procedure RepairBrokenCouplings() begin RepairBrokenCouplings(false); end; procedure RepairBrokenCouplings(UseLocalRecordsOnly: Boolean) var CRMIntegrationRecord: Record "CRM Integration Record"; BlankGuid: Guid; begin CRMIntegrationRecord.SetRange("Table ID", 0); if CRMIntegrationRecord.IsEmpty() then exit; if CRMIntegrationRecord.FindSet() then repeat if CRMIntegrationRecord."Integration ID" <> BlankGuid then if not CRMIntegrationRecord.RepairTableIdByLocalRecord() then if not UseLocalRecordsOnly then if not CRMIntegrationRecord.RepairTableIdByCRMRecord() then begin CRMIntegrationRecord.Delete(); Session.LogMessage('0000DQD', StrSubstNo(DeletedRecordWithZeroTableIdTxt, CRMIntegrationRecord."Integration ID", CRMIntegrationRecord."CRM ID"), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; until CRMIntegrationRecord.Next() = 0; end; procedure RemoveCoupling(TableID: Integer; CRMTableID: Integer) var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; begin if GetIntegrationTableMappingForUncoupling(IntegrationTableMapping, TableID, CRMTableID) then ScheduleUncoupling(IntegrationTableMapping, '', '') else begin RepairBrokenCouplings(); CRMIntegrationRecord.SetRange("Table ID", TableID); CRMIntegrationRecord.DeleteAll(); end; end; procedure MatchBasedCoupling(TableID: Integer): Boolean begin exit(MatchBasedCoupling(TableID, false, false, false)); end; procedure MatchBasedCoupling(TableID: Integer; SkipSettingCriteria: Boolean; IsFullSync: Boolean; InForeground: Boolean): Boolean var IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationFieldMapping: Record "Integration Field Mapping"; ScheduleJob: Boolean; begin if IsCRMTable(TableID) then begin Session.LogMessage('0000EZO', StrSubstNo(NotLocalTableTxt, GetTableCaption(TableID)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if GetIntegrationTableMappingForCoupling(IntegrationTableMapping, TableID) then begin if SkipSettingCriteria then ScheduleJob := true; if not ScheduleJob then begin IntegrationFieldMapping.SetMatchBasedCouplingFilters(IntegrationTableMapping); ScheduleJob := (Page.RunModal(Page::"Match Based Coupling Criteria", IntegrationFieldMapping) = Action::LookupOK); end; if not ScheduleJob then exit(false); if InForeground then exit(PerformCoupling(IntegrationTableMapping, '', IsFullSync)) else exit(ScheduleCoupling(IntegrationTableMapping, '', IsFullSync)); end; exit(false); end; procedure RemoveCoupling(var LocalRecordRef: RecordRef) begin RemoveCoupling(LocalRecordRef, true); end; procedure MatchBasedCoupling(var LocalRecordRef: RecordRef) var CouplingOption: Option None,Background,Foreground; begin MatchBasedCoupling(LocalRecordRef, CouplingOption::Background); end; procedure RemoveCoupling(LocalTableID: Integer; var LocalIdList: List of [Guid]) begin RemoveCoupling(LocalTableID, LocalIdList, true); end; procedure RemoveCoupling(LocalTableID: Integer; var LocalIdList: List of [Guid]; Schedule: Boolean) var IntegrationRecordSynch: Codeunit "Integration Record Synch."; LocalRecordRef: RecordRef; LocalIdFilter: Text; begin if LocalIdList.Count() = 0 then exit; LocalIdFilter := IntegrationRecordSynch.JoinIDs(LocalIdList, '|'); LocalRecordRef.Open(LocalTableId); LocalRecordRef.Field(LocalRecordRef.SystemIdNo()).SetFilter(LocalIdFilter); RemoveCoupling(LocalRecordRef, Schedule); end; procedure RemoveCoupling(LocalTableID: Integer; IntegrationTableID: Integer; var IntegrationIdList: List of [Guid]) begin RemoveCoupling(LocalTableID, IntegrationTableID, IntegrationIdList, true); end; internal procedure RemoveCoupling(var LocalRecordRef: RecordRef; Schedule: Boolean) var IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin if IsCRMTable(LocalRecordRef.Number()) then begin Session.LogMessage('0000DHU', StrSubstNo(NotLocalTableTxt, GetTableCaption(LocalRecordRef.Number())), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; OnRemoveCouplingOnBeforeGetIntegrationTableMappingForUncoupling(IntegrationTableMapping, LocalRecordRef); if GetIntegrationTableMappingForUncoupling(IntegrationTableMapping, LocalRecordRef.Number()) then if Schedule then ScheduleUncoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForLocalRecords(LocalRecordRef), '') else PerformUncoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForLocalRecords(LocalRecordRef), '') else RemoveCouplingToRecord(LocalRecordRef); end; procedure RemoveOptionMapping(var RecRef: RecordRef) var CRMOptionMapping: Record "CRM Option Mapping"; begin if not RecRef.FindSet() then exit; repeat CRMOptionMapping.SetRange("Record ID", RecRef.RecordId()); if CRMOptionMapping.FindFirst() then CRMOptionMapping.Delete(); until RecRef.Next() = 0; end; local procedure RemoveOptionMapping(IntegrationTableId: Integer; IntegrationFieldId: Integer; OptionId: Integer): Boolean var CRMOptionMapping: Record "CRM Option Mapping"; begin CRMOptionMapping.SetRange("Integration Table ID", IntegrationTableId); CRMOptionMapping.SetRange("Integration Field ID", IntegrationFieldId); CRMOptionMapping.SetRange("Option Value", OptionId); if CRMOptionMapping.FindFirst() then exit(CRMOptionMapping.Delete()); end; local procedure RemoveOptionMappingFromRecRef(RecRef: RecordRef): Boolean var CRMOptionMapping: Record "CRM Option Mapping"; begin CRMOptionMapping.SetRange("Record ID", RecRef.RecordId()); if not CRMOptionMapping.FindFirst() then exit(false); exit(CRMOptionMapping.Delete()); end; procedure CreateOptionMapping(RecordID: RecordID; CRMOptionId: Integer; CRMOptionValue: Text[250]) var CRMOptionMapping: Record "CRM Option Mapping"; begin CRMOptionMapping.SetRange("Record ID", RecordId); if not CRMOptionMapping.FindFirst() then begin CRMOptionMapping.AssertCRMOptionIdCanBeMapped(RecordID, CRMOptionId); CRMOptionMapping.InsertRecord(RecordID, CRMOptionId, CRMOptionValue); end else if CRMOptionMapping."Option Value" <> CRMOptionId then begin CRMOptionMapping.AssertCRMOptionIdCanBeMapped(RecordID, CRMOptionId); CRMOptionMapping."Option Value" := CRMOptionId; CRMOptionMapping."Option Value Caption" := CRMOptionValue; CRMOptionMapping.Modify(true); end; end; procedure GetMappedCRMOptionId(RecordID: RecordID; var CRMOptionId: Integer): Boolean var CRMOptionMapping: Record "CRM Option Mapping"; Found: Boolean; begin CRMOptionMapping.SetRange("Record ID", RecordId); if CRMOptionMapping.FindFirst() then begin CRMOptionId := CRMOptionMapping."Option Value"; Found := true; end; exit(Found); end; local procedure MatchBasedCoupling(var LocalRecordRef: RecordRef; CouplingOption: Option None,Background,Foreground) var IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationFieldMapping: Record "Integration Field Mapping"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; CoupledToCRMFieldRef: FieldRef; begin if IsCRMTable(LocalRecordRef.Number()) then begin Session.LogMessage('0000EZP', StrSubstNo(NotLocalTableTxt, GetTableCaption(LocalRecordRef.Number())), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; OnMatchBasedCouplingOnBeforeGetIntegrationTableMappingForMatchBasedCoupling(IntegrationTableMapping, LocalRecordRef); if GetIntegrationTableMappingForCoupling(IntegrationTableMapping, LocalRecordRef.Number()) then begin IntegrationFieldMapping.SetMatchBasedCouplingFilters(IntegrationTableMapping); if Page.RunModal(Page::"Match Based Coupling Criteria", IntegrationFieldMapping) = Action::LookupOK then if CouplingOption in [CouplingOption::Background, CouplingOption::Foreground] then begin if FindCoupledToCRMField(LocalRecordRef, CoupledToCRMFieldRef) then CoupledToCRMFieldRef.SetRange(false); if CouplingOption = CouplingOption::Background then ScheduleCoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForLocalRecords(LocalRecordRef), false) else PerformCoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForLocalRecords(LocalRecordRef), false); end; end; end; internal procedure RemoveCoupling(LocalTableID: Integer; IntegrationTableID: Integer; var IntegrationIdList: List of [Guid]; Schedule: Boolean) var IntegrationTableMapping: Record "Integration Table Mapping"; begin if IntegrationIdList.Count() = 0 then exit; if GetIntegrationTableMappingForUncoupling(IntegrationTableMapping, LocalTableID) then begin if Schedule then ScheduleUncoupling(IntegrationTableMapping, '', GetTableViewForCRMIDs(IntegrationTableID, IntegrationTableMapping."Integration Table UID Fld. No.", IntegrationIdList)) else PerformUncoupling(IntegrationTableMapping, '', GetTableViewForCRMIDs(IntegrationTableID, IntegrationTableMapping."Integration Table UID Fld. No.", IntegrationIdList)) end else RemoveCouplingToRecord(LocalTableID, IntegrationIdList); end; local procedure RemoveCouplingToRecord(var LocalRecordRef: RecordRef) var CRMIntegrationRecord: Record "CRM Integration Record"; begin if LocalRecordRef.FindSet() then repeat CRMIntegrationRecord.RemoveCouplingToRecord(LocalRecordRef.RecordId()); until LocalRecordRef.Next() = 0; end; local procedure RemoveCouplingToRecord(LocalTableID: Integer; var CRMIDList: List of [Guid]) var CRMIntegrationRecord: Record "CRM Integration Record"; CRMID: Guid; begin foreach CRMID in CRMIDList do CRMIntegrationRecord.RemoveCouplingToCRMID(CRMID, LocalTableID); end; procedure RemoveCoupling(RecordID: RecordID) begin RemoveCoupling(RecordID, true); end; internal procedure RemoveCoupling(RecordID: RecordID; Schedule: Boolean): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin if IsCRMTable(RecordID.TableNo()) then begin Session.LogMessage('0000DHV', StrSubstNo(NotLocalTableTxt, GetTableCaption(RecordID.TableNo())), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit(false); end; if not GetIntegrationTableMappingForUncoupling(IntegrationTableMapping, RecordID.TableNo()) then exit(CRMIntegrationRecord.RemoveCouplingToRecord(RecordID)); if Schedule then exit(ScheduleUncoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForRecordID(RecordID), '')); exit(PerformUncoupling(IntegrationTableMapping, IntegrationRecordSynch.GetTableViewForRecordID(RecordID), '')); end; procedure RemoveCoupling(TableID: Integer; CRMTableID: Integer; CRMID: Guid) begin RemoveCoupling(TableID, CRMTableID, CRMID, true); end; internal procedure RemoveCoupling(TableID: Integer; CRMTableID: Integer; CRMID: Guid; Schedule: Boolean): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; begin if not GetIntegrationTableMappingForUncoupling(IntegrationTableMapping, TableID, CRMTableID) then exit(CRMIntegrationRecord.RemoveCouplingToCRMID(CRMID, TableID)); if Schedule then exit(ScheduleUncoupling(IntegrationTableMapping, '', GetTableViewForGuid(CRMTableID, IntegrationTableMapping."Integration Table UID Fld. No.", CRMID))); exit(PerformUncoupling(IntegrationTableMapping, '', GetTableViewForGuid(CRMTableID, IntegrationTableMapping."Integration Table UID Fld. No.", CRMID))); end; local procedure ScheduleUncoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IntegrationTableFilter: Text): Boolean var RecordCounter: array[4] of Integer; Scheduled: Boolean; begin RecordCounter[NoOf::Total] := 1; Scheduled := EnqueueUncoupleJob(IntegrationTableMapping, LocalTableFilter, IntegrationTableFilter); if Scheduled then RecordCounter[NoOf::Scheduled] += 1 else RecordCounter[NoOf::Failed] += 1; SendUncoupleNotification(RecordCounter); exit(Scheduled); end; local procedure ScheduleCoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IsFullSync: Boolean): Boolean var RecordCounter: array[4] of Integer; Scheduled: Boolean; begin IntegrationTableMapping.Find(); RecordCounter[NoOf::Total] := 1; Scheduled := EnqueueCouplingJob(IntegrationTableMapping, LocalTableFilter, IsFullSync); if Scheduled then RecordCounter[NoOf::Scheduled] += 1 else RecordCounter[NoOf::Failed] += 1; SendCouplingNotification(RecordCounter); exit(Scheduled); end; local procedure PerformCoupling(IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IsFullSync: Boolean): Boolean var CDSIntTableCouple: Codeunit "CDS Int. Table Couple"; begin IntegrationTableMapping.Find(); if LocalTableFilter <> '' then IntegrationTableMapping.SetTableFilter(LocalTableFilter) else IntegrationTableMapping.CalcFields("Table Filter"); IntegrationTableMapping.CalcFields("Integration Table Filter"); IntegrationTableMapping."Full Sync is Running" := IsFullSync; AddIntegrationTableMapping(IntegrationTableMapping, true); CDSIntTableCouple.PerformScheduledCoupling(IntegrationTableMapping); IntegrationTableMapping.Delete(true); end; local procedure PerformUncoupling(IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IntegrationTableFilter: Text): Boolean var LocalRecordRef: RecordRef; IntegrationRecordRef: RecordRef; CountFailed: Integer; begin AddIntegrationTableMapping(IntegrationTableMapping); IntegrationTableMapping.SetTableFilter(LocalTableFilter); IntegrationTableMapping.SetIntegrationTableFilter(IntegrationTableFilter); if LocalTableFilter <> '' then begin LocalRecordRef.Open(IntegrationTableMapping."Table ID"); LocalRecordRef.SetView(LocalTableFilter); if LocalRecordRef.FindSet() then repeat if not PerformUncoupling(IntegrationTableMapping, LocalRecordRef, IntegrationRecordRef) then CountFailed += 1; until LocalRecordRef.Next() = 0 end else begin IntegrationRecordRef.Open(IntegrationTableMapping."Integration Table ID"); IntegrationRecordRef.SetView(IntegrationTableFilter); if IntegrationRecordRef.FindSet() then repeat if not PerformUncoupling(IntegrationTableMapping, LocalRecordRef, IntegrationRecordRef) then CountFailed += 1; until IntegrationRecordRef.Next() = 0; end; IntegrationTableMapping.Delete(true); exit(CountFailed = 0); end; local procedure PerformUncoupling(IntegrationTableMapping: Record "Integration Table Mapping"; LocalRecordRef: RecordRef; IntegrationRecordRef: RecordRef): Boolean var IntRecUncoupleInvoke: Codeunit "Int. Rec. Uncouple Invoke"; SynchAction: Option "None",Insert,Modify,ForceModify,IgnoreUnchanged,Fail,Skip,Delete,Uncouple,Couple; LocalRecordModified: Boolean; IntegrationRecordModified: Boolean; JobId: Guid; begin SynchAction := SynchAction::Uncouple; IntRecUncoupleInvoke.SetContext(IntegrationTableMapping, LocalRecordRef, IntegrationRecordRef, SynchAction, LocalRecordModified, IntegrationRecordModified, JobId, TableConnectionType::CRM); IntRecUncoupleInvoke.Run(); IntRecUncoupleInvoke.GetContext(IntegrationTableMapping, LocalRecordRef, IntegrationRecordRef, SynchAction, LocalRecordModified, IntegrationRecordModified); exit(SynchAction <> SynchAction::Fail); end; local procedure GetIntegrationTableMappingForUncoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer; CRMTableID: Integer): Boolean begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Uncouple Codeunit ID", Codeunit::"CDS Int. Table Uncouple"); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Table ID", TableID); IntegrationTableMapping.SetRange("Integration Table ID", CRMTableID); exit(IntegrationTableMapping.FindFirst()); end; local procedure GetIntegrationTableMappingForUncoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer): Boolean begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Uncouple Codeunit ID", Codeunit::"CDS Int. Table Uncouple"); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Table ID", TableID); exit(IntegrationTableMapping.FindFirst()); end; local procedure GetIntegrationTableMappingForCoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer): Boolean begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetFilter("Coupling Codeunit ID", '%1|%2', Codeunit::"CDS Int. Table Couple", Codeunit::"CDS Int. Option Couple"); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Table ID", TableID); exit(IntegrationTableMapping.FindFirst()); end; procedure GetIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; RecId: RecordId) var TableId: Integer; begin TableId := RecId.TableNo(); OnBeforeGetIntegrationTableMappingWithRecordId(IntegrationTableMapping, RecId, TableId); GetIntegrationTableMapping(IntegrationTableMapping, TableId); end; procedure GetIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer) begin OnBeforeGetIntegrationTableMapping(IntegrationTableMapping, TableId); IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Synch. Codeunit ID", CODEUNIT::"CRM Integration Table Synch."); IntegrationTableMapping.SetRange("Delete After Synchronization", false); if IsCRMTable(TableID) then IntegrationTableMapping.SetRange("Integration Table ID", TableID) else IntegrationTableMapping.SetRange("Table ID", TableID); if not IntegrationTableMapping.FindFirst() then Error(IntegrationTableMappingNotFoundErr, IntegrationTableMapping.TableCaption(), GetTableCaption(TableID)); end; local procedure GetIntegrationTableMappingFromCRMRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef) var CRMAccount: Record "CRM Account"; CustomerTypeCodeFieldRef: FieldRef; CustomerTypeCode: Text; begin OnBeforeGetIntegrationTableMappingFromCRMRecord(IntegrationTableMapping, RecRef); if RecRef.Number <> Database::"CRM Account" then begin GetIntegrationTableMapping(IntegrationTableMapping, RecRef.RecordId()); exit; end; CustomerTypeCodeFieldRef := RecRef.Field(CRMAccount.FieldNo(CustomerTypeCode)); Evaluate(CustomerTypeCode, Format(CustomerTypeCodeFieldRef.Value)); IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Synch. Codeunit ID", CODEUNIT::"CRM Integration Table Synch."); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Integration Table ID", RecRef.Number); if CustomerTypeCode = Format(CRMAccount.CustomerTypeCode::Customer) then IntegrationTableMapping.SetRange("Table ID", Database::Customer) else if CustomerTypeCode = Format(CRMAccount.CustomerTypeCode::Vendor) then IntegrationTableMapping.SetRange("Table ID", Database::Vendor); OnAfterGetIntegrationTableMappingFromCRMRecordBeforeFindRecord(IntegrationTableMapping, RecRef); if not IntegrationTableMapping.FindFirst() then Error(IntegrationTableMappingNotFoundErr, IntegrationTableMapping.TableCaption(), GetTableCaption(RecRef.Number)); end; local procedure GetIntegrationTableMappingFromCRMOption(var IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef) var TableId: Integer; begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Synch. Codeunit ID", Codeunit::"CRM Integration Table Synch."); IntegrationTableMapping.SetRange("Delete After Synchronization", false); case RecRef.Number of Database::"CRM Payment Terms": TableId := Database::"Payment Terms"; Database::"CRM Freight Terms": TableId := Database::"Shipment Method"; Database::"CRM Shipping Method": TableId := Database::"Shipping Agent"; end; OnGetTableIdFromCRMOption(RecRef, TableId); IntegrationTableMapping.SetRange("Table ID", TableId); if not IntegrationTableMapping.FindFirst() then Error(IntegrationTableMappingNotFoundErr, IntegrationTableMapping.TableCaption(), GetTableCaption(TableID)); end; local procedure GetTableCaption(TableID: Integer): Text var TableMetadata: Record "Table Metadata"; begin if TableMetadata.Get(TableID) then exit(TableMetadata.Caption); exit(''); end; procedure IsCRMTable(TableID: Integer): Boolean var TableMetadata: Record "Table Metadata"; CRMTable: Boolean; Handled: Boolean; begin OnIsCRMTable(TableID, CRMTable, Handled); if Handled then exit(CRMTable); if TableID in [Database::"CRM Payment Terms", Database::"CRM Freight Terms", Database::"CRM Shipping Method"] then exit(true); if TableMetadata.Get(TableID) then exit(TableMetadata.TableType = TableMetadata.TableType::CRM); end; local procedure IsRecordSkipped(RecID: RecordID): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; begin if CRMIntegrationRecord.FindByRecordID(RecID) then exit(CRMIntegrationRecord.Skipped); end; local procedure JoinIntegers(var IdList: List of [Integer]; Delimiter: Text[1]): Text var IdValue: Integer; IdFilter: Text; begin foreach IdValue in IdList do IdFilter += Delimiter + Format(IdValue); IdFilter := IdFilter.TrimStart(Delimiter); exit(IdFilter); end; procedure EnqueueFullSyncJob(Name: Code[20]): Guid var IntegrationTableMapping: Record "Integration Table Mapping"; JobQueueEntry: Record "Job Queue Entry"; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; begin IntegrationTableMapping.Get(Name); IntegrationTableMapping."Full Sync is Running" := true; IntegrationTableMapping.CalcFields("Table Filter", "Integration Table Filter"); AddIntegrationTableMapping(IntegrationTableMapping); Commit(); if CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping) then begin JobQueueEntry.SetRange("Record ID to Process", IntegrationTableMapping.RecordId()); if JobQueueEntry.FindFirst() then exit(JobQueueEntry.ID); end; end; procedure EnqueueSyncJob(IntegrationTableMapping: Record "Integration Table Mapping"; RecordID: RecordID; CRMID: Guid; Direction: Integer): Boolean var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin IntegrationTableMapping.Direction := Direction; if Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::FromIntegrationTable] then IntegrationTableMapping.SetIntegrationTableFilter(GetTableViewForGuid(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMID)); if Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::ToIntegrationTable] then IntegrationTableMapping.SetTableFilter(IntegrationRecordSynch.GetTableViewForRecordIDAndFlowFilters(IntegrationTableMapping, RecordID)); AddIntegrationTableMapping(IntegrationTableMapping); Commit(); exit(CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping)); end; procedure EnqueueSyncJob(IntegrationTableMapping: Record "Integration Table Mapping"; SystemIds: List of [Guid]; CRMIDs: List of [Guid]; Direction: Integer; SynchronizeOnlyCoupledRecords: Boolean): Boolean var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; IntegrationRecordSynch: Codeunit "Integration Record Synch."; begin IntegrationTableMapping.Direction := Direction; if Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::FromIntegrationTable] then IntegrationTableMapping.SetIntegrationTableFilter(GetTableViewForCRMIds(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMIDs)); if Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::ToIntegrationTable] then IntegrationTableMapping.SetTableFilter(IntegrationRecordSynch.GetTableViewForSystemIds(IntegrationTableMapping."Table ID", SystemIds)); AddIntegrationTableMapping(IntegrationTableMapping, SynchronizeOnlyCoupledRecords); Commit(); exit(CRMSetupDefaults.CreateJobQueueEntry(IntegrationTableMapping)); end; local procedure EnqueueUncoupleJob(IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IntegrationTableFilter: Text): Boolean var CDSSetupDefaults: Codeunit "CDS Setup Defaults"; begin IntegrationTableMapping.SetTableFilter(LocalTableFilter); IntegrationTableMapping.SetIntegrationTableFilter(IntegrationTableFilter); AddIntegrationTableMapping(IntegrationTableMapping); Commit(); exit(CDSSetupDefaults.CreateUncoupleJobQueueEntry(IntegrationTableMapping)); end; local procedure EnqueueCouplingJob(IntegrationTableMapping: Record "Integration Table Mapping"; LocalTableFilter: Text; IsFullSync: Boolean): Boolean var CDSSetupDefaults: Codeunit "CDS Setup Defaults"; begin if LocalTableFilter <> '' then IntegrationTableMapping.SetTableFilter(LocalTableFilter) else IntegrationTableMapping.CalcFields("Table Filter"); IntegrationTableMapping.CalcFields("Integration Table Filter"); IntegrationTableMapping."Full Sync is Running" := IsFullSync; AddIntegrationTableMapping(IntegrationTableMapping, true); Commit(); exit(CDSSetupDefaults.CreateCoupleJobQueueEntry(IntegrationTableMapping)); end; procedure AddIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping") begin AddIntegrationTableMapping(IntegrationTableMapping, false); end; procedure AddIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; SynchOnlyCoupledRecords: Boolean) var SourceIntegrationTableMapping: Record "Integration Table Mapping"; SourceMappingName: Code[20]; begin SourceMappingName := IntegrationTableMapping.GetName(); IntegrationTableMapping.Name := CopyStr(DelChr(Format(CreateGuid()), '=', '{}-'), 1, MaxStrLen(IntegrationTableMapping.Name)); IntegrationTableMapping."Synch. Only Coupled Records" := SynchOnlyCoupledRecords; IntegrationTableMapping."Delete After Synchronization" := true; IntegrationTableMapping."Parent Name" := SourceMappingName; SourceIntegrationTableMapping.Get(IntegrationTableMapping."Parent Name"); IntegrationTableMapping."Update-Conflict Resolution" := SourceIntegrationTableMapping."Update-Conflict Resolution"; IntegrationTableMapping."Deletion-Conflict Resolution" := SourceIntegrationTableMapping."Deletion-Conflict Resolution"; Clear(IntegrationTableMapping."Synch. Modified On Filter"); Clear(IntegrationTableMapping."Synch. Int. Tbl. Mod. On Fltr."); Clear(IntegrationTableMapping."Last Full Sync Start DateTime"); IntegrationTableMapping.Insert(); CloneIntegrationFieldMapping(SourceMappingName, IntegrationTableMapping.Name); end; procedure CloneIntegrationFieldMapping(SourceMappingName: Code[20]; DestinationMappingName: Code[20]) var IntegrationFieldMapping: Record "Integration Field Mapping"; NewIntegrationFieldMapping: Record "Integration Field Mapping"; begin IntegrationFieldMapping.SetRange("Integration Table Mapping Name", SourceMappingName); if IntegrationFieldMapping.FindSet() then repeat NewIntegrationFieldMapping := IntegrationFieldMapping; NewIntegrationFieldMapping."No." := 0; // Autoincrement NewIntegrationFieldMapping."Integration Table Mapping Name" := DestinationMappingName; NewIntegrationFieldMapping.Insert(); until IntegrationFieldMapping.Next() = 0; end; local procedure GetTableViewForGuid(TableNo: Integer; IdFiledNo: Integer; CRMId: Guid) View: Text var RecordRef: RecordRef; FieldRef: FieldRef; begin RecordRef.Open(TableNo); FieldRef := RecordRef.Field(IdFiledNo); FieldRef.SetRange(CRMId); View := RecordRef.GetView(); RecordRef.Close(); end; local procedure GetTableViewForCRMIDs(TableNo: Integer; IdFiledNo: Integer; CRMIds: List of [Guid]) View: Text var IntegrationRecordSynch: Codeunit "Integration Record Synch."; RecordRef: RecordRef; FieldRef: FieldRef; CRMIdFilter: Text; begin CRMIdFilter := IntegrationRecordSynch.JoinIDs(CRMIds, '|'); RecordRef.Open(TableNo); FieldRef := RecordRef.Field(IdFiledNo); FieldRef.SetFilter(CRMIdFilter); View := RecordRef.GetView(); RecordRef.Close(); end; local procedure GetTableViewForCRMOptionIds(TableNo: Integer; OptionIdFieldNo: Integer; CRMOptionIds: List of [Integer]) View: Text var RecordRef: RecordRef; FieldRef: FieldRef; CRMOptionIdFilter: Text; begin CRMOptionIdFilter := JoinIntegers(CRMOptionIds, '|'); RecordRef.Open(TableNo); FieldRef := RecordRef.Field(OptionIdFieldNo); FieldRef.SetFilter(CRMOptionIdFilter); View := RecordRef.GetView(false); RecordRef.Close(); end; local procedure GetTableViewForCRMOptionId(TableNo: Integer; OptionIdFieldNo: Integer; CRMOptionId: Integer) View: Text var RecordRef: RecordRef; FieldRef: FieldRef; begin RecordRef.Open(TableNo); FieldRef := RecordRef.Field(OptionIdFieldNo); FieldRef.SetRange(CRMOptionId); View := RecordRef.GetView(false); RecordRef.Close(); end; procedure CreateOrUpdateCRMAccountStatistics(Customer: Record Customer) var CRMAccount: Record "CRM Account"; CRMStatisticsJob: Codeunit "CRM Statistics Job"; CRMID: Guid; begin if not GetCoupledCRMID(Customer.RecordId, CRMID) then exit; CRMAccount.Get(CRMID); CRMStatisticsJob.CreateOrUpdateCRMAccountStatistics(Customer, CRMAccount); CRMStatisticsJob.UpdateStatusOfPaidInvoices(Customer."No."); Message(StrSubstNo(AccountStatisticsUpdatedMsg, CRMProductName.CDSServiceName())); end; procedure ShowCRMEntityFromRecordID(RecordID: RecordID) var CRMID: Guid; begin if not DefineCouplingIfNotCoupled(RecordID, CRMID) then exit; HyperLink(GetCRMEntityUrlFromRecordID(RecordID)); end; procedure GetCRMEntityUrlFromRecordID(TargetRecordID: RecordID): Text var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; CRMId: Guid; begin if not CRMIntegrationRecord.FindIDFromRecordID(TargetRecordID, CRMId) then Error(CouplingNotFoundErr, CRMProductName.CDSServiceName()); CRMIntegrationManagement.GetIntegrationTableMapping(IntegrationTableMapping, TargetRecordID); exit(GetCRMEntityUrlFromCRMID(IntegrationTableMapping."Table ID", IntegrationTableMapping."Integration Table ID", CRMId)); end; procedure GetCRMEntityUrlFromCRMID(TableId: Integer; CRMId: Guid): Text var CRMTableId: Integer; begin if IsCRMTable(TableId) then begin CRMTableId := TableId; TableId := 0; end; exit(GetCRMEntityUrlFromCRMID(TableId, CRMTableId, CRMId)); end; procedure GetCRMEntityUrlFromCRMID(TableId: Integer; CRMTableId: Integer; CRMId: Guid): Text var CRMConnectionSetup: Record "CRM Connection Setup"; CRMEntityUrl: Text; CDSServerAddress: Text; IsHandled: Boolean; begin OnGetCDSServerAddress(CDSServerAddress, IsHandled); if IsHandled then CRMEntityUrl := StrSubstNo(CRMEntityUrlTemplateTxt, CDSServerAddress, GetCRMEntityTypeName(TableId, CRMTableId), CRMId) else begin CRMConnectionSetup.Get(); CRMEntityUrl := StrSubstNo(CRMEntityUrlTemplateTxt, CRMConnectionSetup."Server Address", GetCRMEntityTypeName(TableId, CRMTableId), CRMId); if CRMConnectionSetup."Use Newest UI" and (CRMConnectionSetup."Newest UI AppModuleId" <> '') then CRMEntityUrl += StrSubstNo(NewestUIAppIdParameterTxt, CRMConnectionSetup."Newest UI AppModuleId") end; OnAfterGetCRMEntityUrlFromCRMID(CRMEntityUrlTemplateTxt, NewestUIAppIdParameterTxt, TableId, CRMId, CRMEntityUrl, CRMTableId); exit(CRMEntityUrl); end; procedure OpenCoupledNavRecordPage(CRMID: Guid; CRMEntityTypeName: Text): Boolean var IntegrationTableMapping: Record "Integration Table Mapping"; TempNameValueBuffer: Record "Name/Value Buffer" temporary; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; RecordId: RecordId; BCTableId: Integer; IsHandled, Result : Boolean; begin IsHandled := false; OnBeforeOpenCoupledNavRecordPage(CRMID, CRMEntityTypeName, Result, IsHandled); if IsHandled then exit(Result); // Find the corresponding NAV record and type CRMSetupDefaults.GetTableIDCRMEntityNameMapping(TempNameValueBuffer); TempNameValueBuffer.SetCurrentKey(Name); TempNameValueBuffer.SetRange(Name, LowerCase(CRMEntityTypeName)); if TempNameValueBuffer.IsEmpty() then exit(false); FindRecordFromNameValueBuffer(TempNameValueBuffer, CRMID, RecordId, BCTableId, CRMEntityTypeName); if RecordId.TableNo = 0 then begin GetIntegrationTableMappingFromCRMID(IntegrationTableMapping, BcTableId, CRMID); if (IntegrationTableMapping.Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::FromIntegrationTable]) and (IntegrationTableMapping."Synch. Only Coupled Records" = false) then SynchFromIntegrationTable(IntegrationTableMapping, CRMID) else exit(false); end; FindRecordFromNameValueBuffer(TempNameValueBuffer, CRMID, RecordId, BCTableId, CRMEntityTypeName); if RecordId.TableNo = 0 then exit(false); OpenRecordCardPage(RecordID); exit(true); end; local procedure FindRecordFromNameValueBuffer(var TempNameValueBuffer: Record "Name/Value Buffer" temporary; CRMID: Guid; var RecordId: RecordId; var BCTableId: Integer; CRMEntityTypeName: Text) var CRMIntegrationRecord: Record "CRM Integration Record"; TableId: Integer; begin TempNameValueBuffer.SetCurrentKey(Name); TempNameValueBuffer.SetRange(Name, LowerCase(CRMEntityTypeName)); if TempNameValueBuffer.FindSet() then repeat Evaluate(TableId, TempNameValueBuffer.Value); if not IsCRMTable(TableId) then BCTableId := TableId; if CRMIntegrationRecord.FindRecordIDFromID(CRMID, TableId, RecordId) then break; until TempNameValueBuffer.Next() = 0; end; local procedure SynchFromIntegrationTable(IntegrationTableMapping: Record "Integration Table Mapping"; CRMID: Guid) var CRMRecordRef: RecordRef; CRMFieldRef: FieldRef; CRMTableView: Text; begin CRMRecordRef.Open(IntegrationTableMapping."Integration Table ID"); CRMRecordRef.SetView(IntegrationTableMapping.GetIntegrationTableFilter()); CRMFieldRef := CRMRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No."); CRMFieldRef.SetRange(CRMID); CRMTableView := CRMRecordRef.GetView(); CRMRecordRef.Close(); IntegrationTableMapping.SetIntegrationTableFilter(CRMTableView); IntegrationTableMapping.Direction := IntegrationTableMapping.Direction::FromIntegrationTable; AddIntegrationTableMapping(IntegrationTableMapping); Commit(); Codeunit.Run(IntegrationTableMapping."Synch. Codeunit ID", IntegrationTableMapping); IntegrationTableMapping.Delete(true); Commit(); end; local procedure OpenRecordCardPage(RecordID: RecordID) var Customer: Record Customer; Vendor: Record Vendor; Contact: Record Contact; Currency: Record Currency; SalespersonPurchaser: Record "Salesperson/Purchaser"; UnitOfMeasure: Record "Unit of Measure"; Item: Record Item; Resource: Record Resource; SalesInvoiceHeader: Record "Sales Invoice Header"; CustomerPriceGroup: Record "Customer Price Group"; PageManagement: Codeunit "Page Management"; RecordRef: RecordRef; IsHandled: Boolean; begin // Open the right kind of card page OnBeforeOpenRecordCardPage(RecordID, IsHandled); if IsHandled then exit; RecordRef := RecordID.GetRecord(); case RecordID.TableNo of DATABASE::Contact: begin RecordRef.SetTable(Contact); PAGE.Run(PAGE::"Contact Card", Contact); end; DATABASE::Currency: begin RecordRef.SetTable(Currency); PAGE.Run(PAGE::"Currency Card", Currency); end; DATABASE::Customer: begin RecordRef.SetTable(Customer); PAGE.Run(PAGE::"Customer Card", Customer); end; DATABASE::Vendor: begin RecordRef.SetTable(Vendor); PAGE.Run(PAGE::"Vendor Card", Vendor); end; DATABASE::Item: begin RecordRef.SetTable(Item); PAGE.Run(PAGE::"Item Card", Item); end; DATABASE::"Sales Invoice Header": begin RecordRef.SetTable(SalesInvoiceHeader); PageManagement.PageRun(SalesInvoiceHeader); end; DATABASE::Resource: begin RecordRef.SetTable(Resource); PAGE.Run(PAGE::"Resource Card", Resource); end; DATABASE::"Salesperson/Purchaser": begin RecordRef.SetTable(SalespersonPurchaser); PAGE.Run(PAGE::"Salesperson/Purchaser Card", SalespersonPurchaser); end; DATABASE::"Unit of Measure": begin RecordRef.SetTable(UnitOfMeasure); // There is no Unit of Measure card. Open the list, filtered down to this instance. PAGE.Run(PAGE::"Units of Measure", UnitOfMeasure); end; DATABASE::"Customer Price Group": begin RecordRef.SetTable(CustomerPriceGroup); // There is no Customer Price Group card. Open the list, filtered down to this instance. PAGE.Run(PAGE::"Customer Price Groups", CustomerPriceGroup); end; else Error(NoCardPageActionDefinedForTableIdErr, RecordID.TableNo); end; end; procedure GetCRMEntityTypeName(TableId: Integer): Text var CRMTableId: Integer; begin if IsCRMTable(TableId) then begin CRMTableId := TableId; TableId := 0; end; exit(GetCRMEntityTypeName(TableId, CRMTableId)); end; procedure GetCRMEntityTypeName(TableId: Integer; CRMTableId: Integer): Text var TempNameValueBuffer: Record "Name/Value Buffer" temporary; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; begin CRMSetupDefaults.GetTableIDCRMEntityNameMapping(TempNameValueBuffer); if CRMTableId <> 0 then begin TempNameValueBuffer.SetRange(Value, Format(CRMTableId)); if TempNameValueBuffer.FindFirst() then exit(TempNameValueBuffer.Name); end; if TableId <> 0 then begin TempNameValueBuffer.SetRange(Value, Format(TableId)); if TempNameValueBuffer.FindFirst() then exit(TempNameValueBuffer.Name); end; Error(UnableToResolveCRMEntityNameFrmTableIDErr, TableId, CRMProductName.CDSServiceName()); end; local procedure GetCoupledCRMID(RecordID: RecordID; var CRMID: Guid): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; begin exit(CRMIntegrationRecord.FindIDFromRecordID(RecordID, CRMID)) end; local procedure DefineCouplingIfNotCoupled(RecordID: RecordID; var CRMID: Guid): Boolean var RecordRef: RecordRef; begin if GetCoupledCRMID(RecordID, CRMID) then exit(true); RecordRef.Open(RecordID.TableNo); if Confirm(StrSubstNo(ManageCouplingQst, RecordRef.Caption, CRMProductName.CDSServiceName()), false) then if DefineCoupling(RecordID) then exit(GetCoupledCRMID(RecordID, CRMID)); exit(false); end; procedure DefineCoupling(RecordID: RecordID): Boolean var CRMCouplingManagement: Codeunit "CRM Coupling Management"; CreateNew: Boolean; Synchronize: Boolean; Direction: Option; CRMID: Guid; begin if CRMCouplingManagement.DefineCoupling(RecordID, CRMID, CreateNew, Synchronize, Direction) then begin if CreateNew then CreateNewRecordsInCRM(RecordID) else if Synchronize then PerformInitialSynchronization(RecordID, CRMID, Direction); exit(true); end; exit(false); end; local procedure DefineOptionMappingIfNotMapped(RecordID: RecordID; var CRMOptionId: Integer): Boolean var RecordRef: RecordRef; begin RecordRef.Open(RecordID.TableNo); if Confirm(StrSubstNo(ManageCouplingQst, RecordRef.Caption, CRMProductName.CDSServiceName()), false) then if DefineOptionMapping(RecordID) then exit(GetMappedCRMOptionId(RecordID, CRMOptionId)); exit(false); end; procedure DefineOptionMapping(RecordID: RecordID): Boolean var CRMCouplingManagement: Codeunit "CRM Coupling Management"; CreateNew: Boolean; Synchronize: Boolean; Direction: Option; CRMOptionId: Integer; begin if CRMCouplingManagement.DefineOptionMapping(RecordID, CRMOptionId, CreateNew, Synchronize, Direction) then begin if CreateNew then CreateNewOptionsInCRM(RecordID) else if Synchronize then PerformInitialOptionSynchronization(RecordID, CRMOptionId, Direction); exit(true); end; exit(false); end; procedure ManageCreateNewRecordFromCRM(TableID: Integer) begin // Extinct method. Kept for backward compatibility. case TableID of DATABASE::Contact: CreateNewContactFromCRM(); DATABASE::Customer: CreateNewCustomerFromCRM(); end; end; procedure CreateNewContactFromCRM() var IntegrationTableMapping: Record "Integration Table Mapping"; begin GetIntegrationTableMapping(IntegrationTableMapping, DATABASE::Contact); PAGE.RunModal(PAGE::"CRM Contact List"); end; procedure CreateNewCustomerFromCRM() var IntegrationTableMapping: Record "Integration Table Mapping"; begin GetIntegrationTableMapping(IntegrationTableMapping, DATABASE::Customer); PAGE.RunModal(PAGE::"CRM Account List"); end; procedure CreateNewVendorFromCRM() var IntegrationTableMapping: Record "Integration Table Mapping"; begin GetIntegrationTableMapping(IntegrationTableMapping, DATABASE::Vendor); PAGE.RunModal(PAGE::"CRM Account List"); end; [Scope('OnPrem')] procedure ShowCustomerCRMOpportunities(Customer: Record Customer) var CRMOpportunity: Record "CRM Opportunity"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit; if not DefineCouplingIfNotCoupled(Customer.RecordId, CRMID) then exit; CRMOpportunity.FilterGroup := 2; CRMOpportunity.SetRange(ParentAccountId, CRMID); CRMOpportunity.SetRange(StateCode, CRMOpportunity.StateCode::Open); CRMOpportunity.FilterGroup := 0; PAGE.Run(PAGE::"CRM Opportunity List", CRMOpportunity); end; [Scope('OnPrem')] procedure ShowCustomerCRMQuotes(Customer: Record Customer) var CRMQuote: Record "CRM Quote"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit; if not DefineCouplingIfNotCoupled(Customer.RecordId, CRMID) then exit; CRMQuote.FilterGroup := 2; CRMQuote.SetRange(CustomerId, CRMID); CRMQuote.SetRange(StateCode, CRMQuote.StateCode::Active); CRMQuote.FilterGroup := 0; PAGE.Run(PAGE::"CRM Sales Quote List", CRMQuote); end; [Scope('OnPrem')] procedure ShowCustomerCRMCases(Customer: Record Customer) var CRMIncident: Record "CRM Incident"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit; if not DefineCouplingIfNotCoupled(Customer.RecordId, CRMID) then exit; CRMIncident.FilterGroup := 2; CRMIncident.SetRange(CustomerId, CRMID); CRMIncident.SetRange(StateCode, CRMIncident.StateCode::Active); CRMIncident.FilterGroup := 2; PAGE.Run(PAGE::"CRM Case List", CRMIncident); end; [Scope('OnPrem')] procedure ResetIntTableMappingDefaultConfiguration(var IntegrationTableMapping: Record "Integration Table Mapping") var CDSConnectionSetup: Record "CDS Connection Setup"; CRMConnectionSetup: Record "CRM Connection Setup"; CDSSetupDefaults: Codeunit "CDS Setup Defaults"; CRMSetupDefaults: Codeunit "CRM Setup Defaults"; CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; EnqueueJobQueEntries: Boolean; IsTeamOwnershipModel: Boolean; IsHandled: Boolean; begin Codeunit.Run(Codeunit::"CRM Integration Management"); if CRMConnectionSetup.Get() then EnqueueJobQueEntries := CRMConnectionSetup.DoReadCRMData() and CRMConnectionSetup.IsEnabled(); IsTeamOwnershipModel := CDSIntegrationMgt.IsTeamOwnershipModelSelected(); if IntegrationTableMapping.FindSet() then repeat case IntegrationTableMapping."Table ID" of Database::"Salesperson/Purchaser": CDSSetupDefaults.ResetSalesPeopleSystemUserMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, true); Database::Customer: CDSSetupDefaults.ResetCustomerAccountMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, true); Database::Vendor: CDSSetupDefaults.ResetVendorAccountMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, true); Database::Contact: CDSSetupDefaults.ResetContactContactMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, true); Database::Currency: CDSSetupDefaults.ResetCurrencyTransactionCurrencyMapping(IntegrationTableMapping.Name, true); Database::"Payment Terms": CDSSetupDefaults.ResetPaymentTermsMapping(IntegrationTableMapping.Name); Database::"Shipment Method": CDSSetupDefaults.ResetShipmentMethodMapping(IntegrationTableMapping.Name); Database::"Shipping Agent": CDSSetupDefaults.ResetShippingAgentMapping(IntegrationTableMapping.Name); Database::"Unit of Measure": CRMSetupDefaults.ResetUnitOfMeasureUoMScheduleMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::"Unit Group": CRMSetupDefaults.ResetUnitGroupUoMScheduleMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::"Item Unit of Measure": CRMSetupDefaults.ResetItemUnitOfMeasureUoMMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::"Resource Unit of Measure": CRMSetupDefaults.ResetResourceUnitOfMeasureUoMMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::Item: CRMSetupDefaults.ResetItemProductMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::Resource: if IntegrationTableMapping."Integration Table ID" = Database::"CRM Product" then CRMSetupDefaults.ResetResourceProductMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::"Customer Price Group": CRMSetupDefaults.ResetCustomerPriceGroupPricelevelMapping(IntegrationTableMapping.Name, EnqueueJobQueEntries); Database::"Sales Invoice Header": CRMSetupDefaults.ResetSalesInvoiceHeaderInvoiceMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, EnqueueJobQueEntries); Database::"Sales Invoice Line": CRMSetupDefaults.ResetSalesInvoiceLineInvoiceMapping(IntegrationTableMapping.Name); Database::Opportunity: CRMSetupDefaults.ResetOpportunityMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel); Database::"Sales Header": if CRMConnectionSetup.IsBidirectionalSalesOrderIntEnabled() then begin CRMSetupDefaults.ResetBidirectionalSalesOrderMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, EnqueueJobQueEntries); CRMSetupDefaults.RecreateSalesOrderNotesJobQueueEntry(EnqueueJobQueEntries); CRMSetupDefaults.RecreateArchivedSalesOrdersJobQueueEntry(EnqueueJobQueEntries); end else begin CRMSetupDefaults.ResetSalesOrderMapping(IntegrationTableMapping.Name, IsTeamOwnershipModel, EnqueueJobQueEntries); CRMSetupDefaults.RecreateSalesOrderStatusJobQueueEntry(EnqueueJobQueEntries); CRMSetupDefaults.RecreateSalesOrderNotesJobQueueEntry(EnqueueJobQueEntries); end; Database::"Sales Line": CRMSetupDefaults.ResetBidirectionalSalesOrderLineMapping(IntegrationTableMapping.Name); else begin OnBeforeHandleCustomIntegrationTableMapping(IsHandled, IntegrationTableMapping.Name, IntegrationTableMapping, EnqueueJobQueEntries); if not IsHandled then begin if Confirm(ResetAllCustomIntegrationTableMappingsLbl) then begin if CDSConnectionSetup.Get() then CDSSetupDefaults.SetCustomIntegrationsTableMappings(CDSConnectionSetup); if CRMConnectionSetup.Get() then CRMSetupDefaults.SetCustomIntegrationsTableMappings(CRMConnectionSetup); end; IsHandled := true; end; end; end; AddExtraFieldMappings(IntegrationTableMapping); until IntegrationTableMapping.Next() = 0; end; internal procedure AddExtraFieldMappings(IntegrationTableMapping: Record "Integration Table Mapping") var IntegrationFieldMapping: Record "Integration Field Mapping"; Customer: Record Customer; Vendor: Record Vendor; Contact: Record Contact; SalespersonPurchaser: Record "Salesperson/Purchaser"; Opportunity: Record Opportunity; TempCRMAccount: Record "CRM Account" temporary; TempCRMContact: Record "CRM Contact" temporary; TempCRMSystemUser: Record "CRM Systemuser" temporary; TempCRMOpportunity: Record "CRM Opportunity" temporary; begin case IntegrationTableMapping."Table ID" of Database::Customer: begin if IntegrationTableMapping."Integration Table ID" <> Database::"CRM Account" then exit; AddFieldMapping(IntegrationTableMapping, Customer.FieldNo("No."), TempCRMAccount.FieldNo(AccountNumber), IntegrationFieldMapping.Direction::ToIntegrationTable, false); AddFieldMapping(IntegrationTableMapping, Customer.FieldNo("Mobile Phone No."), TempCRMAccount.FieldNo(Telephone2), IntegrationFieldMapping.Direction::Bidirectional, false); end; Database::Vendor: begin if IntegrationTableMapping."Integration Table ID" <> Database::"CRM Account" then exit; AddFieldMapping(IntegrationTableMapping, Vendor.FieldNo("No."), TempCRMAccount.FieldNo(AccountNumber), IntegrationFieldMapping.Direction::ToIntegrationTable, false); AddFieldMapping(IntegrationTableMapping, Vendor.FieldNo("Mobile Phone No."), TempCRMAccount.FieldNo(Telephone2), IntegrationFieldMapping.Direction::Bidirectional, false); end; Database::Contact: begin if IntegrationTableMapping."Integration Table ID" <> Database::"CRM Contact" then exit; AddFieldMapping(IntegrationTableMapping, Contact.FieldNo("Salutation Code"), TempCRMContact.FieldNo(Salutation), IntegrationFieldMapping.Direction::Bidirectional, false); end; Database::"Salesperson/Purchaser": begin if IntegrationTableMapping."Integration Table ID" <> Database::"CRM Systemuser" then exit; AddFieldMapping(IntegrationTableMapping, SalespersonPurchaser.FieldNo("Job Title"), TempCRMSystemUser.FieldNo(JobTitle), IntegrationFieldMapping.Direction::Bidirectional, false); AddFieldMapping(IntegrationTableMapping, SalespersonPurchaser.FieldNo("E-Mail 2"), TempCRMSystemUser.FieldNo(PersonalEMailAddress), IntegrationFieldMapping.Direction::Bidirectional, false); end; Database::Opportunity: begin if IntegrationTableMapping."Integration Table ID" <> Database::"CRM Opportunity" then exit; AddFieldMapping(IntegrationTableMapping, Opportunity.FieldNo("Date Closed"), TempCRMOpportunity.FieldNo(ActualCloseDate), IntegrationFieldMapping.Direction::ToIntegrationTable, false); AddFieldMapping(IntegrationTableMapping, Opportunity.FieldNo("Probability %"), TempCRMOpportunity.FieldNo(CloseProbability), IntegrationFieldMapping.Direction::ToIntegrationTable, false); AddFieldMapping(IntegrationTableMapping, Opportunity.FieldNo("Calcd. Current Value (LCY)"), TempCRMOpportunity.FieldNo(ActualValue), IntegrationFieldMapping.Direction::ToIntegrationTable, false); end; end; OnAfterAddExtraFieldMappings(IntegrationTableMapping.Name); end; local procedure AddFieldMapping(IntegrationTableMapping: Record "Integration Table Mapping"; FieldNo: Integer; IntegrationTableFieldNo: Integer; Direction: Option; Enabled: Boolean); var IntegrationFieldMapping: Record "Integration Field Mapping"; begin IntegrationFieldMapping.SetRange("Integration Table Mapping Name", IntegrationTableMapping.Name); IntegrationFieldMapping.SetRange("Field No.", FieldNo); if not IntegrationFieldMapping.IsEmpty() then exit; IntegrationFieldMapping.SetRange("Field No."); IntegrationFieldMapping.SetRange("Integration Table Field No.", IntegrationTableFieldNo); if not IntegrationFieldMapping.IsEmpty() then exit; IntegrationFieldMapping.CreateRecord(IntegrationTableMapping.Name, FieldNo, IntegrationTableFieldNo, Direction, '', true, false, Enabled, '', false); end; procedure GetNoOfCRMOpportunities(Customer: Record Customer): Integer var CRMOpportunity: Record "CRM Opportunity"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit(0); if not GetCoupledCRMID(Customer.RecordId, CRMID) then exit(0); CRMOpportunity.SetRange(ParentAccountId, CRMID); CRMOpportunity.SetRange(StateCode, CRMOpportunity.StateCode::Open); exit(CRMOpportunity.Count); end; procedure GetNoOfCRMQuotes(Customer: Record Customer): Integer var CRMQuote: Record "CRM Quote"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit(0); if not GetCoupledCRMID(Customer.RecordId, CRMID) then exit(0); CRMQuote.SetRange(CustomerId, CRMID); CRMQuote.SetRange(StateCode, CRMQuote.StateCode::Active); exit(CRMQuote.Count); end; procedure GetNoOfCRMCases(Customer: Record Customer): Integer var CRMIncident: Record "CRM Incident"; CRMID: Guid; begin if not IsCRMIntegrationEnabled() then exit(0); if not GetCoupledCRMID(Customer.RecordId, CRMID) then exit(0); CRMIncident.SetRange(StateCode, CRMIncident.StateCode::Active); CRMIncident.SetRange(CustomerId, CRMID); exit(CRMIncident.Count); end; local procedure GetSelectedMultipleSyncDirection(IntegrationTableMapping: Record "Integration Table Mapping"): Integer var SynchronizeNowQuestion: Text; AllowedDirection: Integer; RecommendedDirection: Integer; SelectedDirection: Integer; IsHandled: Boolean; begin AllowedDirection := IntegrationTableMapping.Direction; RecommendedDirection := AllowedDirection; case AllowedDirection of IntegrationTableMapping.Direction::Bidirectional: begin SelectedDirection := StrMenu(UpdateNowUniDirectionQst, RecommendedDirection, UpdateMultipleNowTitleTxt); if SelectedDirection = 0 then SelectedDirection := -1; exit(SelectedDirection); end; IntegrationTableMapping.Direction::FromIntegrationTable: SynchronizeNowQuestion := StrSubstNo(UpdateMultipleNowFromCRMQst, CRMProductName.CDSServiceName()); else SynchronizeNowQuestion := StrSubstNo(UpdateMultipleNowToCRMQst, CRMProductName.CDSServiceName()); end; IsHandled := false; OnBeforeSynchronyzeNowQuestion(AllowedDirection, IsHandled); if IsHandled then exit(AllowedDirection); if Confirm(SynchronizeNowQuestion, true) then exit(AllowedDirection); exit(-1); // user canceled the process end; local procedure GetSelectedSingleSyncDirection(IntegrationTableMapping: Record "Integration Table Mapping"; RecordRef: RecordRef; CRMID: Guid; var RecommendedDirectionIgnored: Boolean): Integer var IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; IntegrationTableSynch: Codeunit "Integration Table Synch."; CRMRecordRef: RecordRef; RecordIDDescr: Text; SynchronizeNowQuestion: Text; AllowedDirection: Integer; RecommendedDirection: Integer; SelectedDirection: Integer; RecordModified: Boolean; CRMRecordModified: Boolean; BothModified: Boolean; DefaultAnswer: Boolean; FieldsModified: Boolean; BidirectionalFieldsModified: Boolean; begin AllowedDirection := IntegrationTableMapping.Direction; // Determine which sides were modified since last synch IntegrationTableMapping.GetRecordRef(CRMID, CRMRecordRef); RecordModified := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, RecordRef); CRMRecordModified := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, CRMRecordRef); BothModified := RecordModified and CRMRecordModified; RecordIDDescr := Format(RecordRef.RecordId, 0, 1); if BothModified then // Changes on both sides. Bidirectional: warn user. Unidirectional: confirm and exit. case AllowedDirection of IntegrationTableMapping.Direction::Bidirectional: begin IntegrationTableSynch.CheckTransferFields(IntegrationTableMapping, RecordRef, CRMRecordRef, FieldsModified, BidirectionalFieldsModified); if BidirectionalFieldsModified then Message(BothRecordsModifiedBiDirectionalConflictMsg, RecordRef.Caption, CRMRecordRef.Caption, CRMProductName.CDSServiceName()) else begin if not FieldsModified then IntegrationTableSynch.CheckTransferFields(IntegrationTableMapping, CRMRecordRef, RecordRef, FieldsModified, BidirectionalFieldsModified); if FieldsModified then Message(BothRecordsModifiedBiDirectionalNoConflictMsg, RecordRef.Caption, CRMRecordRef.Caption, CRMProductName.CDSServiceName()); end; end; IntegrationTableMapping.Direction::ToIntegrationTable: begin IntegrationTableSynch.CheckTransferFields(IntegrationTableMapping, RecordRef, CRMRecordRef, FieldsModified, BidirectionalFieldsModified); if not FieldsModified then exit(AllowedDirection); if Confirm(BothRecordsModifiedToCRMQst, false, RecordIDDescr, CRMRecordRef.Caption, PRODUCTNAME.Short(), CRMProductName.CDSServiceName()) then exit(AllowedDirection); exit(-1); end; IntegrationTableMapping.Direction::FromIntegrationTable: begin IntegrationTableSynch.CheckTransferFields(IntegrationTableMapping, CRMRecordRef, RecordRef, FieldsModified, BidirectionalFieldsModified); if not FieldsModified then exit(AllowedDirection); if Confirm(BothRecordsModifiedToNAVQst, false, RecordIDDescr, CRMRecordRef.Caption, PRODUCTNAME.Short(), CRMProductName.CDSServiceName()) then exit(AllowedDirection); exit(-1); end; end; // Zero or one side changed. Synch for zero too because dependent objects could have changed. case AllowedDirection of IntegrationTableMapping.Direction::Bidirectional: begin if BothModified and BidirectionalFieldsModified then begin RecommendedDirection := IntegrationTableMapping.Direction::ToIntegrationTable; SelectedDirection := StrMenu(UpdateNowUniDirectionQst, RecommendedDirection, StrSubstNo(UpdateOneNowTitleTxt, RecordIDDescr)); if SelectedDirection = 0 then SelectedDirection := -1; end else begin if RecordModified = CRMRecordModified then RecommendedDirection := IntegrationTableMapping.Direction::Bidirectional else if CRMRecordModified then RecommendedDirection := IntegrationTableMapping.Direction::FromIntegrationTable else RecommendedDirection := IntegrationTableMapping.Direction::ToIntegrationTable; SelectedDirection := StrMenu(UpdateNowBiDirectionQst, RecommendedDirection, StrSubstNo(UpdateOneNowTitleTxt, RecordIDDescr)); case SelectedDirection of 0: SelectedDirection := -1; 3: SelectedDirection := IntegrationTableMapping.Direction::Bidirectional; end; end; RecommendedDirectionIgnored := SelectedDirection <> RecommendedDirection; exit(SelectedDirection); end; IntegrationTableMapping.Direction::FromIntegrationTable: if RecordModified then SynchronizeNowQuestion := StrSubstNo(UpdateOneNowFromOldCRMQst, RecordIDDescr, PRODUCTNAME.Short(), CRMProductName.CDSServiceName()) else begin SynchronizeNowQuestion := StrSubstNo(UpdateOneNowFromCRMQst, RecordIDDescr, CRMProductName.CDSServiceName()); DefaultAnswer := true; end; else if CRMRecordModified then SynchronizeNowQuestion := StrSubstNo(UpdateOneNowToModifiedCRMQst, RecordIDDescr, PRODUCTNAME.Short(), CRMProductName.CDSServiceName()) else begin SynchronizeNowQuestion := StrSubstNo(UpdateOneNowToCRMQst, RecordIDDescr, CRMProductName.CDSServiceName()); DefaultAnswer := true; end; end; if Confirm(SynchronizeNowQuestion, DefaultAnswer) then exit(AllowedDirection); exit(-1); // user canceled the process end; local procedure DeleteIntegrationRecordByBCID(var BCRecordRef: RecordRef) var CRMIntegrationRecord: Record "CRM Integration Record"; begin if CRMIntegrationRecord.FindByRecordID(BCRecordRef.RecordId()) then begin CRMIntegrationRecord.Delete(); Commit(); end; end; local procedure DeleteIntegrationRecordByCRMID(var CRMRecordRef: RecordRef; var IntegrationTableMapping: Record "Integration Table Mapping") var CRMIntegrationRecord: Record "CRM Integration Record"; CRMID: Guid; begin CRMID := CRMRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No.").Value(); if CRMIntegrationRecord.FindByCRMID(CRMID) then begin CRMIntegrationRecord.Delete(); Commit(); end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnUpdateConflictDetected', '', false, false)] local procedure HandleOnUpdateConflictDetected(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef; var UpdateConflictHandled: Boolean; var SkipRecord: Boolean) begin if UpdateConflictHandled then exit; if not (IsCDSIntegrationEnabled() or IsCRMIntegrationEnabled()) then exit; case IntegrationTableMapping."Update-Conflict Resolution" of IntegrationTableMapping."Update-Conflict Resolution"::"Get Update from Integration": begin UpdateConflictHandled := true; if SourceRecordRef.Number() = IntegrationTableMapping."Integration Table ID" then begin SkipRecord := false; Session.LogMessage('0000CUC', UpdateConflictHandledFromIntTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else begin SkipRecord := true; Session.LogMessage('0000D3O', UpdateConflictHandledSkipTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; end; IntegrationTableMapping."Update-Conflict Resolution"::"Send Update to Integration": begin UpdateConflictHandled := true; if SourceRecordRef.Number() = IntegrationTableMapping."Table ID" then begin SkipRecord := false; Session.LogMessage('0000CUD', UpdateConflictHandledToIntTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else begin SkipRecord := true; Session.LogMessage('0000D3P', UpdateConflictHandledSkipTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; end; end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnDeletionConflictDetected', '', false, false)] local procedure HandleOnDeletionConflictDetected(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DeletionConflictHandled: Boolean) var CRMConnectionSetup: Record "CRM Connection Setup"; CRMID: Guid; begin if DeletionConflictHandled then exit; if not (IsCDSIntegrationEnabled() or IsCRMIntegrationEnabled()) then exit; case IntegrationTableMapping."Deletion-Conflict Resolution" of IntegrationTableMapping."Deletion-Conflict Resolution"::"Remove Coupling": begin if SourceRecordRef.Number = IntegrationTableMapping."Table ID" then DeletionConflictHandled := RemoveCoupling(SourceRecordRef.RecordId(), false) else begin CRMID := SourceRecordRef.Field(IntegrationTableMapping."Integration Table UID Fld. No.").Value(); DeletionConflictHandled := RemoveCoupling(IntegrationTableMapping."Table ID", IntegrationTableMapping."Integration Table ID", CRMID, false); end; if IntegrationTableMapping."Table ID" = Database::"Sales Line" then if CRMConnectionSetup.IsBidirectionalSalesOrderIntEnabled() then if SourceRecordRef.Delete() then; if DeletionConflictHandled then Session.LogMessage('0000CUE', DeletionConflictHandledRemoveCouplingTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; IntegrationTableMapping."Deletion-Conflict Resolution"::"Restore Records": begin if SourceRecordRef.Number = IntegrationTableMapping."Table ID" then DeleteIntegrationRecordByBCID(SourceRecordRef) else DeleteIntegrationRecordByCRMID(SourceRecordRef, IntegrationTableMapping); DeletionConflictHandled := true; Session.LogMessage('0000CUF', DeletionConflictHandledRestoreRecordTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; end; end; [EventSubscriber(ObjectType::Table, Database::"Service Connection", 'OnRegisterServiceConnection', '', false, false)] procedure HandleCRMRegisterServiceConnection(var ServiceConnection: Record "Service Connection") var CRMConnectionSetup: Record "CRM Connection Setup"; RecRef: RecordRef; begin if not CRMConnectionSetup.Get() then begin if not CRMConnectionSetup.WritePermission then begin Session.LogMessage('0000CLV', NoPermissionsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; CRMConnectionSetup.Init(); CRMConnectionSetup.Insert(); end; RecRef.GetTable(CRMConnectionSetup); ServiceConnection.Status := ServiceConnection.Status::Enabled; if not CRMConnectionSetup."Is Enabled" then ServiceConnection.Status := ServiceConnection.Status::Disabled else if CRMConnectionSetup.TestConnection() then ServiceConnection.Status := ServiceConnection.Status::Connected else ServiceConnection.Status := ServiceConnection.Status::Error; ServiceConnection.InsertServiceConnectionExtended( ServiceConnection, RecRef.RecordId, CRMConnectionSetup.TableCaption(), CRMConnectionSetup."Server Address", PAGE::"CRM Connection Setup", PAGE::"CRM Connection Setup Wizard"); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CDS Integration Mgt.", 'OnGetIntegrationSolutions', '', false, false)] local procedure HandleOnGetIntegrationSolutions(var SolutionUniqueNameList: List of [Text]) var CRMConnectionSetup: Record "CRM Connection Setup"; begin if CRMConnectionSetup.Get() then if CRMConnectionSetup."Is Enabled" then SolutionUniqueNameList.Add(CRMProductName.UNIQUE()); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CDS Integration Mgt.", 'OnGetIntegrationRequiredRoles', '', false, false)] local procedure HandleOnGetIntegrationRequiredRoles(var RequiredRoleIdList: List of [Guid]) var CRMConnectionSetup: Record "CRM Connection Setup"; begin if CRMConnectionSetup.Get() then if CRMConnectionSetup."Is Enabled" then begin RequiredRoleIdList.Add(GetIntegrationAdminRoleID()); RequiredRoleIdList.Add(GetIntegrationUserRoleID()); end; end; procedure ClearState() begin CRMIntegrationEnabledState := CRMIntegrationEnabledState::" " end; [Scope('OnPrem')] procedure GetLastErrorMessage(): Text var ErrorObject: DotNet Exception; begin ErrorObject := GetLastErrorObject(); if IsNull(ErrorObject) then exit(''); if StrPos(ErrorObject.GetType().Name, 'NavCrmException') > 0 then if not IsNull(ErrorObject.InnerException) then exit(ErrorObject.InnerException.Message); exit(GetLastErrorText); end; [TryFunction] [Scope('OnPrem')] procedure ImportCRMSolution(ServerAddress: Text; IntegrationUserEmail: Text; AdminUserEmail: Text; AdminUserPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text; ProxyVersion: Integer; ForceRedeploy: Boolean; var SolutionImportFailed: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; CRMRole: Record "CRM Role"; CDSIntegrationImpl: Codeunit "CDS Integration Impl."; PageCDSConnectionSetup: Page "CDS Connection Setup"; CRMHelper: DotNet CrmHelper; UserGUID: Guid; IntegrationAdminRoleGUID: Guid; IntegrationUserRoleGUID: Guid; SalesProIntegrationRoleGUID: Guid; EmptyGuid: Guid; DefaultOwningTeamGUID: Guid; TempConnectionString: SecretText; TempConnectionStringWithPlaceholders: Text; SolutionInstalled: Boolean; SolutionOutdated: Boolean; ImportSolution: Boolean; begin CheckConnectRequiredFields(ServerAddress, IntegrationUserEmail); CDSConnectionSetup.Get(); if not AccessToken.IsEmpty() then begin TempConnectionStringWithPlaceholders := StrSubstNo(OAuthConnectionStringFormatTok, ServerAddress, '%1', ProxyVersion, CDSIntegrationImpl.GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholders, AccessToken); end else if AdminADDomain <> '' then begin TempConnectionStringWithPlaceholders := StrSubstNo( ConnectionStringFormatTok, ServerAddress, AdminUserEmail, '%1', ProxyVersion, CDSIntegrationImpl.GetAuthenticationTypeToken(CDSConnectionSetup, AdminADDomain)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholders, AdminUserPassword); end else begin TempConnectionStringWithPlaceholders := StrSubstNo( ConnectionStringFormatTok, ServerAddress, AdminUserEmail, '%1', ProxyVersion, CDSIntegrationImpl.GetAuthenticationTypeToken(CDSConnectionSetup)); TempConnectionString := SecretStrSubstNo(TempConnectionStringWithPlaceholders, AdminUserPassword) end; if CDSConnectionSetup."Authentication Type" = CDSConnectionSetup."Authentication Type"::OAuth then TempConnectionString := CDSIntegrationImpl.ReplaceUserNamePasswordInConnectionString(CDSConnectionSetup, AdminUserEmail, AdminUserPassword); if not InitializeCRMConnection(CRMHelper, TempConnectionString) then ProcessConnectionFailures(); UserGUID := CRMHelper.GetUserId(IntegrationUserEmail); if IsNullGuid(UserGUID) then Error(UserDoesNotExistCRMErr, IntegrationUserEmail, CRMProductName.CDSServiceName()); SolutionInstalled := CRMHelper.CheckSolutionPresence(MicrosoftDynamicsNavIntegrationTxt); if SolutionInstalled then SolutionOutdated := IsSolutionOutdated(TempConnectionString); if ForceRedeploy then ImportSolution := (not SolutionInstalled) or SolutionOutdated else ImportSolution := not SolutionInstalled; if ImportSolution then begin if not ImportDefaultCRMSolution(CRMHelper) then begin SolutionImportFailed := true; ProcessConnectionFailures(); end; if CrmHelper.GetPrivilegeId(SalesProDefaultSettingsPrivilegeNameTxt) <> EmptyGuid then if not ImportDefaultSalesProSolution(CRMHelper) then begin SolutionImportFailed := true; ProcessConnectionFailures(); end else Session.LogMessage('0000JFP', SalesProIntegrationSolutionImportedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; IntegrationAdminRoleGUID := CRMHelper.GetRoleId(GetIntegrationAdminRoleID()); IntegrationUserRoleGUID := CRMHelper.GetRoleId(GetIntegrationUserRoleID()); SalesProIntegrationRoleGUID := CRMHelper.GetRoleId(GetSalesProIntegrationRoleId()); if not CRMHelper.CheckRoleAssignedToUser(UserGUID, IntegrationAdminRoleGUID) then CRMHelper.AssociateUserWithRole(UserGUID, IntegrationAdminRoleGUID); if not CRMHelper.CheckRoleAssignedToUser(UserGUID, IntegrationUserRoleGUID) then CRMHelper.AssociateUserWithRole(UserGUID, IntegrationUserRoleGUID); if SalesProIntegrationRoleGUID <> EmptyGuid then if not CRMHelper.CheckRoleAssignedToUser(UserGUID, SalesProIntegrationRoleGUID) then CRMHelper.AssociateUserWithRole(UserGUID, SalesProIntegrationRoleGUID); if CDSIntegrationImpl.IsIntegrationEnabled() then begin CDSIntegrationImpl.RegisterConnection(); CDSIntegrationImpl.ActivateConnection(); CDSConnectionSetup.Get(); DefaultOwningTeamGUID := CDSIntegrationImpl.GetOwningTeamId(CDSConnectionSetup); if IsNullGuid(DefaultOwningTeamGUID) then begin Session.LogMessage('0000GDK', TeamNotFoundTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(TeamNotFoundErr, CDSIntegrationImpl.GetDefaultBusinessUnitName(), PageCDSConnectionSetup.Caption); end; CRMRole.SetRange(ParentRoleId, IntegrationAdminRoleGUID); CRMRole.SetRange(BusinessUnitId, CDSIntegrationImpl.GetCoupledBusinessUnitId()); if not CRMRole.FindFirst() then begin Session.LogMessage('0000BKQ', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, GetIntegrationAdminRoleID(), CDSIntegrationImpl.GetDefaultBusinessUnitName()); end; if not CDSIntegrationImpl.AssignTeamRole(CrmHelper, DefaultOwningTeamGUID, CRMRole.RoleId) then begin Session.LogMessage('0000BKR', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotAssignRoleToTeamErr, DefaultOwningTeamGUID, CDSIntegrationImpl.GetDefaultBusinessUnitName(), CRMRole.Name); end; CRMRole.SetRange(ParentRoleId, IntegrationUserRoleGUID); CRMRole.SetRange(BusinessUnitId, CDSIntegrationImpl.GetCoupledBusinessUnitId()); if not CRMRole.FindFirst() then begin Session.LogMessage('0000BKS', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, GetIntegrationUserRoleID(), CDSIntegrationImpl.GetDefaultBusinessUnitName()); end; if not CDSIntegrationImpl.AssignTeamRole(CrmHelper, DefaultOwningTeamGUID, CRMRole.RoleId) then begin Session.LogMessage('0000BKT', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotAssignRoleToTeamErr, DefaultOwningTeamGUID, CDSIntegrationImpl.GetDefaultBusinessUnitName(), CRMRole.Name); end; if SalesProIntegrationRoleGUID <> EmptyGuid then begin CRMRole.SetRange(ParentRoleId, SalesProIntegrationRoleGUID); CRMRole.SetRange(BusinessUnitId, CDSIntegrationImpl.GetCoupledBusinessUnitId()); if not CRMRole.FindFirst() then begin Session.LogMessage('0000JFN', RoleNotFoundForBusinessUnitTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(IntegrationRoleNotFoundErr, SalesProIntegrationRoleGUID, CDSIntegrationImpl.GetDefaultBusinessUnitName()); end; if not CDSIntegrationImpl.AssignTeamRole(CrmHelper, DefaultOwningTeamGUID, CRMRole.RoleId) then begin Session.LogMessage('0000JFO', CannotAssignRoleToTeamTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CannotAssignRoleToTeamErr, DefaultOwningTeamGUID, CDSIntegrationImpl.GetDefaultBusinessUnitName(), CRMRole.Name); end; end; end; end; [NonDebuggable] local procedure IsSolutionOutdated(TempConnectionString: SecretText): Boolean begin exit(IsSolutionOutdated(TempConnectionString, MicrosoftDynamicsNavIntegrationTxt)); end; [NonDebuggable] [Scope('OnPrem')] procedure IsSolutionOutdated(TempConnectionString: SecretText; SolutionUniqueName: Text[65]): Boolean var CDSSolution: Record "CDS Solution"; CDSIntegrationImpl: Codeunit "CDS Integration Impl."; NavTenantSettingsHelper: DotNet NavTenantSettingsHelper; Version: DotNet Version; TempConnectionName: Text; SolutionOutdated: Boolean; begin TempConnectionName := CDSIntegrationImpl.GetTempConnectionName(); if HasTableConnection(TableConnectionType::CRM, TempConnectionName) then UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); RegisterTableConnection(TableConnectionType::CRM, TempConnectionName, TempConnectionString.Unwrap()); SetDefaultTableConnection(TableConnectionType::CRM, TempConnectionName, true); SolutionOutdated := true; CDSSolution.SetRange(UniqueName, SolutionUniqueName); if CDSSolution.FindFirst() then if Version.TryParse(CDSSolution.Version, Version) then SolutionOutdated := Version.CompareTo(NavTenantSettingsHelper.GetPlatformVersion()) < 0; UnregisterTableConnection(TableConnectionType::CRM, TempConnectionName); exit(SolutionOutdated); end; [TryFunction] local procedure ImportDefaultCRMSolution(var CRMHelper: DotNet CrmHelper) begin CRMHelper.ImportDefaultCrmSolution(); end; [TryFunction] local procedure ImportDefaultSalesProSolution(var CRMHelper: DotNet CrmHelper) begin CRMHelper.ImportDefaultSalesProSolution(); end; procedure CheckConnectRequiredFields(ServerAddress: Text; IntegrationUserEmail: Text) begin if (IntegrationUserEmail = '') or (ServerAddress = '') then Error(EmailAndServerAddressEmptyErr); end; procedure CheckModifyCRMConnectionURL(var ServerAddress: Text[250]) var UriHelper: DotNet Uri; UriHelper2: DotNet Uri; UriPartialHelper: DotNet UriPartial; ProposedUri: Text[250]; begin FirstCheckCRMConnectionURL(ServerAddress, UriHelper, UriHelper2); if IsNull(UriHelper2) then exit; ProposedUri := UriHelper2.GetLeftPart(UriPartialHelper.Authority); // Test that a specific port number is given if ((UriHelper2.Port = 443) or (UriHelper2.Port = 80)) and (LowerCase(ServerAddress) <> LowerCase(ProposedUri)) then if Confirm(StrSubstNo(ReplaceServerAddressQst, ServerAddress, ProposedUri)) then ServerAddress := ProposedUri; end; local procedure FirstCheckCRMConnectionURL(var ServerAddress: Text[250]; var UriHelper: DotNet Uri; var UriHelper2: DotNet Uri) var CRMSetupDefaults: Codeunit "CRM Setup Defaults"; UriKindHelper: DotNet UriKind; begin if (ServerAddress = '') or (ServerAddress = '@@test@@') then exit; ServerAddress := DelChr(ServerAddress, '<>'); if not UriHelper.TryCreate(ServerAddress, UriKindHelper.Absolute, UriHelper2) then if not UriHelper.TryCreate('https://' + ServerAddress, UriKindHelper.Absolute, UriHelper2) then Error(InvalidUriErr); if UriHelper2.Scheme <> 'https' then begin if not CRMSetupDefaults.GetAllowNonSecureConnections() then Error(MustUseHttpsErr, CRMProductName.SHORT()); if UriHelper2.Scheme <> 'http' then Error(MustUseHttpOrHttpsErr, UriHelper2.Scheme, CRMProductName.SHORT()); end; end; procedure CheckCRMConnectionURL(ServerAddress: Text[250]) var UriHelper: DotNet Uri; UriHelper2: DotNet Uri; CheckedServerAddress: Text[250]; begin CheckedServerAddress := ServerAddress; FirstCheckCRMConnectionURL(CheckedServerAddress, UriHelper, UriHelper2); if CheckedServerAddress <> ServerAddress then Error(InvalidUriErr); end; procedure GetOrganizationFromUrl(ServerAddress: Text[250]) orgName: Text var UriHelper: DotNet Uri; UriHelper2: DotNet Uri; UriKindHelper: DotNet UriKind; begin // Return the organization name from an OnPremise URL which is in the form // http://crm-server:port/organization-name // Notice that TryCreate will fail if the port is not a number if (ServerAddress = '') or (ServerAddress = '@@test@@') then exit(''); ServerAddress := DelChr(ServerAddress, '<>'); if not UriHelper.TryCreate(ServerAddress, UriKindHelper.Absolute, UriHelper2) then if not UriHelper.TryCreate('https://' + ServerAddress, UriKindHelper.Absolute, UriHelper2) then Error(InvalidUriErr); orgName := UriHelper2.AbsolutePath; if orgName = '/' then exit(''); if (orgName <> '') and (StrLen(orgName) > 1) then orgName := CopyStr(orgName, 2); exit(orgName); end; procedure ConstructConnectionStringForSolutionImport(ServerAddress: Text): Text var FirstPart: Text; SecondPart: Text; FirstLevel: Integer; begin FirstLevel := StrPos(ServerAddress, '.'); if FirstLevel = 0 then Error(CRMConnectionURLWrongErr, CRMProductName.SHORT()); FirstPart := CopyStr(ServerAddress, 1, FirstLevel); SecondPart := CopyStr(ServerAddress, FirstLevel); exit(StrSubstNo(ImportSolutionConnectStringTok, FirstPart, SecondPart)); end; [TryFunction] [NonDebuggable] local procedure InitializeCRMConnection(var CRMHelper: DotNet CrmHelper; ConnectionString: SecretText) var CRMConnectionSetup: Record "CRM Connection Setup"; begin if ConnectionString.IsEmpty() then begin CRMConnectionSetup.Get(); CRMHelper := CRMHelper.CrmHelper(CRMConnectionSetup.GetSecretConnectionStringWithCredentials().Unwrap()); end else CRMHelper := CRMHelper.CrmHelper(ConnectionString.Unwrap()); if not TestCRMConnection(CRMHelper) then ProcessConnectionFailures(); end; [Scope('OnPrem')] procedure ProcessConnectionFailures() var DotNetExceptionHandler: Codeunit "DotNet Exception Handler"; FaultException: DotNet FaultException; FileNotFoundException: DotNet FileNotFoundException; ArgumentNullException: DotNet ArgumentNullException; CRMHelper: DotNet CrmHelper; ErrorMessage: Text; begin DotNetExceptionHandler.Collect(); if DotNetExceptionHandler.TryCastToType(GetDotNetType(FaultException)) then begin Session.LogMessage('0000CLW', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AdminEmailPasswordWrongErr, CRMProductName.SHORT()); end; if DotNetExceptionHandler.TryCastToType(GetDotNetType(FileNotFoundException)) then begin Session.LogMessage('0000CLX', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CRMSolutionFileNotFoundErr); end; if DotNetExceptionHandler.TryCastToType(CRMHelper.OrganizationServiceFaultExceptionType()) then begin Session.LogMessage('0000CLY', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(OrganizationServiceFailureErr) end; if DotNetExceptionHandler.TryCastToType(CRMHelper.SystemNetWebException()) then begin Session.LogMessage('0000CLZ', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CRMConnectionURLWrongErr, CRMProductName.SHORT()); end; if DotNetExceptionHandler.CastToType(ArgumentNullException, GetDotNetType(ArgumentNullException)) then case ArgumentNullException.ParamName of 'cred': begin Session.LogMessage('0000CM0', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(AdminEmailPasswordWrongErr, CRMProductName.SHORT()); end; 'Organization Name': begin Session.LogMessage('0000CM1', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(CRMConnectionURLWrongErr, CRMProductName.SHORT()); end; end; ErrorMessage := DotNetExceptionHandler.GetMessage(); if ErrorMessage <> '' then if ErrorMessage.ToLower().Contains(TimeoutTxt) then begin Session.LogMessage('0000EJ7', ConnectionFailureTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Error(RetryAfterTimeoutErr, ErrorMessage); end; DotNetExceptionHandler.Rethrow(); end; local procedure GetIntegrationTableMappingFromCRMID(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer; CRMID: Guid) var CRMAccount: Record "CRM Account"; CRMProduct: Record "CRM Product"; IsHandled: Boolean; begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Synch. Codeunit ID", CODEUNIT::"CRM Integration Table Synch."); IntegrationTableMapping.SetRange("Delete After Synchronization", false); if IsCRMTable(TableID) then IntegrationTableMapping.SetRange("Integration Table ID", TableID) else begin IsHandled := false; OnGetIntegrationTableMappingFromCRMIDOnBeforeFindTableID(IntegrationTableMapping, TableID, CRMID, IsHandled); if not IsHandled then begin if (TableID = Database::Vendor) or (TableID = Database::Customer) then begin CRMAccount.SetRange(AccountId, CRMID); if CRMAccount.FindFirst() then case CRMAccount.CustomerTypeCode of CRMAccount.CustomerTypeCode::Customer: TableID := Database::Customer; CRMAccount.CustomerTypeCode::Vendor: TableID := Database::Vendor; else Error(AccountRelationshipTypeNotSupportedErr); end; end; if (TableID = Database::Item) or (TableID = Database::Resource) then begin CRMProduct.SetRange(ProductId, CRMID); if CRMProduct.FindFirst() then case CRMProduct.ProductTypeCode of CRMProduct.ProductTypeCode::Services: TableID := Database::Resource; CRMProduct.ProductTypeCode::SalesInventory: TableID := Database::Item; else Error(ProductTypeNotSupportedErr); end; end; end; IntegrationTableMapping.SetRange("Table ID", TableID); end; if not IntegrationTableMapping.FindFirst() then Error(IntegrationTableMappingNotFoundErr, IntegrationTableMapping.TableCaption(), GetTableCaption(TableID)); end; [EventSubscriber(ObjectType::Page, Page::"My Notifications", 'OnInitializingNotificationWithDefaultState', '', false, false)] local procedure OnInitializingNotificationWithDefaultState(); var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault(GetCommonNotificationID(), CommonNotificationNameTxt, CommonNotificationDescriptionTxt, true); MyNotifications.InsertDefault(GetSkippedNotificationID(), SkippedRecordsNotificationNameTxt, SkippedRecordsNotificationDescriptionTxt, true); end; [Scope('OnPrem')] procedure DisableNotification(HostNotification: Notification) var MyNotifications: Record "My Notifications"; NotificationId: Text; begin NotificationId := HostNotification.GetData('NotificationId'); if not MyNotifications.Disable(NotificationId) then MyNotifications.InsertDefault(NotificationId, GetNotificationName(NotificationId), GetNotificationDescription(NotificationId), false); Session.LogMessage('0000F0J', StrSubstNo(UserDisabledNotificationTxt, GetNotificationName(NotificationId)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure GetNotificationName(NotificationId: Guid): Text[128]; begin case NotificationId of GetCommonNotificationID(): exit(CommonNotificationNameTxt); GetSkippedNotificationID(): exit(SkippedRecordsNotificationNameTxt); end; exit(''); end; local procedure GetNotificationDescription(NotificationId: Guid): Text; begin case NotificationId of GetCommonNotificationID(): exit(CommonNotificationDescriptionTxt); GetSkippedNotificationID(): exit(SkippedRecordsNotificationDescriptionTxt); end; exit(''); end; local procedure GetIntegrationAdminRoleID(): Text begin exit('8c8d4f51-a72b-e511-80d9-3863bb349780'); end; local procedure GetIntegrationUserRoleID(): Text begin exit('6f960e32-a72b-e511-80d9-3863bb349780'); end; local procedure GetSalesProIntegrationRoleId(): Text begin exit('2f92fbbd-2d13-461a-895f-27c13f789fdb'); end; procedure GetCommonNotificationID(): Guid begin exit('63428E33-54E4-42A6-82EE-3EEF268340BA'); end; procedure GetSkippedNotificationID(): Guid begin exit('B523E8EA-56B3-4E79-837E-F812CFB74DD4'); end; local procedure SendRestoredSyncNotification(Counter: Integer) var Msg: Text; begin if Counter = 1 then Msg := SyncRestoredMsg else Msg := StrSubstNo(SyncMultipleRestoredMsg, Counter); SendNotification(Msg); end; procedure SendResultNotification(RecVariant: Variant): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationSynchJob: Record "Integration Synch. Job"; IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"; RecordRef: RecordRef; NotificationMessage: Text; FailureDatetime: DateTime; SuccessDateTime: DateTime; begin RecordRef.GetTable(RecVariant); if CRMIntegrationRecord.FindByRecordID(RecordRef.RecordId()) then begin if CRMIntegrationRecord.Skipped then exit(SendSkippedSyncNotification(CRMIntegrationRecord."Integration ID")); if CRMIntegrationRecord."Last Synch. CRM Result" = CRMIntegrationRecord."Last Synch. CRM Result"::Failure then GetNotificationDetailsFromIntegrationSyncJobEntry( CRMIntegrationRecord."Last Synch. CRM Job ID", RecordRef.RecordId, NotificationMessage, FailureDatetime) else SuccessDateTime := CRMIntegrationRecord."Last Synch. CRM Modified On"; if CRMIntegrationRecord."Last Synch. Result" = CRMIntegrationRecord."Last Synch. Result"::Failure then GetNotificationDetailsFromIntegrationSyncJobEntry( CRMIntegrationRecord."Last Synch. Job ID", RecordRef.RecordId, NotificationMessage, FailureDatetime) else SuccessDateTime := CRMIntegrationRecord."Last Synch. Modified On"; if SuccessDateTime > FailureDatetime then NotificationMessage := ''; end else begin Clear(IntegrationSynchJob); IntegrationSynchJob."Synch. Direction" := IntegrationSynchJob."Synch. Direction"::ToIntegrationTable; if IntegrationSynchJob.GetErrorForRecordID(RecordRef.RecordId, IntegrationSynchJobErrors) then NotificationMessage := IntegrationSynchJobErrors.Message; end; if NotificationMessage <> '' then exit(SendNotification(NotificationMessage)); end; local procedure SendSkippedSyncNotification(IntegrationID: Guid): Boolean var MyNotifications: Record "My Notifications"; SyncNotification: Notification; begin if not MyNotifications.IsEnabled(GetSkippedNotificationID()) then exit; SyncNotification.Id := GetSkippedNotificationID(); SyncNotification.Recall(); SyncNotification.Message(SyncSkippedMsg); SyncNotification.Scope(NOTIFICATIONSCOPE::LocalScope); SyncNotification.SetData('IntegrationID', IntegrationID); SyncNotification.SetData('NotificationId', GetSkippedNotificationID()); SyncNotification.AddAction(DetailsTxt, CODEUNIT::"CRM Integration Management", 'ShowSkippedRecords'); SyncNotification.AddAction(DisableNotificationTxt, Codeunit::"CRM Integration Management", 'DisableNotification'); SyncNotification.Send(); exit(true); end; local procedure SendSyncNotification(RecordCounter: array[4] of Integer): Boolean begin if RecordCounter[NoOf::Total] = 1 then begin if RecordCounter[NoOf::Scheduled] = 1 then exit(SendNotification(SyncNowScheduledMsg)); if RecordCounter[NoOf::Skipped] = 1 then exit(SendNotification(SyncNowSkippedMsg)); exit(SendNotification(SyncNowFailedMsg)); end; exit(SendMultipleSyncNotification(RecordCounter)); end; local procedure SendMultipleSyncNotification(RecordCounter: array[4] of Integer): Boolean begin exit( SendNotification( StrSubstNo( SyncMultipleMsg, RecordCounter[NoOf::Scheduled], RecordCounter[NoOf::Failed], RecordCounter[NoOf::Skipped], RecordCounter[NoOf::Total]))); end; local procedure SendUncoupleNotification(RecordCounter: array[4] of Integer): Boolean begin if RecordCounter[NoOf::Total] = 1 then begin if RecordCounter[NoOf::Scheduled] = 1 then exit(SendNotification(UncoupleScheduledMsg)); if RecordCounter[NoOf::Skipped] = 1 then exit(SendNotification(UncoupleSkippedMsg)); exit(SendNotification(UncoupleFailedMsg)); end; exit(SendMultipleUncoupleNotification(RecordCounter)); end; local procedure SendCouplingNotification(RecordCounter: array[4] of Integer): Boolean begin if RecordCounter[NoOf::Total] = 1 then begin if RecordCounter[NoOf::Scheduled] = 1 then exit(SendNotification(CouplingScheduledMsg)); if RecordCounter[NoOf::Skipped] = 1 then exit(SendNotification(CouplingSkippedMsg)); exit(SendNotification(CouplingFailedMsg)); end; exit(SendMultipleCouplingNotification(RecordCounter)); end; local procedure SendMultipleUncoupleNotification(RecordCounter: array[4] of Integer): Boolean begin exit( SendNotification( StrSubstNo( UncoupleMultipleMsg, RecordCounter[NoOf::Scheduled], RecordCounter[NoOf::Failed], RecordCounter[NoOf::Skipped], RecordCounter[NoOf::Total]))); end; local procedure SendMultipleCouplingNotification(RecordCounter: array[4] of Integer): Boolean begin exit( SendNotification( StrSubstNo( CouplingMultipleMsg, RecordCounter[NoOf::Scheduled], RecordCounter[NoOf::Failed], RecordCounter[NoOf::Skipped], RecordCounter[NoOf::Total]))); end; local procedure SendNotification(Msg: Text): Boolean var MyNotifications: Record "My Notifications"; SyncNotification: Notification; begin if not MyNotifications.IsEnabled(GetCommonNotificationID()) then exit; SyncNotification.Id := GetCommonNotificationID(); SyncNotification.Recall(); SyncNotification.Message(Msg); SyncNotification.Scope(NOTIFICATIONSCOPE::LocalScope); SyncNotification.AddAction(DetailsTxt, Codeunit::"CRM Integration Management", 'OpenIntegrationSynchronizationJobsFromNotification'); SyncNotification.SetData('NotificationId', GetCommonNotificationID()); SyncNotification.AddAction(DisableNotificationTxt, Codeunit::"CRM Integration Management", 'DisableNotification'); SyncNotification.Send(); exit(true); end; [Scope('OnPrem')] procedure OpenIntegrationSynchronizationJobsFromNotification(HostNotification: Notification) var IntegrationSynchJobList: Page "Integration Synch. Job List"; begin IntegrationSynchJobList.Run(); Session.LogMessage('0000F0K', UserOpenedIntegrationSynchJobListViaNotificationTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; procedure ShowLog(RecId: RecordID) var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; begin GetIntegrationTableMapping(IntegrationTableMapping, RecId); CRMIntegrationRecord.FindByRecordID(RecId); IntegrationTableMapping.ShowLog(CRMIntegrationRecord.GetLatestJobIDFilter()); end; procedure ShowOptionLog(RecId: RecordId) var CRMOptionMapping: Record "CRM Option Mapping"; IntegrationTableMapping: Record "Integration Table Mapping"; begin GetIntegrationTableMapping(IntegrationTableMapping, RecId); CRMOptionMapping.SetRange("Record ID", RecId); if CRMOptionMapping.FindFirst() then IntegrationTableMapping.ShowLog(CRMOptionMapping.GetLatestJobIDFilter()) else IntegrationTableMapping.ShowLog(''); end; procedure ShowSkippedRecords(SkippedSyncNotification: Notification) var CRMIntegrationRecord: Record "CRM Integration Record"; CRMSkippedRecords: Page "CRM Skipped Records"; IntegrationID: Guid; begin if Evaluate(IntegrationID, SkippedSyncNotification.GetData('IntegrationID')) then begin CRMIntegrationRecord.SetRange("Integration ID", IntegrationID); if CRMIntegrationRecord.FindFirst() then CRMSkippedRecords.SetRecords(CRMIntegrationRecord); end; CRMSkippedRecords.Run(); end; procedure CoupleCRMEntity(RecordID: RecordID; CRMID: Guid; var Synchronize: Boolean; var Direction: Option): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; CouplingRecordBuffer: Record "Coupling Record Buffer"; begin CouplingRecordBuffer.Initialize(RecordID); CouplingRecordBuffer."CRM ID" := CRMID; if not CouplingRecordBuffer.Insert() then CouplingRecordBuffer.Modify(); if not IsNullGuid(CouplingRecordBuffer."CRM ID") then begin CRMIntegrationRecord.CoupleRecordIdToCRMID(CouplingRecordBuffer."NAV Record ID", CouplingRecordBuffer."CRM ID"); if CouplingRecordBuffer.GetPerformInitialSynchronization() then begin Synchronize := true; Direction := CouplingRecordBuffer.GetInitialSynchronizationDirection(); PerformInitialSynchronization(CouplingRecordBuffer."NAV Record ID", CouplingRecordBuffer."CRM ID", Direction); end; end else exit(false); exit(true); end; [TryFunction] [Scope('OnPrem')] procedure TestCRMConnection(var CRMHelper: DotNet CrmHelper) begin CRMHelper.CheckCredentials(); CRMHelper.GetConnectedCrmVersion(); end; [Scope('OnPrem')] procedure InitializeProxyVersionList(var TempStack: Record TempStack temporary) var CRMHelper: DotNet CrmHelper; IList: DotNet GenericList1; i: Integer; ProxyCount: Integer; begin IList := CRMHelper.GetProxyIdList(); ProxyCount := IList.Count(); for i := 0 to ProxyCount - 1 do begin TempStack.StackOrder := IList.Item(i); TempStack.Insert(); end; end; [Scope('OnPrem')] procedure GetLastProxyVersionItem(): Integer var TempStack: Record TempStack temporary; begin InitializeProxyVersionList(TempStack); TempStack.FindLast(); exit(TempStack.StackOrder); end; local procedure GetNotificationDetailsFromIntegrationSyncJobEntry(JobId: Guid; RecRefRecId: RecordID; var NotificationMessage: Text; var FailureDatetime: DateTime) var IntegrationSynchJob: Record "Integration Synch. Job"; IntegrationSynchJobErrors: Record "Integration Synch. Job Errors"; begin if IntegrationSynchJob.Get(JobId) then if IntegrationSynchJob.GetErrorForRecordID(RecRefRecId, IntegrationSynchJobErrors) then begin NotificationMessage := IntegrationSynchJobErrors.Message; FailureDatetime := IntegrationSynchJobErrors."Date/Time"; end end; procedure ClearConnectionDisableReason(var CRMConnectionSetup: Record "CRM Connection Setup") var Notification: Notification; begin Session.LogMessage('0000CM2', ClearDisabledReasonTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); Notification.Id := GetCRMDisabledErrorReasonNotificationId(); Notification.Recall(); Clear(CRMConnectionSetup."Disable Reason"); CRMConnectionSetup.Modify(); end; procedure GetCRMDisabledErrorReasonNotificationId() CRMDisabledErrorReasonNotificationId: Guid begin Evaluate(CRMDisabledErrorReasonNotificationId, CRMDisabledErrorReasonNotificationIdTxt); exit(CRMDisabledErrorReasonNotificationId); end; procedure IsWorkingConnection(): Boolean var CRMConnectionSetup: Record "CRM Connection Setup"; begin exit(CRMConnectionSetup.TryReadSystemUsers()); end; local procedure DisableConnection() var CRMConnectionSetup: Record "CRM Connection Setup"; LastError: Text; begin Session.LogMessage('0000CM3', DisableIntegrationTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); LastError := GetLastErrorText; LastError := CopyStr(LastError, StrPos(Format(LastError), ':') + 1, StrLen(LastError)); Message(StrSubstNo(ConnectionBrokenMsg, LastError)); if CRMConnectionSetup.Get() then begin CRMConnectionSetup.Validate("Is Enabled", false); CRMConnectionSetup.Validate( "Disable Reason", CopyStr(LastError, 1, MaxStrLen(CRMConnectionSetup."Disable Reason"))); CRMConnectionSetup.Modify(); Session.LogMessage('0000CM4', IntegrationDisabledTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end else Session.LogMessage('0000CM5', IntegrationNotConfiguredTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; procedure SendConnectionDisabledNotification(DisableReason: Text[250]) var Notification: Notification; begin Notification.Id := GetCRMDisabledErrorReasonNotificationId(); Notification.Message := StrSubstNo(ConnectionDisabledNotificationMsg, DisableReason); Notification.Scope := NOTIFICATIONSCOPE::LocalScope; Notification.Send(); end; [Scope('OnPrem')] procedure IsItemAvailabilityEnabled(): Boolean var CRMConnectionSetup: Record "CRM Connection Setup"; begin if CRMConnectionSetup.Get() then exit(CRMConnectionSetup."Item Availability Enabled"); end; procedure InitializeCRMSynchStatus() var CRMSynchStatus: Record "CRM Synch Status"; begin if CRMSynchStatus.IsEmpty() then begin CRMSynchStatus."Last Update Invoice Entry No." := 0; CRMSynchStatus.Insert(); end; end; internal procedure InitializeCRMSynchStatus(var CRMSynchStatus: Record "CRM Synch Status") begin if CRMSynchStatus.IsEmpty() then begin CRMSynchStatus."Last Update Invoice Entry No." := 0; CRMSynchStatus.Insert(); end; CRMSynchStatus.Get(); end; procedure HasUncoupledSelectedUsers(var SelectedCRMSystemuser: Record "CRM Systemuser"): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; RecordID: RecordID; begin if SelectedCRMSystemuser.FindSet() then repeat if not CRMIntegrationRecord.FindRecordIDFromID(SelectedCRMSystemuser.SystemUserId, Database::"Salesperson/Purchaser", RecordID) then exit(true); until SelectedCRMSystemuser.Next() = 0; exit(false); end; [EventSubscriber(ObjectType::Table, Database::"Integration Synch. Job Errors", 'OnIsDataIntegrationEnabled', '', false, false)] local procedure IsDataIntegrationEnabled(var IsIntegrationEnabled: Boolean) var CRMConnectionSetup: Record "CRM Connection Setup"; begin if not IsIntegrationEnabled then IsIntegrationEnabled := CRMConnectionSetup.IsEnabled(); end; [EventSubscriber(ObjectType::Table, Database::"Integration Synch. Job Errors", 'OnAfterLogSynchError', '', false, false)] local procedure DisableConnectionOnAfterLongSynchError(IntegrationSynchJobErrors: Record "Integration Synch. Job Errors") var CRMConnectionSetup: Record "CRM Connection Setup"; begin if not IntegrationSynchJobErrors.Message.Contains('CrmCreate') then exit; if not IntegrationSynchJobErrors.Message.Contains('prvCreate') then exit; DisableConnection(); if CRMConnectionSetup.Get() then begin CRMConnectionSetup."Disable Reason" := StrSubstNo(ConnectionDisabledReasonTxt, CRMConnectionSetup."Server Address", CRMConnectionSetup."User Name"); CRMConnectionSetup.Modify(); end; end; [EventSubscriber(ObjectType::Table, Database::"Integration Synch. Job Errors", 'OnForceSynchronizeDataIntegration', '', false, false)] local procedure ForceSynchronizeDataIntegration(LocalRecordID: RecordID; var SynchronizeHandled: Boolean) begin if SynchronizeHandled then exit; if not (IsCDSIntegrationEnabled() or IsCRMIntegrationEnabled()) then exit; UpdateOneNow(LocalRecordID); SynchronizeHandled := true; end; [EventSubscriber(ObjectType::Table, Database::"Integration Synch. Job Errors", 'OnForceSynchronizeRecords', '', false, false)] local procedure ForceSynchronizeRecords(var LocalRecordIdList: List of [RecordId]; var SynchronizeHandled: Boolean) var SelectedCRMIntegrationRecord: Record "CRM Integration Record"; CRMIntegrationRecord: Record "CRM Integration Record"; LocalRecordId: RecordId; begin if SynchronizeHandled then exit; if not (IsCDSIntegrationEnabled() or IsCRMIntegrationEnabled()) then exit; foreach LocalRecordId in LocalRecordIdList do if CRMIntegrationRecord.FindByRecordID(LocalRecordId) then begin SelectedCRMIntegrationRecord."CRM ID" := CRMIntegrationRecord."CRM ID"; SelectedCRMIntegrationRecord."Integration ID" := CRMIntegrationRecord."Integration ID"; if SelectedCRMIntegrationRecord.Find() then SelectedCRMIntegrationRecord.Mark(true); end; SelectedCRMIntegrationRecord.MarkedOnly(true); UpdateMultipleNow(SelectedCRMIntegrationRecord); SynchronizeHandled := true; end; [Scope('OnPrem')] procedure RegisterAssistedSetup() var GuidedExperience: Codeunit "Guided Experience"; GuidedExperienceType: Enum "Guided Experience Type"; Info: ModuleInfo; AssistedSetupGroup: Enum "Assisted Setup Group"; VideoCategory: Enum "Video Category"; begin NavApp.GetCurrentModuleInfo(Info); if not GuidedExperience.Exists(GuidedExperienceType::"Assisted Setup", ObjectType::Page, PAGE::"CRM Connection Setup Wizard") then GuidedExperience.InsertAssistedSetup( StrSubstNo(CRMConnectionSetupTxt, CRMProductName.SHORT()), CopyStr(StrSubstNo(CRMConnectionSetupTxt, CRMProductName.SHORT()), 1, 50), '', 0, ObjectType::Page, PAGE::"CRM Connection Setup Wizard", AssistedSetupGroup::Customize, VideoUrlSetupCRMConnectionTxt, VideoCategory::Customize, ''); end; [Scope('OnPrem')] procedure IsCRMIntegrationRecord(TableID: Integer): Boolean var IntegrationTableMapping: Record "Integration Table Mapping"; isIntegrationRecord: Boolean; begin // this is the new event that partners who have integration to custom entities should subscribe to OnIsCRMIntegrationRecord(TableID, isIntegrationRecord); if isIntegrationRecord then exit(true); IntegrationTableMapping.ReadIsolation := IsolationLevel::ReadUncommitted; IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); exit(IntegrationTableMapping.DoesExistForTable(TableID)); end; [Scope('OnPrem')] procedure GetDatabaseTableTriggerSetup(TableID: Integer; var Insert: Boolean; var Modify: Boolean; var Delete: Boolean; var Rename: Boolean) var CRMConnectionSetup: Record "CRM Connection Setup"; CDSConnectionSetup: Record "CDS Connection Setup"; Enabled: Boolean; begin if (Insert and Modify and Rename) then exit; if CompanyName = '' then exit; OnEnabledDatabaseTriggersSetup(TableID, Enabled); if not Enabled then begin if CDSConnectionSetup.ReadPermission() then if CDSConnectionSetup.Get() then if CDSConnectionSetup."Is Enabled" then Enabled := IsCRMIntegrationRecord(TableID); if not Enabled then if CRMConnectionSetup.ReadPermission() then begin CRMConnectionSetup.SetLoadFields("Is Enabled"); if CRMConnectionSetup.IsEnabled() then Enabled := IsCRMIntegrationRecord(TableID); end; end; if Enabled then begin Insert := true; Modify := true; Rename := true; if not Delete then Delete := false; end; end; [Scope('OnPrem')] procedure OnDatabaseInsert(RecRef: RecordRef) begin ReactivateJobForTable(RecRef.Number); end; [Scope('OnPrem')] procedure OnDatabaseModify(RecRef: RecordRef) begin ReactivateJobForTable(RecRef.Number); end; [Scope('OnPrem')] procedure OnDatabaseRename(RecRef: RecordRef; XRecRef: RecordRef) begin ReactivateJobForTable(RecRef.Number); end; internal procedure ReactivateJobForTable(TableNo: Integer) var CRMConnectionSetup: Record "CRM Connection Setup"; CDSConnectionSetup: Record "CDS Connection Setup"; JobQueueEntry: Record "Job Queue Entry"; JobQueueEntryUpdate: Record "Job Queue Entry"; ScheduledTask: Record "Scheduled Task"; IntegrationTableMapping: Record "Integration Table Mapping"; DataUpgradeMgt: Codeunit "Data Upgrade Mgt."; NewEarliestStartDateTime: DateTime; Enabled: Boolean; IsCRMIntRec: Boolean; RescheduleOffsetInMs: Integer; begin if CDSConnectionSetup.Get() then Enabled := CDSConnectionSetup."Is Enabled"; if not Enabled then Enabled := CRMConnectionSetup.IsEnabled(); if not Enabled then exit; if not CachedIsCRMIntegrationRecord.ContainsKey(TableNo) then begin IsCRMIntRec := IsCRMIntegrationRecord(TableNo); CachedIsCRMIntegrationRecord.Add(TableNo, IsCRMIntRec); if not IsCRMIntRec then exit; end; if not CachedIsCRMIntegrationRecord.Get(TableNo) then exit; if not CachedDisableEventDrivenSynchJobReschedule.ContainsKey(TableNo) then begin IntegrationTableMapping.ReadIsolation := IsolationLevel::ReadUncommitted; IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); if IntegrationTableMapping.FindMappingForTable(TableNo) then begin CachedDisableEventDrivenSynchJobReschedule.Add(TableNo, IntegrationTableMapping."Disable Event Job Resch."); if IntegrationTableMapping."Disable Event Job Resch." then exit; end; end; if CachedDisableEventDrivenSynchJobReschedule.ContainsKey(TableNo) then if CachedDisableEventDrivenSynchJobReschedule.Get(TableNo) then exit; if DataUpgradeMgt.IsUpgradeInProgress() then exit; if not UserCanRescheduleJob() then exit; JobQueueEntryUpdate.ReadIsolation := IsolationLevel::UpdLock; JobQueueEntry.Reset(); JobQueueEntry.ReadIsolation := IsolationLevel::ReadUncommitted; JobQueueEntry.SetLoadFields(Status, "System Task ID", "Object Type to Run", "Object ID to Run", "Record ID to Process", Description); JobQueueEntry.SetFilter(Status, Format(JobQueueEntry.Status::Ready) + '|' + Format(JobQueueEntry.Status::"On Hold with Inactivity Timeout")); JobQueueEntry.SetRange("Object Type to Run", JobQueueEntry."Object Type to Run"::Codeunit); JobQueueEntry.SetFilter("Object ID to Run", '%1|%2|%3|%4|%5', Codeunit::"Integration Synch. Job Runner", Codeunit::"CRM Statistics Job", Codeunit::"Int. Coupling Job Runner", Codeunit::"Int. Uncouple Job Runner", Codeunit::"CRM Archived Sales Orders Job"); JobQueueEntry.SetRange("Recurring Job", true); JobQueueEntry.SetFilter("Parameter String", '%1|%2', '', Format(TableNo)); JobQueueEntry.SetRange(Scheduled, true); if JobQueueEntry.IsEmpty() then exit; if not JobQueueEntry.FindSet() then exit; // reschedule the synch job in 30 seconds from now, to give time to the user to make further changes RescheduleOffSetInMs := 30000; OnBeforeRescheduleJobQueueEntries(TableNo, RescheduleOffSetInMs); if RescheduleOffSetInMs < 5000 then RescheduleOffSetInMs := 5000; ScheduledTask.ReadIsolation := IsolationLevel::ReadUncommitted; repeat // The rescheduled task might start while the current transaction is not committed yet. // Therefore the task will restart with a delay to lower a risk of use of "old" data. // If the task is scheduled to run soon (in 60 seconds from now) we don't reschedule NewEarliestStartDateTime := CurrentDateTime() + RescheduleOffsetInMs; if DoesJobActOnTable(JobQueueEntry, TableNo) then if ScheduledTask.Get(JobQueueEntry."System Task ID") then if (NewEarliestStartDateTime + RescheduleOffSetInMs) < ScheduledTask."Not Before" then if TaskScheduler.SetTaskReady(JobQueueEntry."System Task ID", NewEarliestStartDateTime) then begin JobQueueEntryUpdate.ID := JobQueueEntry.ID; if JobQueueEntryUpdate.GetRecLockedExtendedTimeout() then if JobQueueEntryUpdate.Status in [JobQueueEntry.Status::Ready, JobQueueEntry.Status::"On Hold with Inactivity Timeout"] then begin JobQueueEntryUpdate.Status := JobQueueEntry.Status::Ready; JobQueueEntryUpdate."Earliest Start Date/Time" := NewEarliestStartDateTime; JobQueueEntryUpdate."Parameter String" := Format(TableNo); JobQueueEntryUpdate.Modify(); Session.LogMessage('0000JAV', StrSubstNo(RescheduledTaskTxt, Format(ScheduledTask.ID), Format(JobQueueEntry.ID), JobQueueEntry.Description, Format(ScheduledTask."Not Before")), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; end; until JobQueueEntry.Next() = 0; end; local procedure DoesJobActOnTable(JobQueueEntry: Record "Job Queue Entry"; TableNo: Integer): Boolean var IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef; CacheKey: Text; ActsOnTable: Boolean; begin if (JobQueueEntry."Object Type to Run" = JobQueueEntry."Object Type to Run"::Codeunit) and (JobQueueEntry."Object ID to Run" = Codeunit::"CRM Archived Sales Orders Job") then exit(TableNo = Database::"Sales Header Archive"); CacheKey := CompanyName + '$' + Format(JobQueueEntry.ID) + '$' + Format(TableNo); if CachedDoesJobActOnTable.ContainsKey(CacheKey) then exit(CachedDoesJobActOnTable.Get(CacheKey)); if JobQueueEntry."Record ID to Process".TableNo = DATABASE::"Integration Table Mapping" then if RecRef.Get(JobQueueEntry."Record ID to Process") then begin RecRef.SetTable(IntegrationTableMapping); if IntegrationTableMapping."Table ID" = Database::"Sales Header" then ActsOnTable := TableNo = Database::"Sales Line" else ActsOnTable := IntegrationTableMapping."Table ID" = TableNo; end; CachedDoesJobActOnTable.Add(CacheKey, ActsOnTable); exit(ActsOnTable); end; [Scope('OnPrem')] procedure UserCanRescheduleJob(): Boolean var JobQueueEntry: Record "Job Queue Entry"; DummyErrorMessageRegister: Record "Error Message Register"; DummyErrorMessage: Record "Error Message"; begin if not JobQueueEntry.ReadPermission then exit(false); if not JobQueueEntry.WritePermission then exit(false); if not DummyErrorMessageRegister.WritePermission then exit(false); if not DummyErrorMessage.WritePermission then exit(false); if not TaskScheduler.CanCreateTask() then exit(false); exit(true); end; internal procedure FindCoupledToCRMField(var RecRef: RecordRef; var CoupledToCRMFldRef: FieldRef): Boolean var Field: Record "Field"; Customer: Record Customer; TableNo: Integer; FieldNo: Integer; CoupledFieldNo: Integer; IsHandled: Boolean; FieldFilterSearchTok: Label '*%1*', Locked = true; begin TableNo := RecRef.Number(); IsHandled := false; CoupledFieldNo := 0; OnBeforeFindCoupledToCRMField(TableNo, IsHandled, CoupledFieldNo); if IsHandled then begin if CoupledFieldNo = 0 then exit(false); CoupledToCRMFldRef := RecRef.Field(CoupledFieldNo); exit(true); end; if CachedCoupledToCRMFieldNo.ContainsKey(TableNo) then FieldNo := CachedCoupledToCRMFieldNo.Get(TableNo) else begin Field.SetRange(TableNo, TableNo); Field.SetRange(Type, Field.Type::Boolean); Field.SetRange(FieldName, Customer.FieldName("Coupled to Dataverse")); if Field.FindFirst() then FieldNo := Field."No." else begin Field.SetFilter(FieldName, StrSubstNo(FieldFilterSearchTok, Customer.FieldName("Coupled to Dataverse"))); if Field.FindFirst() then FieldNo := Field."No." else FieldNo := 0; end; CachedCoupledToCRMFieldNo.Add(TableNo, FieldNo); end; if FieldNo = 0 then exit(false); CoupledToCRMFldRef := RecRef.Field(FieldNo); exit(true); end; procedure EnableUnitGroupMapping(): Guid var JobQueueEntry: Record "Job Queue Entry"; begin AdjustUnitGroupCRMConnectionSetup(); if UserCanRescheduleJob() then begin JobQueueEntry.Init(); JobQueueEntry."Earliest Start Date/Time" := CurrentDateTime() + 1000; JobQueueEntry."Object Type to Run" := JobQueueEntry."Object Type to Run"::Codeunit; JobQueueEntry."Object ID to Run" := Codeunit::"CRM Update Unit Group Mapping"; JobQueueEntry."Maximum No. of Attempts to Run" := 3; JobQueueEntry."Rerun Delay (sec.)" := 60; JobQueueEntry."Run in User Session" := false; JobQueueEntry.Description := UpdateUnitGroupMappingJQEDescriptionTxt; Codeunit.Run(Codeunit::"Job Queue - Enqueue", JobQueueEntry); exit(JobQueueEntry.ID); end; end; procedure DisableUnitGroupMapping() var CRMIntegrationRecord: Record "CRM Integration Record"; CRMFullSyncReviewLine: Record "CRM Full Synch. Review Line"; begin CRMIntegrationRecord.SetFilter("Table ID", '%1', Database::"Unit Group"); if not CRMIntegrationRecord.IsEmpty() then CRMIntegrationRecord.DeleteAll(); CRMIntegrationRecord.SetFilter("Table ID", '%1', Database::"Item Unit of Measure"); if not CRMIntegrationRecord.IsEmpty() then CRMIntegrationRecord.DeleteAll(); CRMIntegrationRecord.SetFilter("Table ID", '%1', Database::"Resource Unit of Measure"); if not CRMIntegrationRecord.IsEmpty() then CRMIntegrationRecord.DeleteAll(); if CRMFullSyncReviewLine.Get('UNIT GROUP') then CRMFullSyncReviewLine.Delete(); if CRMFullSyncReviewLine.Get('ITEM UOM') then CRMFullSyncReviewLine.Delete(); if CRMFullSyncReviewLine.Get('RESOURCE UOM') then CRMFullSyncReviewLine.Delete(); RemoveIntegrationTableMapping(Database::"Unit Group", Database::"CRM Uomschedule"); RemoveIntegrationTableMapping(Database::"Item Unit of Measure", Database::"CRM Uom"); RemoveIntegrationTableMapping(Database::"Resource Unit of Measure", Database::"CRM Uom"); end; procedure AdjustUnitGroupCRMConnectionSetup() var CRMIntegrationRecord: Record "CRM Integration Record"; CRMFullSyncReviewLine: Record "CRM Full Synch. Review Line"; begin CRMIntegrationRecord.SetFilter("Table ID", '%1', Database::"Unit of Measure"); if not CRMIntegrationRecord.IsEmpty() then CRMIntegrationRecord.DeleteAll(); if CRMFullSyncReviewLine.Get('UNIT OF MEASURE') then CRMFullSyncReviewLine.Delete(); RemoveIntegrationTableMapping(Database::"Unit of Measure", Database::"CRM Uomschedule"); end; local procedure RemoveIntegrationTableMapping(TableId: Integer; IntTableId: Integer) JobExisted: Boolean; var IntegrationTableMapping: Record "Integration Table Mapping"; JobQueueEntry: Record "Job Queue Entry"; begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Table ID", TableId); IntegrationTableMapping.SetRange("Integration Table ID", IntTableId); IntegrationTableMapping.SetRange("Delete After Synchronization", false); if IntegrationTableMapping.FindSet() then repeat JobQueueEntry.SetRange("Record ID to Process", IntegrationTableMapping.RecordId()); if not JobQueueEntry.IsEmpty() then begin JobExisted := true; JobQueueEntry.DeleteAll(true); end; IntegrationTableMapping.Delete(true); until IntegrationTableMapping.Next() = 0; end; procedure UpdateItemUnitGroup() var Item: Record Item; UnitGroup: Record "Unit Group"; CommitCounter: Integer; begin Item.SetLoadFields(SystemId, "No.", "Unit Group Exists"); Item.SetRange("Unit Group Exists", false); if Item.FindSet() then repeat UnitGroup.SetRange("Source Id", Item.SystemId); UnitGroup.SetRange("Source Type", UnitGroup."Source Type"::Item); if UnitGroup.IsEmpty() then begin UnitGroup.Init(); UnitGroup."Source Id" := Item.SystemId; UnitGroup."Source No." := Item."No."; UnitGroup."Source Type" := UnitGroup."Source Type"::Item; UnitGroup.Insert(); CommitCounter += 1; end; if CommitCounter = 1000 then begin Commit(); CommitCounter := 0; end; until Item.Next() = 0; end; procedure UpdateResourceUnitGroup() var Resource: Record Resource; UnitGroup: Record "Unit Group"; CommitCounter: Integer; begin Resource.SetLoadFields(SystemId, "No.", "Unit Group Exists"); Resource.SetRange("Unit Group Exists", false); if Resource.FindSet() then repeat UnitGroup.SetRange("Source Id", Resource.SystemId); UnitGroup.SetRange("Source Type", UnitGroup."Source Type"::Resource); if UnitGroup.IsEmpty() then begin UnitGroup.Init(); UnitGroup."Source Id" := Resource.SystemId; UnitGroup."Source No." := Resource."No."; UnitGroup."Source Type" := UnitGroup."Source Type"::Resource; UnitGroup.Insert(); CommitCounter += 1; end; if CommitCounter = 1000 then begin Commit(); CommitCounter := 0; end; until Resource.Next() = 0; end; procedure IsUnitGroupMappingEnabled() FeatureEnabled: Boolean; var CRMConnectionSetup: Record "CRM Connection Setup"; begin if not CRMConnectionSetup.Get() then exit(false); exit(CRMConnectionSetup."Unit Group Mapping Enabled"); end; procedure MultipleCompanyLearnMore(var Notification: Notification) begin HyperLink(MultipleCompanyLinkLbl); end; procedure IsIntegrationRecordChild(TableID: Integer) ReturnValue: Boolean var Handled: Boolean; begin OnIsIntegrationRecordChild(TableID, Handled, ReturnValue); if Handled then exit(ReturnValue); exit(TableID in [Database::"Sales Line", Database::"Currency Exchange Rate", Database::"Sales Invoice Line", Database::"Sales Cr.Memo Line", Database::"Contact Alt. Address", Database::"Contact Profile Answer", Database::"Dimension Value", Database::"Rlshp. Mgt. Comment Line", Database::"Vendor Bank Account"]); end; local procedure GetOptionIdFieldRef(RecRef: RecordRef): FieldRef var FieldRef: FieldRef; KeyRef: KeyRef; begin KeyRef := RecRef.KeyIndex(1); if KeyRef.FieldCount() <> 1 then exit(FieldRef); FieldRef := RecRef.FieldIndex(1); exit(FieldRef); end; procedure GetFieldServiceIntegrationAppSourceLink(): Text begin exit(FSIntegrationAppSourceLinkTxt); end; procedure IsFieldServiceIntegrationAppInstalled(): Boolean var ExtensionManagement: Codeunit "Extension Management"; begin exit(ExtensionManagement.IsInstalledByAppId(FieldServiceIntegrationAppIdLbl)); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Int. Option Synch. Invoke", 'OnDeletionConflictDetected', '', false, false)] local procedure HandleOnOptionDeletionConflictDetected(var IntegrationTableMapping: Record "Integration Table Mapping"; var SourceRecordRef: RecordRef; var DeletionConflictHandled: Boolean) var CRMOptionMapping: Record "CRM Option Mapping"; begin if DeletionConflictHandled then exit; if not (IsCDSIntegrationEnabled() or IsCRMIntegrationEnabled()) then exit; if IntegrationTableMapping."Deletion-Conflict Resolution" in [IntegrationTableMapping."Deletion-Conflict Resolution"::"Remove Coupling", IntegrationTableMapping."Deletion-Conflict Resolution"::"Restore Records"] then if SourceRecordRef.Number = IntegrationTableMapping."Table ID" then DeletionConflictHandled := RemoveOptionMappingFromRecRef(SourceRecordRef) else DeletionConflictHandled := RemoveOptionMapping(IntegrationTableMapping."Integration Table ID", IntegrationTableMapping."Integration Table UID Fld. No.", CRMOptionMapping.GetRecordRefOptionId(SourceRecordRef)); end; [IntegrationEvent(false, false)] local procedure OnBeforeGetIntegrationTableMapping(var IntegrationTableMapping: Record "Integration Table Mapping"; TableID: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetIntegrationTableMappingFromCRMRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeHandleCustomIntegrationTableMapping(var IsHandled: Boolean; IntegrationTableMappingName: Code[20]; var IntegrationTableMapping: Record "Integration Table Mapping"; EnqueueJobQueEntries: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeSynchronyzeNowQuestion(var AllowedDirection: Integer; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnIsCRMIntegrationRecord(TableID: Integer; var isIntegrationRecord: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnEnabledDatabaseTriggersSetup(TableID: Integer; var Enabled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnGetTableIdFromCRMOption(RecRef: RecordRef; var TableId: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnIsCRMTable(TableID: Integer; var IsCRMTable: Boolean; var Handled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnIsIntegrationRecordChild(TableID: Integer; var Handled: Boolean; var ReturnValue: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeOpenCoupledNavRecordPage(CRMID: Guid; CRMEntityTypeName: Text; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFindCoupledToCRMField(TableNo: Integer; var IsHandled: Boolean; var CoupledFieldNo: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetCRMEntityUrlFromCRMID(CRMEntityUrlTemplateTxt: Text; NewestUIAppIdParameterTxt: Text; TableId: Integer; CRMId: Guid; var CRMEntityUrl: Text; CRMTableId: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnGetIntegrationTableMappingFromCRMIDOnBeforeFindTableID(var IntegrationTableMapping: Record "Integration Table Mapping"; var TableID: Integer; CRMID: Guid; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeGetIntegrationTableMappingWithRecordId(var IntegrationTableMapping: Record "Integration Table Mapping"; BCRecordId: RecordId; var TableID: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnAfterGetIntegrationTableMappingFromCRMRecordBeforeFindRecord(var IntegrationTableMapping: Record "Integration Table Mapping"; RecRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnAfterAddExtraFieldMappings(IntegrationTableMappingName: Code[20]) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeRescheduleJobQueueEntries(TableNo: Integer; var RescheduleOffSetInMs: Integer) begin end; [IntegrationEvent(false, false)] local procedure OnRemoveCouplingOnBeforeGetIntegrationTableMappingForUncoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; LocalRecordRef: RecordRef) begin end; [IntegrationEvent(false, false)] local procedure OnMatchBasedCouplingOnBeforeGetIntegrationTableMappingForMatchBasedCoupling(var IntegrationTableMapping: Record "Integration Table Mapping"; LocalRecordRef: RecordRef) begin end;}