Report 8051 Contract Deferrals Release

Subscription Billing, Microsoft.SubscriptionBilling

src/Apps/W1/Subscription Billing/App/Deferrals/Reports/ContractDeferralsRelease.Report.al502 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Posting;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Purchases.Setup;using Microsoft.Sales.History;using Microsoft.Sales.Setup;report 8051 "Contract Deferrals Release"{    ApplicationArea = All;    Caption = 'Subscription Contract Deferrals Release';    UsageCategory = Tasks;    ProcessingOnly = true;    AdditionalSearchTerms = 'Release Deferrals, Contract Deferrals, Release Revenue, Release Cost, Deferral Posting, Contract Release';    ToolTip = 'Release the deferrals for all contracts.';    requestpage    {        AboutTitle = 'About Subscription Contract Deferrals Release';        AboutText = 'Release deferred cost and revenue from contracts based on a chosen time period.';        layout        {            area(Content)            {                group(Options)                {                    Caption = 'Options';                    field(PostingDateReq; PostingDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Posting Date';                        ToolTip = 'Specifies the posting date on which the release is posted.';                    }                    field(PostUntilDateReq; PostUntilDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Post Until Date';                        ToolTip = 'Specifies the date up to which contract deferrals are considered for release.';                        trigger OnValidate()                        begin                            if PostUntilDate > PostingDate then                                Error(PostUntilDateMustBeBeforePostingDateErr);                        end;                    }                }            }        }    }    trigger OnInitReport()    begin        LineNo := 0;        PostingDate := WorkDate();        PostUntilDate := WorkDate();        AllowGUI := true;    end;    trigger OnPreReport()    begin        TestDates();        GetAndTestSourceCode();        GetGeneralLedgerSetupAndCheckJournalTemplateAndBatch();        FilterAndCountContractDeferrals();        Window.Open(ContractDeferralsReleaseTxt + ContractProgressTxt);        ReleaseAllCustomerContractDeferralsAndInsertTempGenJournalLines();        PostTempGenJnlLineBufferForCustomerDeferrals();        ReleaseAllVendorContractDeferralsAndInsertTempGenJournalLines();        PostTempGenJnlLineBufferForVendorDeferrals();    end;    trigger OnPostReport()    begin        Window.Close();    end;    var        TempGenJournalLine: Record "Gen. Journal Line" temporary;        ServiceContractSetup: Record "Subscription Contract Setup";        SalesSetup: Record "Sales & Receivables Setup";        GenPostingSetup: Record "General Posting Setup";        SourceCodeSetup: Record "Source Code Setup";        PurchaseSetup: Record "Purchases & Payables Setup";        GlobalCustomerContractDeferral: Record "Cust. Sub. Contract Deferral";        GlobalVendorContractDeferral: Record "Vend. Sub. Contract Deferral";        CustomerDeferralsMngmt: Codeunit "Customer Deferrals Mngmt.";        VendorDeferralsMngmt: Codeunit "Vendor Deferrals Mngmt.";        GenJnlPostLine: Codeunit "Gen. Jnl.-Post Line";        Window: Dialog;        PostingDate: Date;        PostUntilDate: Date;        ContractDeferralIteration: Integer;        TotalContractDeferralsCount: Integer;        LineDiscountPosting: Boolean;        PostingDateIsEmptyErr: Label 'You must fill in the Posting Date field.';        PostUntilDateIsEmptyErr: Label 'You must fill in the Post Until Date field.';        PostUntilDateMustBeBeforePostingDateErr: Label 'Posting until Date must be before then Posting Date.';        ContractDeferralsReleaseTxt: Label 'Contract Deferrals Release...\';        ContractProgressTxt: Label 'Contract: #1###############\\@2@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@', Comment = '%1=Contract No., %2=Progress';        ReleasingOfContractNoTxt: Label 'Release Contract Deferral of %1.', Comment = '%1 = Posting Date in format <Month Text> <Year4>';        AllowGUI: Boolean;        LineNo: Integer;    local procedure TestDates()    begin        if PostUntilDate = 0D then            Error(PostUntilDateIsEmptyErr);        if PostingDate = 0D then            Error(PostingDateIsEmptyErr);        if PostUntilDate > PostingDate then            Error(PostUntilDateMustBeBeforePostingDateErr);    end;    local procedure FilterAndCountContractDeferrals()    begin        ContractDeferralIteration := 0;        GlobalCustomerContractDeferral.SetRange("Posting Date", 0D, PostUntilDate);        GlobalCustomerContractDeferral.SetRange("Document Posting Date", 0D, PostUntilDate);        GlobalCustomerContractDeferral.SetRange(Released, false);        GlobalVendorContractDeferral.SetRange("Posting Date", 0D, PostUntilDate);        GlobalVendorContractDeferral.SetRange("Document Posting Date", 0D, PostUntilDate);        GlobalVendorContractDeferral.SetRange(Released, false);        TotalContractDeferralsCount := GlobalVendorContractDeferral.Count + GlobalCustomerContractDeferral.Count;    end;    local procedure ReleaseAllCustomerContractDeferralsAndInsertTempGenJournalLines()    begin        if GlobalCustomerContractDeferral.FindSet() then begin            GetLineDiscountPostingSetup(Enum::"Service Partner"::Customer);            repeat                ReleaseCustomerContractDeferralAndInsertTempGenJournalLine(GlobalCustomerContractDeferral);            until GlobalCustomerContractDeferral.Next() = 0;        end;    end;    internal procedure ReleaseCustomerContractDeferralAndInsertTempGenJournalLine(CustomerContractDeferral: Record "Cust. Sub. Contract Deferral")    var        ShouldRelease: Boolean;        PostingAmount: Decimal;    begin        ShouldRelease := true;        OnBeforeReleaseCustomerContractDeferral(CustomerContractDeferral, ShouldRelease, PostingDate);        if not ShouldRelease then begin            UpdateWindow(CustomerContractDeferral."Subscription Contract No.");            exit;        end;        if (CustomerContractDeferral.Amount <> 0) or (CustomerContractDeferral."Discount Amount" <> 0) then            CheckGenPostingSetup(CustomerContractDeferral."Gen. Bus. Posting Group", CustomerContractDeferral."Gen. Prod. Posting Group", Enum::"Service Partner"::Customer, CustomerContractDeferral."G/L Account No." <> '');        CustomerContractDeferral.Released := true;        CustomerContractDeferral."Release Posting Date" := PostingDate;        CustomerContractDeferral.Modify(false);        PostingAmount := GetPostingAmount(CustomerContractDeferral.Amount, CustomerContractDeferral."Discount Amount");        if PostingAmount <> 0 then            InsertTempGenJournalLine(                CustomerContractDeferral."Document No.",                CustomerContractDeferral."Subscription Contract No.",                CustomerContractDeferral."Entry No.",                CustomerContractDeferral."Dimension Set ID",                GetContractAccount(CustomerContractDeferral."G/L Account No.", GenPostingSetup."Cust. Sub. Contract Account"),                GenPostingSetup."Cust. Sub. Contr. Def Account",                CustomerContractDeferral."Gen. Bus. Posting Group",                CustomerContractDeferral."Gen. Prod. Posting Group",                PostingAmount,                Enum::"Service Partner"::Customer);        if LineDiscountPosting and (CustomerContractDeferral."Discount Amount" <> 0) then            InsertTempGenJournalLine(                CustomerContractDeferral."Document No.",                CustomerContractDeferral."Subscription Contract No.",                CustomerContractDeferral."Entry No.",                CustomerContractDeferral."Dimension Set ID",                GenPostingSetup."Sales Line Disc. Account",                GenPostingSetup."Cust. Sub. Contr. Def Account",                CustomerContractDeferral."Gen. Bus. Posting Group",                CustomerContractDeferral."Gen. Prod. Posting Group",                -CustomerContractDeferral."Discount Amount",                Enum::"Service Partner"::Customer);    end;    local procedure ReleaseAllVendorContractDeferralsAndInsertTempGenJournalLines()    begin        if GlobalVendorContractDeferral.FindSet() then begin            GetLineDiscountPostingSetup(Enum::"Service Partner"::Vendor);            repeat                ReleaseVendorContractDeferralsAndInsertTempGenJournalLines(GlobalVendorContractDeferral);            until GlobalVendorContractDeferral.Next() = 0;        end;    end;    internal procedure ReleaseVendorContractDeferralsAndInsertTempGenJournalLines(VendorContractDeferral: Record "Vend. Sub. Contract Deferral")    var        ShouldRelease: Boolean;        PostingAmount: Decimal;    begin        ShouldRelease := true;        OnBeforeReleaseVendorContractDeferral(VendorContractDeferral, ShouldRelease, PostingDate);        if not ShouldRelease then begin            UpdateWindow(VendorContractDeferral."Subscription Contract No.");            exit;        end;        if (VendorContractDeferral.Amount <> 0) or (VendorContractDeferral."Discount Amount" <> 0) then            CheckGenPostingSetup(VendorContractDeferral."Gen. Bus. Posting Group", VendorContractDeferral."Gen. Prod. Posting Group", Enum::"Service Partner"::Vendor, VendorContractDeferral."G/L Account No." <> '');        VendorContractDeferral.Released := true;        VendorContractDeferral."Release Posting Date" := PostingDate;        VendorContractDeferral.Modify(false);        PostingAmount := GetPostingAmount(VendorContractDeferral.Amount, VendorContractDeferral."Discount Amount");        if PostingAmount <> 0 then            InsertTempGenJournalLine(                VendorContractDeferral."Document No.",                VendorContractDeferral."Subscription Contract No.",                VendorContractDeferral."Entry No.",                VendorContractDeferral."Dimension Set ID",                GetContractAccount(VendorContractDeferral."G/L Account No.", GenPostingSetup."Vend. Sub. Contract Account"),                GenPostingSetup."Vend. Sub. Contr. Def. Account",                VendorContractDeferral."Gen. Bus. Posting Group",                VendorContractDeferral."Gen. Prod. Posting Group",                PostingAmount,                Enum::"Service Partner"::Vendor);        if LineDiscountPosting and (VendorContractDeferral."Discount Amount" <> 0) then            InsertTempGenJournalLine(                VendorContractDeferral."Document No.",                VendorContractDeferral."Subscription Contract No.",                VendorContractDeferral."Entry No.",                VendorContractDeferral."Dimension Set ID",                GenPostingSetup."Purch. Line Disc. Account",                GenPostingSetup."Vend. Sub. Contr. Def. Account",                VendorContractDeferral."Gen. Bus. Posting Group",                VendorContractDeferral."Gen. Prod. Posting Group",                -VendorContractDeferral."Discount Amount",                Enum::"Service Partner"::Vendor);    end;    local procedure GetLineDiscountPostingSetup(Partner: Enum "Service Partner")    begin        case Partner of            Enum::"Service Partner"::Customer:                begin                    SalesSetup.Get();                    LineDiscountPosting := SalesSetup."Discount Posting" in                       [SalesSetup."Discount Posting"::"Line Discounts", SalesSetup."Discount Posting"::"All Discounts"];                end;            Enum::"Service Partner"::Vendor:                begin                    PurchaseSetup.Get();                    LineDiscountPosting := PurchaseSetup."Discount Posting" in                       [PurchaseSetup."Discount Posting"::"Line Discounts", PurchaseSetup."Discount Posting"::"All Discounts"];                end;        end;    end;    local procedure CheckGenPostingSetup(GenBusPostingGroup: Code[20]; GenProdPostingGroup: Code[20]; Partner: Enum "Service Partner"; ContractAccountTakenFromDeferral: Boolean)    begin        GenPostingSetup.Get(GenBusPostingGroup, GenProdPostingGroup);        case Partner of            Enum::"Service Partner"::Customer:                begin                    if not ContractAccountTakenFromDeferral then                        GenPostingSetup.TestField("Cust. Sub. Contract Account");                    if LineDiscountPosting then                        GenPostingSetup.TestField("Sales Line Disc. Account");                end;            Enum::"Service Partner"::Vendor:                begin                    if not ContractAccountTakenFromDeferral then                        GenPostingSetup.TestField("Vend. Sub. Contract Account");                    if LineDiscountPosting then                        GenPostingSetup.TestField("Purch. Line Disc. Account");                end;        end;    end;    local procedure GetContractAccount(DeferralGLAccountNo: Code[20]; GenPostingSetupContractAccount: Code[20]): Code[20]    begin        if DeferralGLAccountNo <> '' then            exit(DeferralGLAccountNo);        exit(GenPostingSetupContractAccount);    end;    local procedure GetPostingAmount(Amount: Decimal; DiscountAmount: Decimal): Decimal    begin        if LineDiscountPosting then            exit(Amount + DiscountAmount)        else            exit(Amount);    end;    local procedure InsertTempGenJournalLine(DocumentNo: Code[20]; ContractNo: Code[20]; DeferralEntryNo: Integer; DimSetID: Integer; AccountNo: Code[20]; BalAccountNo: Code[20]; GenBusPostingGroup: Code[20]; GenProdPostingGroup: Code[20]; PostingAmount: Decimal; Partner: Enum "Service Partner")    begin        UpdateWindow(ContractNo);        InsertTempGenJournalLine(DocumentNo, ContractNo, DeferralEntryNo, DimSetID, AccountNo, BalAccountNo, PostingAmount, GenBusPostingGroup, GenProdPostingGroup, Partner);    end;    local procedure InsertTempGenJournalLine(DocumentNo: Code[20]; ContractNo: Code[20]; DeferralEntryNo: Integer; DimSetID: Integer; AccountNo: Code[20]; BalAccountNo: Code[20]; PostingAmount: Decimal; GenBusPostingGroup: Code[20]; GenProdPostingGroup: Code[20]; Partner: Enum "Service Partner")    begin        LineNo += 1;        TempGenJournalLine."Account No." := AccountNo;        TempGenJournalLine."Bal. Account No." := BalAccountNo;        TempGenJournalLine."Document No." := DocumentNo;        TempGenJournalLine."Subscription Contract No." := ContractNo;        TempGenJournalLine."Gen. Bus. Posting Group" := GenBusPostingGroup;        TempGenJournalLine."Gen. Prod. Posting Group" := GenProdPostingGroup;        TempGenJournalLine."Dimension Set ID" := DimSetID;        TempGenJournalLine.Amount := PostingAmount;        TempGenJournalLine."Line No." := LineNo;        TempGenJournalLine."Deferral Line No." := DeferralEntryNo;        OnBeforeInsertTempGenJournalLine(TempGenJournalLine, Partner);        TempGenJournalLine.Insert(false);    end;    internal procedure PostTempGenJnlLineBufferForCustomerDeferrals()    begin        TempGenJournalLine.Reset();        TempGenJournalLine.SetCurrentKey("Document No.", "Subscription Contract No.", "Gen. Bus. Posting Group", "Gen. Prod. Posting Group");        if TempGenJournalLine.FindSet() then            repeat                CustomerDeferralsMngmt.SetDeferralNo(TempGenJournalLine."Deferral Line No.");                SetCustomerSourceCurrency(TempGenJournalLine);                PostGenJnlLine(TempGenJournalLine, PostingDate, SourceCodeSetup."Sub. Contr. Deferrals Release");            until TempGenJournalLine.Next() = 0;        ResetTempGenJournalLine();        CustomerDeferralsMngmt.SetDeferralNo(0);    end;    local procedure SetCustomerSourceCurrency(var InputTempGenJournalLine: Record "Gen. Journal Line" temporary)    var        CustomerContractDeferral: Record "Cust. Sub. Contract Deferral";        Currency: Record Currency;        CurrencyExchangeRate: Record "Currency Exchange Rate";        SalesCrMemoHeader: Record "Sales Cr.Memo Header";        SalesInvoiceHeader: Record "Sales Invoice Header";        CurrencyFactor: Decimal;    begin        InputTempGenJournalLine."Source Currency Code" := '';        InputTempGenJournalLine."Source Currency Amount" := 0;        if not CustomerContractDeferral.Get(InputTempGenJournalLine."Deferral Line No.") then            exit;        if CustomerContractDeferral."Currency Code" = '' then            exit;        case CustomerContractDeferral."Document Type" of            CustomerContractDeferral."Document Type"::Invoice:                begin                    if not SalesInvoiceHeader.Get(CustomerContractDeferral."Document No.") then                        exit;                    CurrencyFactor := SalesInvoiceHeader."Currency Factor";                end;            CustomerContractDeferral."Document Type"::"Credit Memo":                begin                    if not SalesCrMemoHeader.Get(CustomerContractDeferral."Document No.") then                        exit;                    CurrencyFactor := SalesCrMemoHeader."Currency Factor";                end;        end;        if not Currency.Get(CustomerContractDeferral."Currency Code") then            exit;        InputTempGenJournalLine."Source Currency Code" := CustomerContractDeferral."Currency Code";        InputTempGenJournalLine."Source Currency Amount" :=            Round(                CurrencyExchangeRate.ExchangeAmtLCYToFCY(                    CustomerContractDeferral."Document Posting Date", CustomerContractDeferral."Currency Code", InputTempGenJournalLine.Amount, CurrencyFactor),                Currency."Amount Rounding Precision");    end;    internal procedure PostTempGenJnlLineBufferForVendorDeferrals()    begin        TempGenJournalLine.Reset();        TempGenJournalLine.SetCurrentKey("Document No.", "Subscription Contract No.", "Gen. Bus. Posting Group", "Gen. Prod. Posting Group");        if TempGenJournalLine.FindSet() then            repeat                VendorDeferralsMngmt.SetDeferralNo(TempGenJournalLine."Deferral Line No.");                PostGenJnlLine(TempGenJournalLine, PostingDate, SourceCodeSetup."Sub. Contr. Deferrals Release");                VendorDeferralsMngmt.SetDeferralNo(0);            until TempGenJournalLine.Next() = 0;        ResetTempGenJournalLine();    end;    local procedure ResetTempGenJournalLine()    begin        TempGenJournalLine.Reset();        TempGenJournalLine.DeleteAll(false);    end;    local procedure UpdateWindow(ContractNo: Code[20])    begin        if not AllowGUI then            exit;        ContractDeferralIteration += 1;        Window.Update(1, ContractNo);        Window.Update(2, Round(ContractDeferralIteration / TotalContractDeferralsCount * 10000, 1));    end;    internal procedure GetAndTestSourceCode()    begin        SourceCodeSetup.Get();        SourceCodeSetup.TestField("Sub. Contr. Deferrals Release");    end;    internal procedure GetGeneralLedgerSetupAndCheckJournalTemplateAndBatch()    var        GeneralLedgerSetup: Record "General Ledger Setup";    begin        GeneralLedgerSetup.Get();        if GeneralLedgerSetup."Journal Templ. Name Mandatory" then begin            ServiceContractSetup.Get();            ServiceContractSetup.TestField("Def. Rel. Jnl. Template Name");            ServiceContractSetup.TestField("Def. Rel. Jnl. Batch Name");        end;    end;    procedure PostGenJnlLine(var InputTempGenJournalLine: Record "Gen. Journal Line" temporary; InputPostingDate: Date; SourceCodeSetupContractDeferralsRelease: Code[10])    var        GenJnlLine: Record "Gen. Journal Line";    begin        if IsNullGuid(ServiceContractSetup.SystemId) then            ServiceContractSetup.Get();        GenJnlLine.Init();        GenJnlLine."Journal Template Name" := ServiceContractSetup."Def. Rel. Jnl. Template Name";        GenJnlLine."Journal Batch Name" := ServiceContractSetup."Def. Rel. Jnl. Batch Name";        GenJnlLine."Document No." := InputTempGenJournalLine."Document No.";        GenJnlLine."Account Type" := GenJnlLine."Account Type"::"G/L Account";        GenJnlLine."VAT Posting" := GenJnlLine."VAT Posting"::"Manual VAT Entry";        GenJnlLine."Account No." := InputTempGenJournalLine."Account No.";        GenJnlLine."Deferral Code" := '';        GenJnlLine."Posting Date" := InputPostingDate;        GenJnlLine.Description := StrSubstNo(ReleasingOfContractNoTxt, Format(GenJnlLine."Posting Date", 0, '<Month Text> <Year4>'));        GenJnlLine."Subscription Contract No." := InputTempGenJournalLine."Subscription Contract No.";        GenJnlLine.Validate(Amount, InputTempGenJournalLine.Amount);        GenJnlLine."Source Currency Code" := InputTempGenJournalLine."Source Currency Code";        GenJnlLine."Source Currency Amount" := InputTempGenJournalLine."Source Currency Amount";        GenJnlLine.Validate("Dimension Set ID", InputTempGenJournalLine."Dimension Set ID");        GenJnlLine."Source Code" := SourceCodeSetupContractDeferralsRelease;        GenJnlLine."System-Created Entry" := true;        GenJnlLine."Gen. Posting Type" := GenJnlLine."Gen. Posting Type"::" ";        GenJnlLine."Gen. Bus. Posting Group" := '';        GenJnlLine."Gen. Prod. Posting Group" := '';        GenJnlLine."VAT Bus. Posting Group" := '';        GenJnlLine."VAT Prod. Posting Group" := '';        OnBeforePostGenJnlLine(InputTempGenJournalLine, GenJnlLine);        GenJnlPostLine.RunWithCheck(GenJnlLine);        GenJnlLine."Account No." := InputTempGenJournalLine."Bal. Account No.";        GenJnlLine."Deferral Code" := '';        GenJnlLine.Validate("Dimension Set ID", InputTempGenJournalLine."Dimension Set ID");        GenJnlLine.Validate(Amount, -InputTempGenJournalLine.Amount);        GenJnlLine."Source Currency Amount" := -InputTempGenJournalLine."Source Currency Amount";        GenJnlLine."Gen. Posting Type" := GenJnlLine."Gen. Posting Type"::" ";        GenJnlLine."Gen. Bus. Posting Group" := '';        GenJnlLine."Gen. Prod. Posting Group" := '';        GenJnlLine."VAT Bus. Posting Group" := '';        GenJnlLine."VAT Prod. Posting Group" := '';        GenJnlLine.Description := StrSubstNo(ReleasingOfContractNoTxt, Format(GenJnlLine."Posting Date", 0, '<Month Text> <Year4>'));        OnBeforePostGenJnlLine(InputTempGenJournalLine, GenJnlLine);        GenJnlPostLine.RunWithCheck(GenJnlLine);    end;    internal procedure SetRequestPageParameters(NewPostUntilDate: Date; NewPostingDate: Date)    begin        PostUntilDate := NewPostUntilDate;        PostingDate := NewPostingDate;    end;    internal procedure SetAllowGUI(NewAllowGUI: Boolean)    begin        AllowGUI := NewAllowGUI;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeReleaseCustomerContractDeferral(var CustomerContractDeferral: Record "Cust. Sub. Contract Deferral"; var ShouldReleaseDeferral: Boolean; PostingDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeReleaseVendorContractDeferral(var VendorContractDeferral: Record "Vend. Sub. Contract Deferral"; var ShouldReleaseDeferral: Boolean; PostingDate: Date)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeInsertTempGenJournalLine(var TempGenJournalLine: Record "Gen. Journal Line"; Partner: Enum "Service Partner")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePostGenJnlLine(TempGenJournalLine: Record "Gen. Journal Line"; var GenJnlLine: Record "Gen. Journal Line")    begin    end;}