Codeunit 7205 CDS Int. Table. Subscriber
src/Layers/W1/BaseApp/Integration/Dataverse/CDSIntTableSubscriber.Codeunit.al1,611 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.BusinessRelation;using Microsoft.CRM.Contact;using Microsoft.CRM.Team;using Microsoft.Finance.GeneralLedger.Setup;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.Pricing.PriceList;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using System;using System.Environment;using System.Environment.Configuration;using System.IO;using System.Telemetry;codeunit 7205 "CDS Int. Table. Subscriber"{ SingleInstance = true; trigger OnRun() begin end; var CDSIntegrationMgt: Codeunit "CDS Integration Mgt."; CDSIntegrationImpl: Codeunit "CDS Integration Impl."; CRMSynchHelper: Codeunit "CRM Synch. Helper"; UserCDSSetupTxt: Label 'Dataverse User Setup'; CannotResolveUserFromConnectionSetupErr: Label 'The integration user that is specified in the Dataverse connection setup does not exist.'; RecordMustBeCoupledErr: Label '%1 %2 must be coupled to a Dataverse row.', Comment = '%1 = table caption, %2 = primary key value'; RecordMustBeCoupledExtErr: Label '%1 %2 must be coupled to a %3 row.', Comment = '%1 = BC table caption, %2 = primary key value, %3 - Dataverse table caption'; RecordNotFoundErr: Label 'Cannot find %1 in table %2.', Comment = '%1 = The lookup value when searching for the source record, %2 = Source table caption'; ContactMustBeRelatedToCustomerOrVendorErr: Label 'The contact %1 must have a contact company that has a business relation to a customer or vendor.', Comment = '%1 = Contact No.'; NewCodePatternTxt: Label 'SP NO. %1', Locked = true; SalespersonPurchaserCodeFilterLbl: Label 'SP NO. 0*', Locked = true; CouplingsNeedToBeResetQst: Label 'Dataverse integration is enabled, and records have been coupled for this company. Before you delete this company, you should delete its couplings so that other companies can access the coupled records. You can delete the couplings on the %1 page. Do you want to proceed without deleting the couplings?', Comment = '%1 = page caption of Integration Table Mappings'; CategoryTok: Label 'AL Dataverse Integration', Locked = true; UpdateContactParentCompanyTxt: Label 'Updating contact parent company.', Locked = true; UpdateContactParentCompanyFailedTxt: Label 'Updating contact parent company failed. Parent Customer ID: %1', Locked = true, Comment = '%1 - parent customer id'; UpdateContactParentCompanySuccessfulTxt: Label 'Contact parent company has successfully been updated.', Locked = true; UpdateContactParentCompanyAlreadySetTxt: Label 'Contact parent company has already been set correctly.', Locked = true; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnInitCDSConnection', '', true, true)] local procedure HandleOnInitCDSConnection(var ConnectionName: Text; var handled: Boolean) begin if handled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if not CDSIntegrationImpl.RegisterConnection() then exit; if CDSIntegrationImpl.ActivateConnection() then begin handled := true; ConnectionName := CDSIntegrationImpl.GetConnectionDefaultName(); end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnCloseCDSConnection', '', true, true)] local procedure HandleOnCloseCDSConnection(ConnectionName: Text; var handled: Boolean) begin if handled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if CDSIntegrationImpl.UnregisterConnection(ConnectionName) then handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnTestCDSConnection', '', true, true)] local procedure HandleOnTestCDSConnection(var handled: Boolean) begin if handled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; handled := true; CDSIntegrationImpl.TestSystemUsersAvailability(); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnGetCDSIntegrationUserId', '', true, true)] local procedure HandleOnGetCDSIntegrationUserId(var IntegrationUserId: Guid; var handled: Boolean) begin if handled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; IntegrationUserId := FindIntegrationUserId(); handled := true; if IsNullGuid(IntegrationUserId) then ShowError(UserCDSSetupTxt, CannotResolveUserFromConnectionSetupErr); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnGetCDSServerAddress', '', true, true)] local procedure HandleOnGetCDSServerAddress(var CDSServerAddress: Text; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; CDSConnectionSetup.Get(); CDSServerAddress := CDSConnectionSetup."Server Address"; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnAfterInsertRecord', '', false, false)] local procedure HandleOnAfterInsertRecord(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) var IntegrationTableMapping: Record "Integration Table Mapping"; Customer: Record Customer; begin case GetSourceDestCode(SourceRecordRef, DestinationRecordRef) of 'CRM Account-Customer', 'CRM Account-Vendor': begin SetCompanyIdOnCRMAccount(SourceRecordRef); UpdateChildContactsParentCompany(SourceRecordRef); end; 'CRM Contact-Contact': begin FixPrimaryContactNo(SourceRecordRef, DestinationRecordRef); SetCompanyIdOnCRMContact(SourceRecordRef); end; 'Contact-CRM Contact': FixPrimaryContactIdInCDS(SourceRecordRef, DestinationRecordRef); 'CRM Systemuser-Salesperson/Purchaser': AddCoupledUserToDefaultOwningTeam(SourceRecordRef); 'Customer-CRM Account': begin SourceRecordRef.SetTable(Customer); IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Table ID", Database::Contact); IntegrationTableMapping.SetRange("Integration Table ID", Database::"CRM Contact"); if IntegrationTableMapping.FindFirst() then if IntegrationTableMapping."Synch. Int. Tbl. Mod. On Fltr." > Customer.SystemCreatedAt then begin IntegrationTableMapping."Synch. Int. Tbl. Mod. On Fltr." := Customer.SystemCreatedAt; IntegrationTableMapping.Modify(); end; end; end; end; [EventSubscriber(ObjectType::Table, Database::"Salesperson/Purchaser", 'OnAfterDeleteEvent', '', false, false)] local procedure DeleteCouplingOnAfterDeleteSalesperson(var Rec: Record "Salesperson/Purchaser"; RunTrigger: Boolean) var CRMIntegrationRecord: Record "CRM Integration Record"; begin if Rec.IsTemporary() then exit; CRMIntegrationRecord.SetCurrentKey("Integration ID"); CRMIntegrationRecord.SetRange("Integration ID", Rec.SystemId); if CRMIntegrationRecord.FindFirst() then CRMIntegrationRecord.Delete(); end; [TryFunction] local procedure AddCoupledUserToDefaultOwningTeam(SourceRecordRef: RecordRef) var CRMSystemuser: Record "CRM Systemuser"; CDSConnectionSetup: Record "CDS Connection Setup"; CrmHelper: DotNet CrmHelper; AdminUser: Text; AdminPassword: SecretText; AccessToken: SecretText; AdminADDomain: Text; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if not CDSConnectionSetup.Get() then exit; if CDSConnectionSetup."Authentication Type" <> CDSConnectionSetup."Authentication Type"::Office365 then exit; SourceRecordRef.SetTable(CRMSystemuser); if CRMSystemuser.IsEmpty() then exit; if CDSIntegrationImpl.SignInCDSAdminUser(CDSConnectionSetup, CrmHelper, AdminUser, AdminPassword, AccessToken, AdminADDomain, true) then if not AccessToken.IsEmpty() then CDSIntegrationImpl.AddUsersToDefaultOwningTeam(CDSConnectionSetup, CrmHelper, CRMSystemuser); end; local procedure SetCompanyIdOnCRMContact(var SourceRecordRef: RecordRef) var CRMContact: Record "CRM Contact"; RecRef: RecordRef; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; // if the CDS entity already has a correct company id, do nothing if CDSIntegrationImpl.CheckCompanyIdNoTelemetry(SourceRecordRef) then exit; SourceRecordRef.SetTable(CRMContact); // it is required to calculate these fields, otherwise CDS fails to modify the entity if (CRMContact.CreatedByName = '') or (CRMContact.ModifiedByName = '') or (CRMContact.TransactionCurrencyIdName = '') then begin CRMContact.SetAutoCalcFields(CreatedByName, ModifiedByName, TransactionCurrencyIdName); CRMContact.Find(); end; RecRef.GetTable(CRMContact); SetCompanyId(RecRef); RecRef.Modify(); CRMContact.Find(); SourceRecordRef.GetTable(CRMContact); end; local procedure SetCompanyIdOnCRMAccount(var SourceRecordRef: RecordRef) var CRMAccount: Record "CRM Account"; RecRef: RecordRef; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; // if the CDS entity already has a correct company id, do nothing if CDSIntegrationImpl.CheckCompanyIdNoTelemetry(SourceRecordRef) then exit; SourceRecordRef.SetTable(CRMAccount); // it is required to calculate these fields, otherwise CDS fails to modify the entity if (CRMAccount.CreatedByName = '') or (CRMAccount.ModifiedByName = '') or (CRMAccount.TransactionCurrencyIdName = '') then begin CRMAccount.SetAutoCalcFields(CreatedByName, ModifiedByName, TransactionCurrencyIdName); CRMAccount.Find(); end; RecRef.GetTable(CRMAccount); SetCompanyId(RecRef); RecRef.Modify(); CRMAccount.Find(); SourceRecordRef.GetTable(CRMAccount); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Record Synch.", 'OnTransferFieldData', '', false, false)] local procedure OnTransferFieldData(SourceFieldRef: FieldRef; DestinationFieldRef: FieldRef; var NewValue: Variant; var IsValueFound: Boolean; var NeedsConversion: Boolean) var IntegrationTableMapping: Record "Integration Table Mapping"; CDSConnectionSetup: Record "CDS Connection Setup"; Item: Record Item; Resource: Record Resource; Contact: Record Contact; PriceListLine: Record "Price List Line"; CRMProduct: Record "CRM Product"; SalesLine: Record "Sales Line"; GeneralLedgerSetup: Record "General Ledger Setup"; CRMTransactionCurrency: Record "CRM Transactioncurrency"; CRMIntegrationRecord: Record "CRM Integration Record"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; DestinationRecRef: RecordRef; TransactionCurrencyId: Guid; OriginalDestinationFieldValue: Variant; IsClearValueOnFailedSync: Boolean; OptionValue: Integer; EmptyGuid: Guid; TableValue: Text; SourceValue: Text; CoupledSalespersonPurchaserCode: Code[20]; ContactNo: Code[20]; begin if IsValueFound then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if SourceFieldRef.Number() = DestinationFieldRef.Number() then if SourceFieldRef.Record().Number() = DestinationFieldRef.Record().Number() then exit; if DestinationFieldRef.Name() = 'OwnerId' then begin CDSConnectionSetup.Get(); case CDSConnectionSetup."Ownership Model" of CDSConnectionSetup."Ownership Model"::Team: begin // in case of field mapping to OwnerId, if ownership model is Team, we don't change the value if Salesperson changes NewValue := DestinationFieldRef.Value(); IsValueFound := true; NeedsConversion := false; exit; end; CDSConnectionSetup."Ownership Model"::Person: begin // in case of field mapping to OwnerId, if ownership model is Person, we should find the user mapped to the Salesperson/Purchaser NewValue := CRMSynchHelper.GetCoupledCDSUserId(SourceFieldRef.Record()); IsValueFound := true; NeedsConversion := false; exit; end; end; end; if SourceFieldRef.Name() = 'OwnerId' then begin CDSConnectionSetup.Get(); case CDSConnectionSetup."Ownership Model" of CDSConnectionSetup."Ownership Model"::Team: begin // in case of field mapping to OwnerId, if ownership model is Team, we don't change the value of Salesperson code NewValue := DestinationFieldRef.Value(); IsValueFound := true; NeedsConversion := false; exit; end; CDSConnectionSetup."Ownership Model"::Person: begin // in case of field mapping to OwnerId, if ownership model is Person, we should find the SalesPerson/Purchaser mapped to the user CoupledSalespersonPurchaserCode := GetCoupledSalespersonPurchaserCode(SourceFieldRef.Record()); if CoupledSalespersonPurchaserCode <> '' then NewValue := CoupledSalespersonPurchaserCode else NewValue := DestinationFieldRef.Value(); IsValueFound := true; NeedsConversion := false; exit; end; end; end; OriginalDestinationFieldValue := DestinationFieldRef.Value(); if DestinationFieldRef.Name() = 'Primary Contact No.' then begin SourceValue := Format(SourceFieldRef.Value()); if (SourceValue = '') or (SourceValue = Format(EmptyGuid)) then begin // in case of bringing in a blank value for a field that is marked as "Clear Value on Failed Sync", keep the Destination value // except if the original contact is coupled. in this case, we know that the Primary Contact No. was updated, so this change (blanking it) is valid ContactNo := OriginalDestinationFieldValue; if Contact.Get(ContactNo) then if not CRMIntegrationRecord.FindByRecordID(Contact.RecordId) then begin NewValue := OriginalDestinationFieldValue; IsValueFound := true; NeedsConversion := false; exit; end; end; end; if (SourceFieldRef.Name() = SalesLine.FieldName(SalesLine."Currency Code")) and (DestinationFieldRef.Name() = CRMTransactionCurrency.FieldName(TransactionCurrencyId)) then if Format(SourceFieldRef.Value()) = '' then if CDSConnectionSetup.Get() then if CDSConnectionSetup.BaseCurrencyCode <> '' then begin GeneralLedgerSetup.Get(); if GeneralLedgerSetup."LCY Code" <> CDSConnectionSetup.BaseCurrencyCode then begin CRMTransactionCurrency.SetRange(ISOCurrencyCode, CopyStr(GeneralLedgerSetup."LCY Code", 1, MaxStrLen(CRMTransactionCurrency.ISOCurrencyCode))); if CRMTransactionCurrency.FindFirst() then begin NewValue := CRMTransactionCurrency.TransactionCurrencyId; IsValueFound := true; NeedsConversion := false; exit; end; end; end; if (SourceFieldRef.Name() = CRMTransactionCurrency.FieldName(TransactionCurrencyId)) and (DestinationFieldRef.Name() = SalesLine.FieldName(SalesLine."Currency Code")) then if CDSConnectionSetup.Get() then if CDSConnectionSetup.BaseCurrencyCode <> '' then begin GeneralLedgerSetup.Get(); if GeneralLedgerSetup."LCY Code" <> CDSConnectionSetup.BaseCurrencyCode then begin Evaluate(TransactionCurrencyId, Format(SourceFieldRef.Value())); if CRMTransactionCurrency.Get(TransactionCurrencyId) then if Format(CRMTransactionCurrency.ISOCurrencyCode) = Format(GeneralLedgerSetup."LCY Code") then begin NewValue := ''; IsValueFound := true; NeedsConversion := false; exit; end; end; end; if CRMSynchHelper.FindNewValueForSpecialMapping(SourceFieldRef, DestinationFieldRef, NewValue) then begin IsValueFound := true; NeedsConversion := false; exit; end; if CRMIntegrationManagement.IsUnitGroupMappingEnabled() then begin if ((SourceFieldRef.Record().Number() = Database::Item) and (SourceFieldRef.Number() = Item.FieldNo("Base Unit of Measure"))) or ((SourceFieldRef.Record().Number() = Database::Resource) and (SourceFieldRef.Number() = Resource.FieldNo("Base Unit of Measure"))) or ((SourceFieldRef.Record().Number() = Database::"Price List Line") and (SourceFieldRef.Number() = PriceListLine.FieldNo("Unit of Measure Code"))) then begin CRMSynchHelper.ConvertBaseUnitOfMeasureToUomId(SourceFieldRef, DestinationFieldRef, NewValue); IsValueFound := true; NeedsConversion := false; exit; end; if (SourceFieldRef.Record().Number() = Database::"CRM Product") and (SourceFieldRef.Number() = CRMProduct.FieldNo(DefaultUoMId)) then begin CRMSynchHelper.ConvertUomIdToBaseUnitOfMeasure(SourceFieldRef, DestinationFieldRef, NewValue); IsValueFound := true; NeedsConversion := false; exit; end; if SourceFieldRef.Record().Number() = Database::"Unit Group" then begin CRMSynchHelper.PrefixUnitGroupCode(SourceFieldRef, NewValue); IsValueFound := true; NeedsConversion := false; end; end; if CRMSynchHelper.ConvertTableToOption(SourceFieldRef, DestinationFieldRef, OptionValue) then begin NewValue := OptionValue; IsValueFound := true; NeedsConversion := true; end else if CRMSynchHelper.ConvertOptionToTable(SourceFieldRef, DestinationFieldRef, TableValue) then begin NewValue := TableValue; IsValueFound := true; NeedsConversion := false; end else if CRMSynchHelper.AreFieldsRelatedToMappedTables(SourceFieldRef, DestinationFieldRef, IntegrationTableMapping) then begin IsValueFound := FindNewValueForCoupledRecordPK(IntegrationTableMapping, SourceFieldRef, DestinationFieldRef, NewValue); if IsValueFound then begin if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::ToIntegrationTable then IsClearValueOnFailedSync := CRMSynchHelper.IsClearValueOnFailedSync(SourceFieldRef, DestinationFieldRef) else if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::FromIntegrationTable then IsClearValueOnFailedSync := CRMSynchHelper.IsClearValueOnFailedSync(DestinationFieldRef, SourceFieldRef); if IsClearValueOnFailedSync then begin DestinationRecRef := DestinationFieldRef.Record(); DestinationFieldRef.SetRange(OriginalDestinationFieldValue); if DestinationRecRef.IsEmpty() then NewValue := OriginalDestinationFieldValue; end; end; NeedsConversion := false; end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnBeforeInsertRecord', '', false, false)] local procedure HandleOnBeforeInsertRecord(SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) var ConfigTemplateHeader: Record "Config. Template Header"; IntegrationTableMapping: Record "Integration Table Mapping"; IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; CustomerTemplMgt: Codeunit "Customer Templ. Mgt."; VendorTemplMgt: Codeunit "Vendor Templ. Mgt."; ItemTemplMgt: Codeunit "Item Templ. Mgt."; ConfigTemplateCode: Code[10]; SourceDestCode: Text; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; SourceDestCode := GetSourceDestCode(SourceRecordRef, DestinationRecordRef); if SourceDestCode = 'Contact-CRM Contact' then UpdateCRMContactParentCustomerId(SourceRecordRef, DestinationRecordRef); if SourceRecordRef.Number in [Database::"CRM Account", Database::"CRM Product"] then begin IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Table ID", DestinationRecordRef.Number); IntegrationTableMapping.SetRange("Integration Table ID", SourceRecordRef.Number); if IntegrationTableMapping.FindFirst() then ConfigTemplateCode := IntegrationRecSynchInvoke.FindTableConfigTemplate(IntegrationTableMapping, SourceRecordRef); end; case SourceDestCode of 'Customer-CRM Account', 'Contact-CRM Contact', 'Vendor-CRM Account': begin SetCompanyId(DestinationRecordRef); SetOwnerId(SourceRecordRef, DestinationRecordRef); end; 'Currency-CRM Transactioncurrency': SetDefaultSymbolOnCRMTransactioncurrencyIfEmpty(DestinationRecordRef); 'CRM Account-Customer': if ConfigTemplateCode <> '' then if ConfigTemplateHeader.Get(ConfigTemplateCode) then CustomerTemplMgt.FillCustomerKeyFromInitSeries(DestinationRecordRef, ConfigTemplateHeader); 'CRM Account-Vendor': if ConfigTemplateCode <> '' then if ConfigTemplateHeader.Get(ConfigTemplateCode) then VendorTemplMgt.FillVendorKeyFromInitSeries(DestinationRecordRef, ConfigTemplateHeader); 'CRM Product-Item': if ConfigTemplateCode <> '' then if ConfigTemplateHeader.Get(ConfigTemplateCode) then ItemTemplMgt.FillItemKeyFromInitSeries(DestinationRecordRef, ConfigTemplateHeader); end; if DestinationRecordRef.Number() = DATABASE::"Salesperson/Purchaser" then UpdateSalesPersOnBeforeInsertRecord(DestinationRecordRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnBeforeModifyRecord', '', false, false)] local procedure HandleOnBeforeModifyRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) var SourceDestCode: Text; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; SourceDestCode := GetSourceDestCode(SourceRecordRef, DestinationRecordRef); if SourceDestCode = 'Contact-CRM Contact' then UpdateCRMContactParentCustomerId(SourceRecordRef, DestinationRecordRef); case SourceDestCode of 'Customer-CRM Account', 'Contact-CRM Contact', 'Vendor-CRM Account': SetCompanyId(DestinationRecordRef); 'Currency-CRM Transactioncurrency': SetDefaultSymbolOnCRMTransactioncurrencyIfEmpty(DestinationRecordRef); end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnAfterModifyRecord', '', false, false)] local procedure HandleOnAfterModifyRecord(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if DestinationRecordRef.Number() = Database::Vendor then CRMSynchHelper.UpdateContactOnModifyVendor(DestinationRecordRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Int. Option Synch. Invoke", 'OnAfterModifyOption', '', false, false)] local procedure HandleOnAfterModifyOption(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) var CRMOptionMapping: Record "CRM Option Mapping"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; RecRef: RecordRef; OptionLabel: Text; DocumentType: Option "Order","Quote","Invoice"; begin if not CRMIntegrationManagement.IsCRMIntegrationEnabled() then exit; if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::FromIntegrationTable then begin RecRef := SourceRecordRef; if CRMOptionMapping.IsCRMRecordRefMapped(SourceRecordRef, CRMOptionMapping) then OptionLabel := CRMOptionMapping.GetRecordRefOptionValue(SourceRecordRef); end else begin RecRef := DestinationRecordRef; CRMOptionMapping.SetRange("Record ID", SourceRecordRef.RecordId); if CRMOptionMapping.FindFirst() then OptionLabel := CRMOptionMapping.GetRecordRefOptionValue(DestinationRecordRef); end; if OptionLabel <> '' then begin UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Order, OptionLabel); UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Quote, OptionLabel); UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Invoice, OptionLabel); end; end; local procedure UpdateOrInsertDocumentOptionSet(CRMOptionMapping: Record "CRM Option Mapping"; RecRef: RecordRef; DocumentType: Option "Order","Quote","Invoice"; OptionLabel: Text); var EntityName: Text; FieldName: Text; OptionSetMetadataDictionary: Dictionary of [Integer, Text]; begin CRMOptionMapping.GetDocumentMetadataInfo(RecRef, DocumentType, EntityName, FieldName); if (EntityName <> '') and (FieldName <> '') then begin OptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(EntityName, FieldName); if not OptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(EntityName, FieldName, OptionLabel, CRMOptionMapping."Option Value") else if OptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(EntityName, FieldName, CRMOptionMapping."Option Value", OptionLabel); end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Int. Option Synch. Invoke", 'OnAfterInsertOption', '', false, false)] local procedure HandleOnAfterInsertOption(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) var CRMOptionMapping: Record "CRM Option Mapping"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; RecRef: RecordRef; OptionLabel: Text; DocumentType: Option "Order","Quote","Invoice"; begin if not CRMIntegrationManagement.IsCRMIntegrationEnabled() then exit; if IntegrationTableMapping.Direction = IntegrationTableMapping.Direction::FromIntegrationTable then begin RecRef := SourceRecordRef; if CRMOptionMapping.IsCRMRecordRefMapped(SourceRecordRef, CRMOptionMapping) then OptionLabel := CRMOptionMapping.GetRecordRefOptionValue(SourceRecordRef); end else begin RecRef := DestinationRecordRef; CRMOptionMapping.SetRange("Record ID", SourceRecordRef.RecordId); if CRMOptionMapping.FindFirst() then OptionLabel := CRMOptionMapping.GetRecordRefOptionValue(DestinationRecordRef); end; if OptionLabel <> '' then begin UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Order, OptionLabel); UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Quote, OptionLabel); UpdateOrInsertDocumentOptionSet(CRMOptionMapping, RecRef, DocumentType::Invoice, OptionLabel); end; end; procedure SyncDocumentOptionSets() var CRMOptionMapping: Record "CRM Option Mapping"; OrderPaymentTermsOptionSetMetadataDictionary: Dictionary of [Integer, Text]; OrderFreightTermsOptionSetMetadataDictionary: Dictionary of [Integer, Text]; OrderShippingMethodOptionSetMetadataDictionary: Dictionary of [Integer, Text]; QuotePaymentTermsOptionSetMetadataDictionary: Dictionary of [Integer, Text]; QuoteFreightTermsOptionSetMetadataDictionary: Dictionary of [Integer, Text]; QuoteShippingMethodOptionSetMetadataDictionary: Dictionary of [Integer, Text]; InvoicePaymentTermsOptionSetMetadataDictionary: Dictionary of [Integer, Text]; InvoiceShippingMethodOptionSetMetadataDictionary: Dictionary of [Integer, Text]; OptionLabel: Text; OrderEntityName: Text; QuoteEntityName: Text; InvoiceEntityName: Text; PaymentTermsFieldName: Text; FreightTermsFieldName: Text; ShippingMethodFieldName: Text; begin if CRMOptionMapping.FindSet() then begin OrderEntityName := 'salesorder'; QuoteEntityName := 'quote'; InvoiceEntityName := 'invoice'; PaymentTermsFieldName := 'paymenttermscode'; FreightTermsFieldName := 'freighttermscode'; ShippingMethodFieldName := 'shippingmethodcode'; OrderPaymentTermsOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(OrderEntityName, PaymentTermsFieldName); OrderFreightTermsOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(OrderEntityName, FreightTermsFieldName); OrderShippingMethodOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(OrderEntityName, ShippingMethodFieldName); QuotePaymentTermsOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(QuoteEntityName, PaymentTermsFieldName); QuoteFreightTermsOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(QuoteEntityName, FreightTermsFieldName); QuoteShippingMethodOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(QuoteEntityName, ShippingMethodFieldName); InvoicePaymentTermsOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(InvoiceEntityName, PaymentTermsFieldName); InvoiceShippingMethodOptionSetMetadataDictionary := CDSIntegrationMgt.GetOptionSetMetadata(InvoiceEntityName, ShippingMethodFieldName); repeat OptionLabel := CRMOptionMapping."Option Value Caption"; if OptionLabel <> '' then case CRMOptionMapping."Table ID" of Database::"Payment Terms": begin if not OrderPaymentTermsOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(OrderEntityName, PaymentTermsFieldName, OptionLabel, CRMOptionMapping."Option Value") else if OrderPaymentTermsOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(OrderEntityName, PaymentTermsFieldName, CRMOptionMapping."Option Value", OptionLabel); if not QuotePaymentTermsOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(QuoteEntityName, PaymentTermsFieldName, OptionLabel, CRMOptionMapping."Option Value") else if QuotePaymentTermsOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(QuoteEntityName, PaymentTermsFieldName, CRMOptionMapping."Option Value", OptionLabel); if not InvoicePaymentTermsOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(InvoiceEntityName, PaymentTermsFieldName, OptionLabel, CRMOptionMapping."Option Value") else if InvoicePaymentTermsOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(InvoiceEntityName, PaymentTermsFieldName, CRMOptionMapping."Option Value", OptionLabel); end; Database::"Shipment Method": begin if not OrderFreightTermsOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(OrderEntityName, FreightTermsFieldName, OptionLabel, CRMOptionMapping."Option Value") else if OrderFreightTermsOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(OrderEntityName, FreightTermsFieldName, CRMOptionMapping."Option Value", OptionLabel); if not QuoteFreightTermsOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(QuoteEntityName, FreightTermsFieldName, OptionLabel, CRMOptionMapping."Option Value") else if QuoteFreightTermsOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(QuoteEntityName, FreightTermsFieldName, CRMOptionMapping."Option Value", OptionLabel); end; Database::"Shipping Agent": begin if not OrderShippingMethodOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(OrderEntityName, ShippingMethodFieldName, OptionLabel, CRMOptionMapping."Option Value") else if OrderShippingMethodOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(OrderEntityName, ShippingMethodFieldName, CRMOptionMapping."Option Value", OptionLabel); if not QuoteShippingMethodOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(QuoteEntityName, ShippingMethodFieldName, OptionLabel, CRMOptionMapping."Option Value") else if QuoteShippingMethodOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(QuoteEntityName, ShippingMethodFieldName, CRMOptionMapping."Option Value", OptionLabel); if not InvoiceShippingMethodOptionSetMetadataDictionary.ContainsKey(CRMOptionMapping."Option Value") then CDSIntegrationMgt.InsertOptionSetMetadataWithOptionValue(InvoiceEntityName, ShippingMethodFieldName, OptionLabel, CRMOptionMapping."Option Value") else if InvoiceShippingMethodOptionSetMetadataDictionary.Get(CRMOptionMapping."Option Value") <> OptionLabel then CDSIntegrationMgt.UpdateOptionSetMetadata(InvoiceEntityName, ShippingMethodFieldName, CRMOptionMapping."Option Value", OptionLabel); end; end; until CRMOptionMapping.Next() = 0; end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CDS Integration Mgt.", 'OnHasCompanyIdField', '', false, false)] local procedure HandleOnHasCompanyIdField(TableId: Integer; var HasField: Boolean) begin case TableId of Database::"CRM Account", Database::"CRM Contact", Database::"CRM Invoice", Database::"CRM Quote", Database::"CRM Salesorder", Database::"CRM Opportunity", Database::"CRM Product", Database::"CRM Productpricelevel": HasField := true; end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Int. Rec. Uncouple Invoke", 'OnBeforeUncoupleRecord', '', false, false)] local procedure HandleOnBeforeUncoupleRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef) var HasField: Boolean; begin CDSIntegrationMgt.OnHasCompanyIdField(IntegrationRecordRef.Number(), HasField); if not HasField then exit; if IntegrationRecordRef.IsEmpty() then exit; CDSIntegrationMgt.ResetCompanyId(IntegrationRecordRef); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Int. Rec. Uncouple Invoke", 'OnAfterUncoupleRecord', '', false, false)] local procedure HandleOnAfterUncoupleRecord(IntegrationTableMapping: Record "Integration Table Mapping"; var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef) begin RemoveChildCouplings(LocalRecordRef, IntegrationRecordRef); end; local procedure RemoveChildCouplings(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef) var CRMIntegrationManagement: Codeunit "CRM Integration Management"; ChildContactList: List of [Guid]; begin if GetCoupledChildContacts(LocalRecordRef, IntegrationRecordRef, ChildContactList) then CRMIntegrationManagement.RemoveCoupling(Database::Contact, ChildContactList, false); end; local procedure GetCoupledChildContacts(var LocalRecordRef: RecordRef; var IntegrationRecordRef: RecordRef; var ChildContactList: List of [Guid]): Boolean var Customer: Record Customer; Vendor: Record Vendor; Contact: Record Contact; ContBusRel: Record "Contact Business Relation"; CRMAccount: Record "CRM Account"; CRMContact: Record "CRM Contact"; CRMIntegrationRecord: Record "CRM Integration Record"; CRMID: Guid; begin if IntegrationRecordRef.Number() <> Database::"CRM Account" then exit(false); IntegrationRecordRef.SetTable(CRMAccount); if IsNullGuid(CRMAccount.AccountId) then exit(false); case LocalRecordRef.Number() of Database::Customer: begin LocalRecordRef.SetTable(Customer); if IsNullGuid(Customer.SystemId) then exit(false); ContBusRel.SetRange("Link to Table", ContBusRel."Link to Table"::Customer); ContBusRel.SetRange("No.", Customer."No."); end; Database::Vendor: begin LocalRecordRef.SetTable(Vendor); if IsNullGuid(Vendor.SystemId) then exit(false); ContBusRel.SetRange("Link to Table", ContBusRel."Link to Table"::Vendor); ContBusRel.SetRange("No.", Vendor."No."); end; else exit(false); end; // Get the Company Contact for this Customer or Vendor ContBusRel.SetCurrentKey("Link to Table", "No."); if ContBusRel.FindFirst() then begin // Get all Person Contacts under it Contact.SetCurrentKey("Company Name", "Company No.", Type, Name); Contact.SetRange("Company No.", ContBusRel."Contact No."); Contact.SetRange(Type, Contact.Type::Person); if Contact.FindSet() then // Collect coupled CRM Contacts under the CRM Account the Customer or Vendor is coupled to repeat if CRMIntegrationRecord.FindIDFromRecordID(Contact.RecordId(), CRMID) then begin CRMContact.Get(CRMID); if CRMContact.ParentCustomerId = CRMAccount.AccountId then ChildContactList.Add(Contact.SystemId); end; until Contact.Next() = 0; end; exit(ChildContactList.Count > 0); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Management", 'OnIsCDSIntegrationEnabled', '', false, false)] local procedure HandleOnIsCDSIntegrationEnabled(var isEnabled: Boolean) begin if isEnabled then exit; if CDSIntegrationMgt.IsIntegrationEnabled() then isEnabled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetCDSBaseCurrencyId', '', false, false)] local procedure HandleOnGetCDSBaseCurrencyId(var BaseCurrencyId: Guid; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; BaseCurrencyId := CDSConnectionSetup.BaseCurrencyId; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetCDSBaseCurrencySymbol', '', false, false)] local procedure HandleOnGetCDSBaseCurrencySymbol(var BaseCurrencySymbol: Text[5]; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; BaseCurrencySymbol := CDSConnectionSetup.BaseCurrencySymbol; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetCDSBaseCurrencyPrecision', '', false, false)] local procedure HandleOnGetCDSBaseCurrencyPrecision(var BaseCurrencyPrecision: Integer; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; BaseCurrencyPrecision := CDSConnectionSetup.BaseCurrencyPrecision; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetCDSCurrencyDecimalPrecision', '', false, false)] local procedure HandleOnGetCDSCurrencyDecimalPrecision(var CurrencyDecimalPrecision: Integer; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; CurrencyDecimalPrecision := CDSConnectionSetup.CurrencyDecimalPrecision; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetCDSOwnershipModel', '', false, false)] local procedure HandleOnGetCDSOwnershipModel(var OwnershipModel: Option; var handled: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; begin if handled then exit; if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; OwnershipModel := CDSConnectionSetup."Ownership Model"; handled := true; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Synch. Helper", 'OnGetVendorSyncEnabled', '', false, false)] local procedure HandleOnGetVendorSyncEnabled(var Enabled: Boolean) begin if Enabled then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; Enabled := true; end; [EventSubscriber(ObjectType::Report, Report::"Copy Company", 'OnAfterCreatedNewCompanyByCopyCompany', '', false, false)] local procedure HandleOnAfterCreatedNewCompanyByCopyCompany(NewCompanyName: Text[30]) var CDSConnectionSetup: Record "CDS Connection Setup"; CRMConnectionSetup: Record "CRM Connection Setup"; CDSIntegrationRecord: Record "CRM Integration Record"; begin CDSConnectionSetup.ChangeCompany(NewCompanyName); CDSConnectionSetup.DeleteAll(); CRMConnectionSetup.ChangeCompany(NewCompanyName); CRMConnectionSetup.DeleteAll(); CDSIntegrationRecord.ChangeCompany(NewCompanyName); CDSIntegrationRecord.DeleteAll(); end; [EventSubscriber(ObjectType::Table, Database::Company, 'OnBeforeDeleteEvent', '', false, false)] local procedure DeleteCouplingOnBeforeDeleteCompany(var Rec: Record Company; RunTrigger: Boolean) var CDSConnectionSetup: Record "CDS Connection Setup"; CRMIntegrationRecord: Record "CRM Integration Record"; TenantLicenseState: Codeunit "Tenant License State"; IntegrationTableMappingList: Page "Integration Table Mapping List"; EnumTenantLicenseState: Enum "Tenant License State"; begin if Rec.IsTemporary() then exit; if CDSConnectionSetup.ChangeCompany(Rec.Name) then if CDSConnectionSetup.Get() then if CDSConnectionSetup."Is Enabled" then if CRMIntegrationRecord.ChangeCompany(Rec.Name) then if not CRMIntegrationRecord.IsEmpty() then begin if not GuiAllowed() then if TenantLicenseState.GetLicenseState() in [ EnumTenantLicenseState::Suspended, EnumTenantLicenseState::Deleted, EnumTenantLicenseState::LockedOut] then exit; if GuiAllowed() then if not Confirm(StrSubstNo(CouplingsNeedToBeResetQst, IntegrationTableMappingList.Caption())) then Error(''); end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Rec. Synch. Invoke", 'OnAfterUnchangedRecordHandled', '', false, false)] local procedure OnAfterUnchangedRecordHandled(IntegrationTableMapping: Record "Integration Table Mapping"; SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) var CDSConnectionSetup: Record "CDS Connection Setup"; CRMContact: Record "CRM Contact"; EmptyGuid: Guid; begin if not CDSConnectionSetup.Get() then exit; if not CDSConnectionSetup."Is Enabled" then exit; case GetSourceDestCode(SourceRecordRef, DestinationRecordRef) of 'Contact-CRM Contact': begin DestinationRecordRef.SetTable(CRMContact); if CRMContact.ParentCustomerId = EmptyGuid then begin UpdateCRMContactParentCustomerId(SourceRecordRef, DestinationRecordRef); DestinationRecordRef.Modify(); end end; end; end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"CRM Integration Table Synch.", 'OnQueryPostFilterIgnoreRecord', '', false, false)] procedure OnQueryPostFilterIgnoreRecord(SourceRecordRef: RecordRef; var IgnoreRecord: Boolean) begin if IgnoreRecord then exit; if SourceRecordRef.Number() = Database::Contact then HandleContactQueryPostFilterIgnoreRecord(SourceRecordRef, IgnoreRecord); end; local procedure HandleContactQueryPostFilterIgnoreRecord(SourceRecordRef: RecordRef; var IgnoreRecord: Boolean) var ContactBusinessRelation: Record "Contact Business Relation"; begin if IgnoreRecord then exit; if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; if CRMSynchHelper.IsContactBusinessRelationOptional() then exit; if CRMSynchHelper.FindContactRelatedCustomer(SourceRecordRef, ContactBusinessRelation) then exit; if CRMSynchHelper.FindContactRelatedVendor(SourceRecordRef, ContactBusinessRelation) then exit; IgnoreRecord := true; end; local procedure UpdateCRMContactParentCustomerId(SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) var CRMContact: Record "CRM Contact"; ParentCustomerIdFieldRef: FieldRef; AccountId: Guid; Silent: Boolean; begin if not CDSIntegrationImpl.IsIntegrationEnabled() then exit; Silent := CRMSynchHelper.IsContactBusinessRelationOptional(); if FindParentCRMAccountForContact(SourceRecordRef, Silent, AccountId) then begin // Transfer the parent company id to the ParentCustomerId ParentCustomerIdFieldRef := DestinationRecordRef.Field(CRMContact.FieldNo(ParentCustomerId)); ParentCustomerIdFieldRef.Value := AccountId; end; end; local procedure FindParentCRMAccountForContact(SourceRecordRef: RecordRef; Silent: Boolean; var AccountId: Guid) Result: Boolean var ContactBusinessRelation: Record "Contact Business Relation"; Contact: Record Contact; Customer: Record Customer; Vendor: Record Vendor; CRMIntegrationRecord: Record "CRM Integration Record"; IsHandled: Boolean; begin IsHandled := false; OnBeforeFindParentCRMAccountForContact(SourceRecordRef, Silent, AccountId, Result, IsHandled); if IsHandled then exit(Result); if CRMSynchHelper.FindContactRelatedCustomer(SourceRecordRef, ContactBusinessRelation) then begin if Customer.Get(ContactBusinessRelation."No.") then begin CRMIntegrationRecord.FindIDFromRecordID(Customer.RecordId(), AccountId); exit(true); end; if not Silent then Error(RecordNotFoundErr, Customer.TableCaption(), ContactBusinessRelation."No."); exit(false); end; if CRMSynchHelper.FindContactRelatedVendor(SourceRecordRef, ContactBusinessRelation) then begin if Vendor.Get(ContactBusinessRelation."No.") then begin CRMIntegrationRecord.FindIDFromRecordID(Vendor.RecordId(), AccountId); exit(true); end; if not Silent then Error(RecordNotFoundErr, Vendor.TableCaption(), ContactBusinessRelation."No."); exit(false); end; if not Silent then Error(ContactMustBeRelatedToCustomerOrVendorErr, SourceRecordRef.Field(Contact.FieldNo("No.")).Value()); exit(false); end; local procedure FixPrimaryContactNo(SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef) Result: Boolean var Customer: Record Customer; Vendor: Record Vendor; Contact: Record Contact; CRMContact: Record "CRM Contact"; CRMAccount: Record "CRM Account"; IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; RecRef: RecordRef; RecordModifiedAfterLastSync: Boolean; begin DestinationRecordRef.SetTable(Contact); SourceRecordRef.SetTable(CRMContact); if CRMContact.ParentCustomerIdType <> CRMContact.ParentCustomerIdType::account then exit(false); if IsNullGuid(CRMContact.ParentCustomerId) then exit(false); if FindCustomerByAccountId(CRMContact.ParentCustomerId, Customer) then if Customer."Primary Contact No." = '' then if IntegrationTableMapping.FindMapping(Database::Customer, Database::"CRM Account") then if IntegrationTableMapping.IsFieldMappingEnabled(Customer.FieldNo("Primary Contact No."), CRMAccount.FieldNo(PrimaryContactId), IntegrationTableMapping.Direction::FromIntegrationTable) then begin RecRef.GetTable(Customer); RecordModifiedAfterLastSync := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, RecRef); Customer."Primary Contact No." := Contact."No."; if Contact.Type = Contact.Type::Person then Customer.Contact := Contact.Name; Customer.Modify(); if not RecordModifiedAfterLastSync then begin CRMIntegrationRecord.SetRange("Integration ID", Customer.SystemId); if CRMIntegrationRecord.FindFirst() then begin CRMIntegrationRecord."Last Synch. Modified On" := Customer.SystemModifiedAt; CRMIntegrationRecord.Modify(); end; end; exit(true); end; if FindVendorByAccountId(CRMContact.ParentCustomerId, Vendor) then if Vendor."Primary Contact No." = '' then if IntegrationTableMapping.FindMapping(Database::Vendor, Database::"CRM Account") then if IntegrationTableMapping.IsFieldMappingEnabled(Vendor.FieldNo("Primary Contact No."), CRMAccount.FieldNo(PrimaryContactId), IntegrationTableMapping.Direction::FromIntegrationTable) then begin RecRef.GetTable(Vendor); RecordModifiedAfterLastSync := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, RecRef); Vendor."Primary Contact No." := Contact."No."; if Contact.Type = Contact.Type::Person then Vendor.Contact := Contact.Name; Vendor.Modify(); if not RecordModifiedAfterLastSync then begin CRMIntegrationRecord.SetRange("Integration ID", Vendor.SystemId); if CRMIntegrationRecord.FindFirst() then begin CRMIntegrationRecord."Last Synch. Modified On" := Vendor.SystemModifiedAt; CRMIntegrationRecord.Modify(); end; end; exit(true); end; Result := false; OnAfterFixPrimaryContactNo(SourceRecordRef, DestinationRecordRef, Result); end; local procedure UpdateChildContactsParentCompany(CRMAccountRecordRef: RecordRef) var CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationTableMapping: Record "Integration Table Mapping"; CRMAccount: Record "CRM Account"; CRMContact: Record "CRM Contact"; Contact: Record Contact; ContactRecordRef: RecordRef; CRMContactRecordRef: RecordRef; CompanyId: Guid; begin CRMAccountRecordRef.SetTable(CRMAccount); case CRMAccount.CustomerTypeCode of CRMAccount.CustomerTypeCode::Customer: if not IntegrationTableMapping.FindMapping(Database::Customer, Database::"CRM Account") then exit; CRMAccount.CustomerTypeCode::Vendor: if not IntegrationTableMapping.FindMapping(Database::Vendor, Database::"CRM Account") then exit; else exit; end; if not (IntegrationTableMapping.Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::FromIntegrationTable]) then exit; Contact.SetRange("Company No.", ''); if Contact.IsEmpty() then exit; // all contacts have parent company set if not CDSIntegrationImpl.TryGetCompanyId(CompanyId) then exit; // find and process already synced child contacts CRMContact.SetRange(ParentCustomerIdType, CRMContact.ParentCustomerIdType::account); CRMContact.SetRange(ParentCustomerId, CRMAccount.AccountId); CRMContact.SetRange(CompanyId, CompanyId); if CRMContact.FindSet() then repeat if CRMIntegrationRecord.FindByCRMID(CRMContact.ContactId) then begin CRMContactRecordRef.GetTable(CRMContact); ContactRecordRef.Open(Database::Contact); if ContactRecordRef.GetBySystemId(CRMIntegrationRecord."Integration ID") then begin FixPrimaryContactNo(CRMContactRecordRef, ContactRecordRef); UpdateContactParentCompany(CRMAccount.AccountId, ContactRecordRef); end; ContactRecordRef.Close(); end; until CRMContact.Next() = 0; end; local procedure UpdateContactParentCompany(AccountId: Guid; var ContactRecordRef: RecordRef) var IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationRecord: Record "CRM Integration Record"; Contact: Record Contact; IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; RecordModifiedAfterLastSync: Boolean; OldCompanyNo: Code[20]; NewCompanyNo: Code[20]; begin if not IntegrationTableMapping.FindMapping(Database::Contact, Database::"CRM Contact") then exit; if not (IntegrationTableMapping.Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::FromIntegrationTable]) then exit; Session.LogMessage('0000EOB', UpdateContactParentCompanyTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); RecordModifiedAfterLastSync := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, ContactRecordRef); OldCompanyNo := ContactRecordRef.Field(Contact.FieldNo("Company No.")).Value(); if not CRMSynchHelper.SetContactParentCompany(AccountId, ContactRecordRef) then begin Session.LogMessage('0000EOC', StrSubstNo(UpdateContactParentCompanyFailedTxt, AccountId), Verbosity::Warning, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; NewCompanyNo := ContactRecordRef.Field(Contact.FieldNo("Company No.")).Value(); if NewCompanyNo = OldCompanyNo then begin Session.LogMessage('0000EOD', UpdateContactParentCompanyAlreadySetTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); exit; end; ContactRecordRef.Modify(); if not RecordModifiedAfterLastSync then begin ContactRecordRef.SetTable(Contact); CRMIntegrationRecord.SetRange("Integration ID", Contact.SystemId); if CRMIntegrationRecord.FindFirst() then begin CRMIntegrationRecord."Last Synch. Modified On" := Contact.SystemModifiedAt; CRMIntegrationRecord.Modify(); end; end; Session.LogMessage('0000EOE', UpdateContactParentCompanySuccessfulTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; local procedure FindNewValueForCoupledRecordPK(IntegrationTableMapping: Record "Integration Table Mapping"; SourceFieldRef: FieldRef; DestinationFieldRef: FieldRef; var NewValue: Variant) IsValueFound: Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; RecID: RecordID; CRMID: Guid; IsHandled: Boolean; begin IsHandled := false; OnBeforeFindNewValueForCoupledRecordPK(IntegrationTableMapping, SourceFieldRef, DestinationFieldRef, NewValue, IsValueFound, IsHandled); if IsHandled then exit(IsValueFound); if CRMSynchHelper.FindNewValueForSpecialMapping(SourceFieldRef, NewValue) then exit(true); case IntegrationTableMapping.Direction of IntegrationTableMapping.Direction::ToIntegrationTable: if Format(SourceFieldRef.Value()) = '' then begin NewValue := CRMID; // Blank GUID IsValueFound := true; end else begin if CRMSynchHelper.FindRecordIDByPK(IntegrationTableMapping."Table ID", SourceFieldRef.Value(), RecID) then if CRMIntegrationRecord.FindIDFromRecordID(RecID, NewValue) then exit(true); if CRMSynchHelper.IsClearValueOnFailedSync(SourceFieldRef, DestinationFieldRef) then begin NewValue := CRMID; exit(true); end; Error(RecordMustBeCoupledErr, SourceFieldRef.Name(), SourceFieldRef.Value()); end; IntegrationTableMapping.Direction::FromIntegrationTable: begin CRMID := SourceFieldRef.Value(); if IsNullGuid(CRMID) then begin NewValue := ''; IsValueFound := true; end else begin if CRMIntegrationRecord.FindRecordIDFromID(CRMID, IntegrationTableMapping."Table ID", RecID) then if CRMSynchHelper.FindPKByRecordID(RecID, NewValue) then exit(true); if CRMSynchHelper.IsClearValueOnFailedSync(DestinationFieldRef, SourceFieldRef) then begin NewValue := ''; exit(true); end; Error(RecordMustBeCoupledErr, SourceFieldRef.Name(), CRMID); end; end; end; end; local procedure FixPrimaryContactIdInCDS(SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef): Boolean var Contact: Record Contact; CRMContact: Record "CRM Contact"; CRMAccount: Record "CRM Account"; IntegrationTableMapping: Record "Integration Table Mapping"; CRMIntegrationRecord: Record "CRM Integration Record"; IntegrationRecSynchInvoke: Codeunit "Integration Rec. Synch. Invoke"; CRMRecordRef: RecordRef; CRMAccountModifiedAfterLastSync: Boolean; begin DestinationRecordRef.SetTable(CRMContact); SourceRecordRef.SetTable(Contact); if CRMContact.ParentCustomerIdType <> CRMContact.ParentCustomerIdType::account then exit(false); if IsNullGuid(CRMContact.ParentCustomerId) then exit(false); if not CRMAccount.Get(CRMContact.ParentCustomerId) then exit(false); if not IsNullGuid(CRMAccount.PrimaryContactId) then exit(false); case CRMAccount.CustomerTypeCode of CRMAccount.CustomerTypeCode::Customer: if not IntegrationTableMapping.FindMapping(Database::Customer, Database::"CRM Account") then exit(false); CRMAccount.CustomerTypeCode::Vendor: if not IntegrationTableMapping.FindMapping(Database::Vendor, Database::"CRM Account") then exit(false); end; if not (IntegrationTableMapping.Direction in [IntegrationTableMapping.Direction::Bidirectional, IntegrationTableMapping.Direction::ToIntegrationTable]) then exit(false); CRMRecordRef.GetTable(CRMAccount); CRMAccountModifiedAfterLastSync := IntegrationRecSynchInvoke.WasModifiedAfterLastSynch(IntegrationTableMapping, CRMRecordRef); CRMAccount.PrimaryContactId := CRMContact.ContactId; CRMAccount.Modify(); if not CRMAccountModifiedAfterLastSync then begin CRMIntegrationRecord.SetRange("CRM ID", CRMAccount.AccountId); if CRMIntegrationRecord.FindFirst() then begin CRMIntegrationRecord."Last Synch. CRM Modified On" := CRMAccount.ModifiedOn; CRMIntegrationRecord.Modify(); end; end; exit(true); end; local procedure FindCustomerByAccountId(AccountId: Guid; var Customer: Record Customer): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; CustomerRecordID: RecordID; begin if CRMIntegrationRecord.FindRecordIDFromID(AccountId, DATABASE::Customer, CustomerRecordID) then exit(Customer.Get(CustomerRecordID)); exit(false); end; local procedure FindVendorByAccountId(AccountId: Guid; var Vendor: Record Vendor): Boolean var CRMIntegrationRecord: Record "CRM Integration Record"; VendorRecordID: RecordID; begin if CRMIntegrationRecord.FindRecordIDFromID(AccountId, DATABASE::Vendor, VendorRecordID) then exit(Vendor.Get(VendorRecordID)); exit(false); end; local procedure SetDefaultSymbolOnCRMTransactioncurrencyIfEmpty(var DestinationRecordRef: RecordRef) var TempCRMTransactionCurrency: Record "CRM Transactioncurrency" temporary; CurrencySymbol: Text[10]; begin CurrencySymbol := DestinationRecordRef.Field(TempCRMTransactionCurrency.FieldNo(CurrencySymbol)).Value(); if CurrencySymbol = '' then DestinationRecordRef.Field(TempCRMTransactionCurrency.FieldNo(CurrencySymbol)).Value := DestinationRecordRef.Field(TempCRMTransactionCurrency.FieldNo(ISOCurrencyCode)).Value(); end; local procedure UpdateSalesPersOnBeforeInsertRecord(var DestinationRecordRef: RecordRef) var SalespersonPurchaser: Record "Salesperson/Purchaser"; CRMIntegrationManagement: Codeunit "CRM Integration Management"; DestinationFieldRef: FieldRef; NewCode: Text; IsHandled: Boolean; begin if not (CRMIntegrationManagement.IsCDSIntegrationEnabled() or CRMIntegrationManagement.IsCRMIntegrationEnabled()) then exit; IsHandled := false; OnBeforeSetSalespersonPurchaserCode(DestinationRecordRef, IsHandled); if IsHandled then exit; // We need to create a new code for this SP. // To do so we just do a SP NO. A SalespersonPurchaser.SetFilter(Code, SalespersonPurchaserCodeFilterLbl); if SalespersonPurchaser.FindLast() then NewCode := IncStr(SalespersonPurchaser.Code) else NewCode := StrSubstNo(NewCodePatternTxt, '00001'); DestinationFieldRef := DestinationRecordRef.Field(SalespersonPurchaser.FieldNo(Code)); DestinationFieldRef.Value := NewCode; end; [IntegrationEvent(false, false)] local procedure OnBeforeSetSalespersonPurchaserCode(var DestinationRecordRef: RecordRef; var IsHandled: Boolean) begin end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Integration Table Synch.", 'OnAfterInitSynchJob', '', true, true)] local procedure LogTelemetryOnAfterInitSynchJob(ConnectionType: TableConnectionType; IntegrationTableID: Integer) var IntegrationTableMapping: Record "Integration Table Mapping"; FeatureTelemetry: Codeunit "Feature Telemetry"; IntegrationRecordRef: RecordRef; TelemetryCategories: Dictionary of [Text, Text]; IntegrationTableName: Text; begin if ConnectionType <> TableConnectionType::CRM then exit; FeatureTelemetry.LogUptake('0000H7M', 'Dataverse', Enum::"Feature Uptake Status"::Used); FeatureTelemetry.LogUsage('0000H7N', 'Dataverse', 'Entity sync'); IntegrationTableMapping.SetRange(Type, IntegrationTableMapping.Type::Dataverse); IntegrationTableMapping.SetRange("Delete After Synchronization", false); IntegrationTableMapping.SetRange("Multi Company Synch. Enabled", true); IntegrationTableMapping.SetRange("Table ID", IntegrationTableID); if not IntegrationTableMapping.IsEmpty() then begin FeatureTelemetry.LogUptake('0000LCO', 'Dataverse Multi-Company Synch', Enum::"Feature Uptake Status"::Used); FeatureTelemetry.LogUsage('0000LCQ', 'Dataverse Multi-Company Synch', 'Entity sync'); Session.LogMessage('0000LCS', 'Multi-Company Synch Enabled', Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; IntegrationTableMapping.SetRange("Table ID"); IntegrationTableMapping.SetRange("Integration Table ID", IntegrationTableID); if not IntegrationTableMapping.IsEmpty() then begin FeatureTelemetry.LogUptake('0000LCP', 'Dataverse Multi-Company Synch', Enum::"Feature Uptake Status"::Used); FeatureTelemetry.LogUsage('0000LCR', 'Dataverse Multi-Company Synch', 'Entity sync'); Session.LogMessage('0000LCT', 'Multi-Company Synch Enabled', Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', CategoryTok); end; TelemetryCategories.Add('Category', CategoryTok); TelemetryCategories.Add('IntegrationTableID', Format(IntegrationTableID)); if TryCalculateTableName(IntegrationRecordRef, IntegrationTableID, IntegrationTableName) then TelemetryCategories.Add('IntegrationTableName', IntegrationTableName); if IntegrationTableID in [ Database::"CRM Account", Database::"CRM Contact", Database::"CRM Transactioncurrency", Database::"CRM Systemuser"] then begin Session.LogMessage('0000FMC', 'Synching a base entity.', Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, TelemetryCategories); FeatureTelemetry.LogUsage('0000H7O', 'Dataverse', 'Base entity synch'); FeatureTelemetry.LogUsage('0000IIL', 'Dataverse Base Entities', 'Base entity synch'); FeatureTelemetry.LogUptake('0000KMT', 'Dataverse Base Entities', Enum::"Feature Uptake Status"::Used); exit; end; if IntegrationTableID > MinCustomTableId() then begin Session.LogMessage('0000FMD', 'Synching a custom entity.', Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, TelemetryCategories); FeatureTelemetry.LogUsage('0000H7P', 'Dataverse', 'Custom entity synch'); end; end; [TryFunction] local procedure TryCalculateTableName(var IntegrationRecordRef: RecordRef; TableId: Integer; var TableName: Text) begin IntegrationRecordRef.Open(TableId); TableName := IntegrationRecordRef.Name(); end; local procedure MinCustomTableId(): Integer begin exit(50000); end; [Scope('OnPrem')] procedure SetCompanyId(DestinationRecordRef: RecordRef) begin if CDSIntegrationImpl.CheckCompanyIdNoTelemetry(DestinationRecordRef) then exit; CDSIntegrationMgt.SetCompanyId(DestinationRecordRef); end; [Scope('OnPrem')] procedure SetOwnerId(var SourceRecordRef: RecordRef; var DestinationRecordRef: RecordRef) var CDSConnectionSetup: Record "CDS Connection Setup"; UserId: Guid; begin CDSConnectionSetup.Get(); case CDSConnectionSetup."Ownership Model" of CDSConnectionSetup."Ownership Model"::Team: CDSIntegrationMgt.SetOwningTeam(DestinationRecordRef); CDSConnectionSetup."Ownership Model"::Person: begin UserId := CRMSynchHelper.GetCoupledCDSUserId(SourceRecordRef); if not IsNullGuid(UserId) then CDSIntegrationMgt.SetOwningUser(DestinationRecordRef, UserId, true) else CDSIntegrationMgt.SetOwningTeam(DestinationRecordRef); end; end; end; local procedure GetCoupledSalespersonPurchaserCode(SourceRecordRef: RecordRef): Code[20] var CRMAccount: Record "CRM Account"; CRMContact: Record "CRM Contact"; CRMSystemuser: Record "CRM Systemuser"; CRMIntegrationRecord: Record "CRM Integration Record"; SalesPersonPurchaser: Record "Salesperson/Purchaser"; CDSUserId: Guid; begin case SourceRecordRef.Number() of Database::"CRM Account": begin SourceRecordRef.SetTable(CRMAccount); if CRMAccount.OwnerIdType <> CRMAccount.OwnerIdType::systemuser then exit(''); CDSUserId := CRMAccount.OwnerId; end; Database::"CRM Contact": begin SourceRecordRef.SetTable(CRMContact); if CRMContact.OwnerIdType <> CRMContact.OwnerIdType::systemuser then exit(''); CDSUserId := CRMContact.OwnerId; end; else exit(''); end; if not CRMIntegrationRecord.FindByCRMID(CDSUserId) then Error(RecordMustBeCoupledExtErr, CRMSystemuser.TableCaption(), CDSUserId, SalesPersonPurchaser.TableCaption()); if not SalesPersonPurchaser.GetBySystemId(CRMIntegrationRecord."Integration ID") then exit(''); exit(SalesPersonPurchaser.Code); end; local procedure GetSourceDestCode(SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef): Text begin if (SourceRecordRef.Number() <> 0) and (DestinationRecordRef.Number() <> 0) then exit(StrSubstNo('%1-%2', SourceRecordRef.Name(), DestinationRecordRef.Name())); exit(''); end; local procedure ShowError(ActivityDescription: Text[128]; ErrorMessage: Text) var MyNotifications: Record "My Notifications"; SystemInitialization: Codeunit "System Initialization"; begin if (not SystemInitialization.IsInProgress()) and (GetExecutionContext() = ExecutionContext::Normal) then Error(ErrorMessage); MyNotifications.InsertDefault(GetCDSNotificationId(), ActivityDescription, ErrorMessage, true); end; local procedure GetCDSNotificationId(): Guid begin exit('877d4577-dafa-4b91-9a03-9f7c6402d883'); end; local procedure FindIntegrationUserId(): Guid var CDSConnectionSetup: Record "CDS Connection Setup"; CRMSystemuser: Record "CRM Systemuser"; IntegrationUserId: Guid; begin CDSConnectionSetup.Get(); case CDSConnectionSetup."Authentication Type" of CDSConnectionSetup."Authentication Type"::Office365, CDSConnectionSetup."Authentication Type"::OAuth: CRMSystemuser.SetRange(InternalEMailAddress, CDSConnectionSetup."User Name"); CDSConnectionSetup."Authentication Type"::AD, CDSConnectionSetup."Authentication Type"::IFD: CRMSystemuser.SetRange(DomainName, CDSConnectionSetup."User Name"); end; if CRMSystemuser.FindFirst() then IntegrationUserId := CRMSystemuser.SystemUserId; exit(IntegrationUserId); end; [IntegrationEvent(false, false)] local procedure OnAfterFixPrimaryContactNo(SourceRecordRef: RecordRef; DestinationRecordRef: RecordRef; var Result: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFindParentCRMAccountForContact(SourceRecordRef: RecordRef; Silent: Boolean; var AccountId: Guid; var Result: Boolean; var IsHandled: Boolean) begin end; [IntegrationEvent(false, false)] local procedure OnBeforeFindNewValueForCoupledRecordPK(IntegrationTableMapping: Record "Integration Table Mapping"; SourceFieldRef: FieldRef; DestinationFieldRef: FieldRef; var NewValueVariant: Variant; var IsValueFound: Boolean; var IsHandled: Boolean) begin end;}