Codeunit 8004 Post Sub. Contract Renewal

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Contract Renewal/Codeunits/PostSubContractRenewal.Codeunit.al376 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Purchases.History;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;codeunit 8004 "Post Sub. Contract Renewal"{    TableNo = "Sales Header";    trigger OnRun()    begin        RunCheck(Rec);        Post(Rec);    end;    local procedure RunCheck(var SalesHeader: Record "Sales Header")    var        Customer: Record Customer;        SalesServiceCommitment: Record "Sales Subscription Line";        SalesLine: Record "Sales Line";        ContractRenewalMgt: Codeunit "Sub. Contract Renewal Mgt.";        NoContractRenewalLinesFoundErr: Label 'Contract Renewal cannot be executed: no contract Renewal lines found in %1 %2.', Comment = '%1 = SalesHeader."Document Type", %2 = SalesHeader."No."';    begin        SalesHeader.TestField("Document Type", SalesHeader."Document Type"::Order);        if not ContractRenewalMgt.IsContractRenewal(SalesHeader) then            Error(NoContractRenewalLinesFoundErr, SalesHeader."Document Type", SalesHeader."No.");        Customer.Get(SalesHeader."Sell-to Customer No.");        Customer.CheckBlockedCustOnDocs(Customer, SalesHeader."Document Type"::Order, true, false);        if SalesHeader."Sell-to Customer No." <> SalesHeader."Bill-to Customer No." then begin            Customer.Get(SalesHeader."Bill-to Customer No.");            Customer.CheckBlockedCustOnDocs(Customer, SalesHeader."Document Type"::Order, true, false);        end;        ContractRenewalMgt.FilterSalesLinesWithTypeServiceObject(SalesLine, SalesHeader);        if SalesLine.FindSet() then            repeat                if SalesLine."Quantity Shipped" <> SalesLine.Quantity then begin                    SalesServiceCommitment.FilterOnSalesLine(SalesLine);                    if SalesServiceCommitment.FindSet() then                        repeat                            SalesServiceCommitment.TestField("Subscription Header No.");                            SalesServiceCommitment.TestField("Subscription Line Entry No.");                        until SalesServiceCommitment.Next() = 0;                end;            until SalesLine.Next() = 0;    end;    local procedure Post(var SalesHeader: Record "Sales Header")    var        SalesLine: Record "Sales Line";        ContractRenewalMgt: Codeunit "Sub. Contract Renewal Mgt.";    begin        ContractRenewalMgt.FilterSalesLinesWithTypeServiceObject(SalesLine, SalesHeader);        if SalesLine.FindSet() then            repeat                if SalesLine."Quantity Shipped" <> SalesLine.Quantity then begin                    CreatePlannedServiceCommitments(SalesHeader, SalesLine);                    ProcessPlannedServiceCommitment(SalesLine);                    SetQuantites(SalesLine);                end;            until SalesLine.Next() = 0;    end;    local procedure CreatePlannedServiceCommitments(var SalesHeader: Record "Sales Header"; var SalesLine: Record "Sales Line")    var        SalesServiceCommitment: Record "Sales Subscription Line";    begin        SalesServiceCommitment.FilterOnSalesLine(SalesLine);        if SalesServiceCommitment.FindSet() then            repeat                InsertPlannedServiceCommitmentFromSalesServiceCommitment(SalesHeader, SalesLine, SalesServiceCommitment);            until SalesServiceCommitment.Next() = 0;    end;    local procedure InsertPlannedServiceCommitmentFromSalesServiceCommitment(SalesHeader: Record "Sales Header"; SalesLine: Record "Sales Line"; SalesServiceCommitment: Record "Sales Subscription Line")    var        PlannedServiceCommitment: Record "Planned Subscription Line";        ServiceCommitment: Record "Subscription Line";        TempServiceCommitment: Record "Subscription Line" temporary;        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeInsertPlannedSubscriptionLineFromSalesSubscriptionLine(SalesLine, SalesServiceCommitment, IsHandled);        if IsHandled then            exit;        SalesServiceCommitment.TestField("Subscription Header No.");        SalesServiceCommitment.TestField("Subscription Line Entry No.");        ServiceCommitment.Get(SalesServiceCommitment."Subscription Line Entry No.");        TempServiceCommitment.Init();        TempServiceCommitment."Subscription Header No." := SalesServiceCommitment."Subscription Header No.";        TempServiceCommitment."Entry No." := SalesServiceCommitment."Subscription Line Entry No.";        TempServiceCommitment."Customer Price Group" := SalesLine."Customer Price Group";        if SalesServiceCommitment."Agreed Sub. Line Start Date" <> 0D then            TempServiceCommitment.Validate("Subscription Line Start Date", SalesServiceCommitment."Agreed Sub. Line Start Date")        else            if Format(SalesServiceCommitment."Sub. Line Start Formula") = '' then                TempServiceCommitment.Validate("Subscription Line Start Date", SalesLine."Shipment Date")            else                TempServiceCommitment.Validate("Subscription Line Start Date", CalcDate(SalesServiceCommitment."Sub. Line Start Formula", SalesLine."Shipment Date"));        if (TempServiceCommitment."Subscription Line Start Date" <> 0D) and (Format(SalesServiceCommitment."Initial Term") <> '') then begin            TempServiceCommitment."Subscription Line End Date" := CalcDate(SalesServiceCommitment."Initial Term", TempServiceCommitment."Subscription Line Start Date");            TempServiceCommitment."Subscription Line End Date" := CalcDate('<-1D>', TempServiceCommitment."Subscription Line End Date");        end;        TempServiceCommitment.CopyFromSalesServiceCommitment(SalesServiceCommitment);        TempServiceCommitment.CalculateSubscriptionDates();        TempServiceCommitment.SetCurrencyData(SalesHeader."Currency Factor", SalesHeader."Posting Date", SalesHeader."Currency Code");        TempServiceCommitment.SetLCYFields(true);        TempServiceCommitment.SetDefaultDimensions(true);        TempServiceCommitment.GetCombinedDimensionSetID(SalesLine."Dimension Set ID", TempServiceCommitment."Dimension Set ID");        PlannedServiceCommitment.TransferFields(TempServiceCommitment, true);        PlannedServiceCommitment."Sales Order No." := SalesHeader."No.";        PlannedServiceCommitment."Sales Order Line No." := SalesLine."Line No.";        PlannedServiceCommitment."Subscription Contract No." := ServiceCommitment."Subscription Contract No.";        PlannedServiceCommitment."Subscription Contract Line No." := ServiceCommitment."Subscription Contract Line No.";        PlannedServiceCommitment."Type Of Update" := Enum::"Type Of Price Update"::"Contract Renewal";        PlannedServiceCommitment.Insert(false);        OnAfterInsertPlannedSubscriptionLineFromSalesSubscriptionLine(SalesLine, TempServiceCommitment, PlannedServiceCommitment);    end;    local procedure ProcessPlannedServiceCommitment(SalesLine: Record "Sales Line")    var        PlannedServiceCommitment: Record "Planned Subscription Line";    begin        PlannedServiceCommitment.Reset();        PlannedServiceCommitment.SetCurrentKey("Sales Order No.");        PlannedServiceCommitment.SetRange("Sales Order No.", SalesLine."Document No.");        PlannedServiceCommitment.SetRange("Sales Order Line No.", SalesLine."Line No.");        if PlannedServiceCommitment.FindSet() then            repeat                ProcessPlannedServiceCommitment(PlannedServiceCommitment);            until PlannedServiceCommitment.Next() = 0;    end;    internal procedure ProcessPlannedServCommsForPostedSalesInvoice(var SalesInvoiceHeader: Record "Sales Invoice Header")    var        SalesInvoiceLine: Record "Sales Invoice Line";        CustomerContractLine: Record "Cust. Sub. Contract Line";        TempPlannedServiceCommitment: Record "Planned Subscription Line" temporary;    begin        DropPlannedServiceCommitmentBuffer(TempPlannedServiceCommitment);        SalesInvoiceLine.Reset();        SalesInvoiceLine.SetRange("Document No.", SalesInvoiceHeader."No.");        SalesInvoiceLine.SetFilter("Subscription Contract No.", '<>%1', '');        SalesInvoiceLine.SetFilter("Subscription Contract Line No.", '<>%1', 0);        if SalesInvoiceLine.FindSet() then begin            CustomerContractLine.SetLoadFields("Subscription Header No.", "Subscription Line Entry No.");            repeat                if CustomerContractLine.Get(SalesInvoiceLine."Subscription Contract No.", SalesInvoiceLine."Subscription Contract Line No.") then                    CreatePlannedServiceCommitmentBuffer(TempPlannedServiceCommitment, CustomerContractLine."Subscription Header No.", CustomerContractLine."Subscription Line Entry No.");            until SalesInvoiceLine.Next() = 0;        end;        ProcessPlannedServiceCommitmentBuffer(TempPlannedServiceCommitment);    end;    internal procedure ProcessPlannedServCommsForPostedSalesCreditMemo(var SalesCrMemoHeader: Record "Sales Cr.Memo Header")    var        SalesCrMemoLine: Record "Sales Cr.Memo Line";        CustomerContractLine: Record "Cust. Sub. Contract Line";        ServiceCommitment: Record "Subscription Line";        ServiceCommitmentArchive: Record "Subscription Line Archive";    begin        SalesCrMemoLine.SetRange("Document No.", SalesCrMemoHeader."No.");        SalesCrMemoLine.SetFilter("Subscription Contract No.", '<>%1', '');        SalesCrMemoLine.SetFilter("Subscription Contract Line No.", '<>%1', 0);        if SalesCrMemoLine.FindSet() then begin            CustomerContractLine.SetLoadFields("Subscription Header No.", "Subscription Line Entry No.");            repeat                if CustomerContractLine.Get(SalesCrMemoLine."Subscription Contract No.", SalesCrMemoLine."Subscription Contract Line No.") then begin                    CustomerContractLine.GetServiceCommitment(ServiceCommitment);                    if ServiceCommitment.ServiceCommitmentArchiveExistsForPeriodExists(ServiceCommitmentArchive, SalesCrMemoLine."Recurring Billing from", SalesCrMemoLine."Recurring Billing to") then begin                        CreatePlannedServiceCommitmentFromServiceCommitment(ServiceCommitment, ServiceCommitmentArchive);                        ServiceCommitment.UpdateServiceCommitmentFromServiceCommitmentArchive(ServiceCommitmentArchive);                    end;                end;            until SalesCrMemoLine.Next() = 0;        end;    end;    internal procedure ProcessPlannedServCommsForPostedPurchaseInvoice(var PurchInvHeader: Record "Purch. Inv. Header")    var        PurchInvLine: Record "Purch. Inv. Line";        VendorContractLine: Record "Vend. Sub. Contract Line";        TempPlannedServiceCommitment: Record "Planned Subscription Line" temporary;    begin        DropPlannedServiceCommitmentBuffer(TempPlannedServiceCommitment);        PurchInvLine.Reset();        PurchInvLine.SetRange("Document No.", PurchInvHeader."No.");        PurchInvLine.SetFilter("Subscription Contract No.", '<>%1', '');        PurchInvLine.SetFilter("Subscription Contract Line No.", '<>%1', 0);        if PurchInvLine.FindSet() then begin            VendorContractLine.SetLoadFields("Subscription Header No.", "Subscription Line Entry No.");            repeat                if VendorContractLine.Get(PurchInvLine."Subscription Contract No.", PurchInvLine."Subscription Contract Line No.") then                    CreatePlannedServiceCommitmentBuffer(TempPlannedServiceCommitment, VendorContractLine."Subscription Header No.", VendorContractLine."Subscription Line Entry No.");            until PurchInvLine.Next() = 0;        end;        ProcessPlannedServiceCommitmentBuffer(TempPlannedServiceCommitment);    end;    internal procedure ProcessPlannedServCommsForPostedPurchaseCreditMemo(var PurchCrMemoHdr: Record "Purch. Cr. Memo Hdr.")    var        PurchCrMemoLine: Record "Purch. Cr. Memo Line";        VendorContractLine: Record "Vend. Sub. Contract Line";        ServiceCommitment: Record "Subscription Line";        ServiceCommitmentArchive: Record "Subscription Line Archive";    begin        PurchCrMemoLine.SetRange("Document No.", PurchCrMemoHdr."No.");        PurchCrMemoLine.SetFilter("Subscription Contract No.", '<>%1', '');        PurchCrMemoLine.SetFilter("Subscription Contract Line No.", '<>%1', 0);        if PurchCrMemoLine.FindSet() then begin            VendorContractLine.SetLoadFields("Subscription Header No.", "Subscription Line Entry No.");            repeat                if VendorContractLine.Get(PurchCrMemoLine."Subscription Contract No.", PurchCrMemoLine."Subscription Contract Line No.") then begin                    VendorContractLine.GetServiceCommitment(ServiceCommitment);                    if ServiceCommitment.ServiceCommitmentArchiveExistsForPeriodExists(ServiceCommitmentArchive, PurchCrMemoLine."Recurring Billing from", PurchCrMemoLine."Recurring Billing to") then begin                        CreatePlannedServiceCommitmentFromServiceCommitment(ServiceCommitment, ServiceCommitmentArchive);                        ServiceCommitment.UpdateServiceCommitmentFromServiceCommitmentArchive(ServiceCommitmentArchive);                    end;                end;            until PurchCrMemoLine.Next() = 0;        end;    end;    local procedure DropPlannedServiceCommitmentBuffer(var TempPlannedServiceCommitment: Record "Planned Subscription Line" temporary)    begin        TempPlannedServiceCommitment.Reset();        if not TempPlannedServiceCommitment.IsEmpty() then            TempPlannedServiceCommitment.DeleteAll(false);    end;    local procedure CreatePlannedServiceCommitmentBuffer(var TempPlannedServiceCommitment: Record "Planned Subscription Line" temporary; ServiceObjectNo: Code[20]; ServiceCommitmentEntryNo: Integer)    begin        if not TempPlannedServiceCommitment.Get(ServiceCommitmentEntryNo) then begin            TempPlannedServiceCommitment."Subscription Header No." := ServiceObjectNo;            TempPlannedServiceCommitment."Entry No." := ServiceCommitmentEntryNo;            TempPlannedServiceCommitment.Insert(false);        end;    end;    local procedure CreatePlannedServiceCommitmentFromServiceCommitment(ServiceCommitment: Record "Subscription Line"; ServiceCommitmentArchive: Record "Subscription Line Archive")    var        PlannedServiceCommitment: Record "Planned Subscription Line";    begin        PlannedServiceCommitment.Init();        PlannedServiceCommitment.TransferFields(ServiceCommitment);        PlannedServiceCommitment."Type Of Update" := ServiceCommitmentArchive."Type Of Update";        PlannedServiceCommitment."Perform Update On" := ServiceCommitmentArchive."Perform Update On";        PlannedServiceCommitment.Insert(false);    end;    local procedure ProcessPlannedServiceCommitmentBuffer(var TempPlannedServiceCommitment: Record "Planned Subscription Line" temporary)    var        PlannedServiceCommitment: Record "Planned Subscription Line";    begin        TempPlannedServiceCommitment.Reset();        if TempPlannedServiceCommitment.FindSet() then            repeat                if PlannedServiceCommitment.Get(TempPlannedServiceCommitment."Entry No.") then                    ProcessPlannedServiceCommitment(PlannedServiceCommitment);            until TempPlannedServiceCommitment.Next() = 0;    end;    /// <summary>    /// Updates the existing subscription line from planned subscription line. It is used for subscription renewal.    /// </summary>    /// <param name="PlannedServiceCommitment">Record "Planned Subscription Line".</param>    procedure ProcessPlannedServiceCommitment(PlannedServiceCommitment: Record "Planned Subscription Line")    var        ServiceCommitment: Record "Subscription Line";        IsHandled: Boolean;    begin        PlannedServiceCommitment.TestField("Subscription Header No.");        PlannedServiceCommitment.TestField("Entry No.");        IsHandled := false;        OnBeforeProcessPlannedSubscriptionLine(PlannedServiceCommitment, IsHandled);        if IsHandled then            exit;        if ServiceCommitment.Get(PlannedServiceCommitment."Entry No.") then            if CheckPerformServiceCommitmentUpdate(ServiceCommitment, PlannedServiceCommitment) then begin                ServiceCommitment."Subscription Line End Date" := PlannedServiceCommitment."Subscription Line End Date";                ServiceCommitment.Amount := PlannedServiceCommitment.Amount;                ServiceCommitment."Calculation Base Amount" := PlannedServiceCommitment."Calculation Base Amount";                ServiceCommitment."Calculation Base %" := PlannedServiceCommitment."Calculation Base %";                ServiceCommitment.Price := PlannedServiceCommitment.Price;                ServiceCommitment."Discount %" := PlannedServiceCommitment."Discount %";                ServiceCommitment."Discount Amount" := PlannedServiceCommitment."Discount Amount";                ServiceCommitment."Unit Cost" := PlannedServiceCommitment."Unit Cost";                ServiceCommitment.SetLCYFields(true);                ServiceCommitment."Billing Rhythm" := PlannedServiceCommitment."Billing Rhythm";                ServiceCommitment."Billing Base Period" := PlannedServiceCommitment."Billing Base Period";                ServiceCommitment."Term Until" := PlannedServiceCommitment."Term Until";                ServiceCommitment."Cancellation Possible Until" := PlannedServiceCommitment."Cancellation Possible Until";                ServiceCommitment."Next Price Update" := PlannedServiceCommitment."Next Price Update";                ServiceCommitment."Price Binding Period" := PlannedServiceCommitment."Price Binding Period";                OnBeforeUpdateSubscriptionLineFromPlannedSubscriptionLine(ServiceCommitment, PlannedServiceCommitment);                ServiceCommitment.ArchiveServiceCommitment(CalcDate('<-1D>', ServiceCommitment."Next Billing Date"), PlannedServiceCommitment."Type Of Update");                ServiceCommitment.Modify(false);                PlannedServiceCommitment.Delete(true);            end;    end;    local procedure CheckPerformServiceCommitmentUpdate(ServiceCommitment: Record "Subscription Line"; PlannedServiceCommitment: Record "Planned Subscription Line"): Boolean    var        PerformUpdate: Boolean;    begin        PerformUpdate :=            (ServiceCommitment."Next Billing Date" >= ServiceCommitment."Subscription Line End Date") or            ((ServiceCommitment."Calculation Base Amount" = PlannedServiceCommitment."Calculation Base Amount") and             (ServiceCommitment."Calculation Base %" = PlannedServiceCommitment."Calculation Base %") and             (ServiceCommitment.Price = PlannedServiceCommitment.Price) and             (ServiceCommitment."Discount %" = PlannedServiceCommitment."Discount %") and             (ServiceCommitment."Discount Amount" = PlannedServiceCommitment."Discount Amount") and             (ServiceCommitment."Billing Rhythm" = PlannedServiceCommitment."Billing Rhythm") and             (ServiceCommitment."Billing Base Period" = PlannedServiceCommitment."Billing Base Period"));        ServiceCommitment.SetPerformUpdateForContractPriceUpdate(PerformUpdate, PlannedServiceCommitment."Type Of Update", PlannedServiceCommitment."Perform Update On");        OnCheckPerformSubscriptionLineUpdate(ServiceCommitment, PlannedServiceCommitment, PerformUpdate);        exit(PerformUpdate);    end;    local procedure SetQuantites(var SalesLine: Record "Sales Line")    begin        SalesLine."Quantity Shipped" := SalesLine."Qty. to Ship";        SalesLine."Quantity Invoiced" := SalesLine."Quantity Shipped";        SalesLine."Qty. Invoiced (Base)" := SalesLine."Qty. Shipped (Base)";        SalesLine."Qty. Shipped Not Invoiced" := 0;        SalesLine."Qty. Shipped Not Invd. (Base)" := 0;        SalesLine."Shipped Not Invoiced" := 0;        SalesLine."Shipped Not Invoiced (LCY)" := 0;        SalesLine."Shipped Not Inv. (LCY) No VAT" := 0;        SalesLine."Qty. to Ship" := 0;        SalesLine."Qty. to Invoice" := 0;        SalesLine.Modify(false);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeUpdateSubscriptionLineFromPlannedSubscriptionLine(var SubscriptionLine: Record "Subscription Line"; var PlannedSubscriptionLine: Record "Planned Subscription Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCheckPerformSubscriptionLineUpdate(SubscriptionLine: Record "Subscription Line"; PlannedSubscriptionLine: Record "Planned Subscription Line"; var PerformUpdate: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertPlannedSubscriptionLineFromSalesSubscriptionLine(SalesLine: Record "Sales Line"; SalesSubscriptionLine: Record "Sales Subscription Line"; var IsHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnAfterInsertPlannedSubscriptionLineFromSalesSubscriptionLine(SalesLine: Record "Sales Line"; var TempSubscriptionLine: Record "Subscription Line"; var PlannedSubscriptionLine: Record "Planned Subscription Line")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeProcessPlannedSubscriptionLine(var PlannedSubscriptionLine: Record "Planned Subscription Line"; var IsHandled: Boolean)    begin    end;}