Codeunit 5346 CRM Sales Document Posting Mgt

Base Application, Microsoft.Integration.D365Sales

src/Layers/W1/BaseApp/Integration/D365Sales/CRMSalesDocumentPostingMgt.Codeunit.al274 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.D365Sales;using Microsoft.Finance.GeneralLedger.Posting;using Microsoft.Integration.Dataverse;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Posting;codeunit 5346 "CRM Sales Document Posting Mgt"{    SingleInstance = true;    trigger OnRun()    begin    end;    var        CRMIntegrationManagement: Codeunit "CRM Integration Management";        CRMSalesOrderId: Guid;        DeletedCoupledOrderNo: Code[20];        DeletedCoupledOrderYourReference: Text[35];        CRMOrderHasBeenPostedMsg: Label '%1 ''%2'' has been posted in %3.', Comment = '%1=Document Type;%2=Document Id;%3=The name of our product';        CRMInvoiceHasBeenPostedMsg: Label 'Invoice ''%1'' for order ''%2'' has been posted in %3.', Comment = '%1=Invoice number;%2=Order number;%3=The name of our product';    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnBeforeDeleteAfterPosting', '', false, false)]    local procedure SetSalesOrderIdsOnSalesHeaderDeletion(var SalesHeader: Record "Sales Header"; var SalesInvoiceHeader: Record "Sales Invoice Header"; var SalesCrMemoHeader: Record "Sales Cr.Memo Header"; var SkipDelete: Boolean; CommitIsSuppressed: Boolean; EverythingInvoiced: Boolean; var TempSalesLineGlobal: Record "Sales Line" temporary)    var        CRMIntegrationRecord: Record "CRM Integration Record";    begin        DeletedCoupledOrderNo := '';        DeletedCoupledOrderYourReference := '';        Clear(CRMSalesOrderId);        if (SalesHeader."Document Type" <> SalesHeader."Document Type"::Order) then            exit;        if not CRMIntegrationManagement.IsCRMIntegrationEnabled() then            exit;        if CRMIntegrationRecord.FindIDFromRecordID(SalesHeader.RecordId, CRMSalesOrderId) then begin            DeletedCoupledOrderNo := SalesHeader."No.";            DeletedCoupledOrderYourReference := SalesHeader."Your Reference";        end;    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnAfterPostSalesDoc', '', false, false)]    local procedure PostCRMSalesDocumentOnAfterPostSalesDoc(var SalesHeader: Record "Sales Header"; var GenJnlPostLine: Codeunit "Gen. Jnl.-Post Line"; SalesShptHdrNo: Code[20]; RetRcpHdrNo: Code[20]; SalesInvHdrNo: Code[20]; SalesCrMemoHdrNo: Code[20])    var        CRMConnectionSetup: Record "CRM Connection Setup";        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforePostCRMSalesDocumentOnAfterPostSalesDoc(SalesHeader, IsHandled);        if IsHandled then            exit;        if not CRMConnectionSetup.IsEnabled() then            exit;        if CRMConnectionSetup.IsBidirectionalSalesOrderIntEnabled() then            exit;        Codeunit.Run(Codeunit::"CRM Integration Management");        AddPostedSalesDocumentToCRMAccountWall(SalesHeader, SalesInvHdrNo);        if not IsNullGuid(CRMSalesOrderId) then // Should be set by SetOrderOnSalesHeaderDeletion            SetCRMSalesOrderStateAsInvoiced();    end;    local procedure AddPostedSalesDocumentToCRMAccountWall(var SalesHeader: Record "Sales Header"; SalesInvHdrNo: Code[20])    var        Customer: Record Customer;        SalesInvoiceHeader: Record "Sales Invoice Header";        SalesOrderHeader: Record "Sales Header";        CRMPostBuffer: Record "CRM Post Buffer";        CRMIntegrationRecord: Record "CRM Integration Record";        CRMSetupDefaults: Codeunit "CRM Setup Defaults";    begin        if not (SalesHeader."Document Type" in [SalesHeader."Document Type"::Order, SalesHeader."Document Type"::Invoice]) then            exit;        if not CRMSetupDefaults.GetAddPostedSalesDocumentToCRMAccountWallConfig() then            exit;        Customer.Get(SalesHeader."Sell-to Customer No.");        case SalesHeader."Document Type" of            SalesHeader."Document Type"::Order:                if (SalesHeader."No." = DeletedCoupledOrderNo) then                    CreateCRMPostBufferEntry(Customer.RecordId, Database::Customer, CRMPostBuffer.ChangeType::SalesInvHeaderCreated, StrSubstNo(CRMOrderHasBeenPostedMsg, SalesHeader."Document Type", DeletedCoupledOrderYourReference, ProductName.Short()))                else                    if SalesOrderHeader.Get(SalesOrderHeader."Document Type"::Order, SalesHeader."No.") then                        if CRMIntegrationRecord.FindByRecordID(SalesOrderHeader.RecordId) then                            CreateCRMPostBufferEntry(Customer.RecordId, Database::Customer, CRMPostBuffer.ChangeType::SalesInvHeaderCreated, StrSubstNo(CRMOrderHasBeenPostedMsg, SalesHeader."Document Type", SalesOrderHeader."Your Reference", ProductName.Short()));            SalesHeader."Document Type"::Invoice:                if SalesInvoiceHeader.Get(SalesInvHdrNo) then                    if (SalesInvoiceHeader."Your Reference" <> '') and (SalesInvoiceHeader."Your Reference" = DeletedCoupledOrderYourReference) then                        CreateCRMPostBufferEntry(Customer.RecordId, Database::Customer, CRMPostBuffer.ChangeType::SalesInvHeaderCreated, StrSubstNo(CRMInvoiceHasBeenPostedMsg, SalesInvoiceHeader."No.", SalesInvoiceHeader."Your Reference", ProductName.Short()))                    else                        if SalesOrderHeader.Get(SalesOrderHeader."Document Type"::Order, SalesInvoiceHeader."Order No.") then                            if CRMIntegrationRecord.FindByRecordID(SalesOrderHeader.RecordId) then                                CreateCRMPostBufferEntry(Customer.RecordId, Database::Customer, CRMPostBuffer.ChangeType::SalesInvHeaderCreated, StrSubstNo(CRMInvoiceHasBeenPostedMsg, SalesInvoiceHeader."No.", SalesOrderHeader."Your Reference", ProductName.Short()));        end;    end;    local procedure SetCRMSalesOrderStateAsInvoiced()    var        CRMSalesorder: Record "CRM Salesorder";    begin        if CRMSalesorder.Get(CRMSalesOrderId) then begin            CRMSalesorder.StateCode := CRMSalesorder.StateCode::Invoiced;            CRMSalesorder.StatusCode := CRMSalesorder.StatusCode::Invoiced;            CRMSalesorder.Modify();        end;        Clear(CRMSalesOrderId);    end;    procedure CheckShippedOrders(var SalesHeaderOrder: Record "Sales Header")    var        CRMIntegrationRecord: Record "CRM Integration Record";        CRMConnectionSetup: Record "CRM Connection Setup";        ConnectionInitialized: Boolean;    begin        if not CRMConnectionSetup.IsEnabled() then            exit;        if CRMConnectionSetup.IsBidirectionalSalesOrderIntEnabled() then            exit;        if SalesHeaderOrder.FindSet() then            repeat                if IsSalesOrderFullyInvoiced(SalesHeaderOrder) then                    if CRMIntegrationRecord.FindIDFromRecordID(SalesHeaderOrder.RecordId, CRMSalesOrderId) then begin                        if not ConnectionInitialized then begin                            Codeunit.Run(Codeunit::"CRM Integration Management");                            ConnectionInitialized := true;                        end;                        SetCRMSalesOrderStateAsInvoiced();                    end;            until SalesHeaderOrder.Next() = 0;    end;    internal procedure IsSalesOrderFullyInvoiced(SalesHeader: Record "Sales Header"): Boolean    var        SalesLine: Record "Sales Line";    begin        SalesLine.SetRange("Document Type", SalesHeader."Document Type");        SalesLine.SetRange("Document No.", SalesHeader."No.");        SalesLine.SetFilter("Quantity Invoiced", '<>0');        if SalesLine.FindFirst() then begin            SalesLine.SetRange("Quantity Invoiced");            SalesLine.SetFilter("Outstanding Quantity", '<>0');            if SalesLine.IsEmpty() then begin                SalesLine.SetRange("Outstanding Quantity");                SalesLine.SetFilter("Qty. Shipped Not Invoiced", '<>0');                exit(SalesLine.IsEmpty);            end;        end;        exit(false);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnAfterReleaseSalesDoc', '', false, false)]    local procedure CreateCRMPostOnAfterReleaseSalesDoc(var SalesHeader: Record "Sales Header")    var        CRMPostBuffer: Record "CRM Post Buffer";        CRMConnectionSetup: Record "CRM Connection Setup";    begin        if not (SalesHeader."Document Type" = SalesHeader."Document Type"::Order) then            exit;        if not CRMConnectionSetup.IsEnabled() then            exit;        CreateCRMPostBufferEntry(SalesHeader.RecordId, CRMPostBuffer.ChangeType::SalesDocReleased);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Release Sales Document", 'OnAfterReleaseSalesDoc', '', false, false)]    local procedure CreateACRMPostOnAfterReleaseSalesDoc(var SalesHeader: Record "Sales Header"; PreviewMode: Boolean; var LinesWereModified: Boolean)    var        CRMPostBuffer: Record "CRM Post Buffer";        CRMConnectionSetup: Record "CRM Connection Setup";    begin        if PreviewMode then            exit;        if not (SalesHeader."Document Type" = SalesHeader."Document Type"::Order) then            exit;        if not CRMConnectionSetup.IsEnabled() then            exit;        CreateCRMPostBufferEntry(SalesHeader.RecordId, CRMPostBuffer.ChangeType::SalesDocReleased);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnAfterSalesShptHeaderInsert', '', false, false)]    local procedure CreateACRMPostOnAfterSalesShptHeaderInsert(var SalesShipmentHeader: Record "Sales Shipment Header"; SalesHeader: Record "Sales Header"; SuppressCommit: Boolean)    var        CRMPostBuffer: Record "CRM Post Buffer";        CRMConnectionSetup: Record "CRM Connection Setup";    begin        if not (SalesHeader."Document Type" = SalesHeader."Document Type"::Order) then            exit;        if not CRMConnectionSetup.IsEnabled() then            exit;        CreateCRMPostBufferEntry(SalesHeader.RecordId, CRMPostBuffer.ChangeType::SalesShptHeaderCreated);    end;    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Sales-Post", 'OnAfterSalesInvHeaderInsert', '', false, false)]    local procedure CreateACRMPostOnAfterSalesInvHeaderInsert(var SalesInvHeader: Record "Sales Invoice Header"; SalesHeader: Record "Sales Header"; CommitIsSuppressed: Boolean)    var        CRMPostBuffer: Record "CRM Post Buffer";        CRMConnectionSetup: Record "CRM Connection Setup";    begin        if not (SalesHeader."Document Type" = SalesHeader."Document Type"::Order) then            exit;        if not CRMConnectionSetup.IsEnabled() then            exit;        CreateCRMPostBufferEntry(SalesHeader.RecordId, CRMPostBuffer.ChangeType::SalesInvHeaderCreated);    end;    local procedure CreateCRMPostBufferEntry(RecId: RecordID; ChangeType: Option)    var        CRMPostBuffer: Record "CRM Post Buffer";        [SecurityFiltering(SecurityFilter::Ignored)]        CRMPostBuffer2: Record "CRM Post Buffer";    begin        if not CRMPostBuffer2.WritePermission() then            exit;        CRMPostBuffer.ID := CreateGuid();        CRMPostBuffer."Table ID" := Database::"Sales Header";        CRMPostBuffer.RecId := RecId;        CRMPostBuffer.ChangeType := ChangeType;        CRMPostBuffer.ChangeDateTime := CurrentDateTime;        CRMPostBuffer.Insert();    end;    local procedure CreateCRMPostBufferEntry(RecId: RecordID; TableId: Integer; ChangeType: Option; Message: Text)    var        CRMPostBuffer: Record "CRM Post Buffer";        [SecurityFiltering(SecurityFilter::Ignored)]        CRMPostBuffer2: Record "CRM Post Buffer";    begin        if not CRMPostBuffer2.WritePermission() then            exit;        CRMPostBuffer.ID := CreateGuid();        CRMPostBuffer."Table ID" := TableId;        CRMPostBuffer.RecId := RecId;        CRMPostBuffer.ChangeType := ChangeType;        CRMPostBuffer.ChangeDateTime := CurrentDateTime;        CRMPostBuffer.Message := CopyStr(Message, 1, MaxStrLen(CRMPostBuffer.Message));        CRMPostBuffer.Insert();    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePostCRMSalesDocumentOnAfterPostSalesDoc(SalesHeader: Record "Sales Header"; var IsHandled: Boolean)    begin    end;}