Report 6032 Post Prepaid Contract Entries

Base Application, Microsoft.Service.Contract

src/Layers/W1/BaseApp/Service/Contract/PostPrepaidContractEntries.Report.al409 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.Service.Contract;using Microsoft.Finance.Analysis;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Finance.GeneralLedger.Posting;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.NoSeries;using Microsoft.Sales.Setup;using Microsoft.Service.Ledger;using Microsoft.Service.Reports;using Microsoft.Service.Setup;report 6032 "Post Prepaid Contract Entries"{    ApplicationArea = Service;    Caption = 'Post Prepaid Service Contract Entries';    ToolTip = 'Transfers prepaid service contract ledger entries amounts from prepaid accounts to income accounts.';    Permissions = TableData "Service Ledger Entry" = rm;    ProcessingOnly = true;    UsageCategory = Tasks;    dataset    {        dataitem("Service Ledger Entry"; "Service Ledger Entry")        {            DataItemTableView = sorting("Service Contract No.") where(Type = const("Service Contract"), "Moved from Prepaid Acc." = const(false), Open = const(false));            RequestFilterFields = "Service Contract No.";            trigger OnAfterGetRecord()            begin                Counter := Counter + 1;                Window.Update(1, "Service Contract No.");                Window.Update(2, Round(Counter / NoOfContracts * 10000, 1));                ServLedgEntry.Get("Entry No.");                ServLedgEntry."Moved from Prepaid Acc." := true;                ServLedgEntry.Modify();                if (LastContract <> '') and (LastContract <> "Service Contract No.") then begin                    TempServLedgEntry.Reset();                    TempServLedgEntry.SetRange("Service Contract No.", LastContract);                    TempServLedgEntry.CalcSums("Amount (LCY)");                    if TempServLedgEntry."Amount (LCY)" <> 0 then                        PostGenJnlLine()                    else                        TempServLedgEntry.DeleteAll();                    TempServLedgEntry.SetRange("Service Contract No.", "Service Contract No.");                end;                LastContract := "Service Contract No.";                if SalesSetup."Discount Posting" in                   [SalesSetup."Discount Posting"::"Line Discounts", SalesSetup."Discount Posting"::"All Discounts"]                then                    if "Discount %" = 100 then                        AmtInclDisc := 0                    else                        AmtInclDisc := Round(("Amount (LCY)" / (1 - ("Discount %" / 100))))                else                    AmtInclDisc := "Amount (LCY)";                TempServLedgEntry.SetRange("Dimension Set ID", "Dimension Set ID");                if TempServLedgEntry.FindFirst() then begin                    TempServLedgEntry."Amount (LCY)" += AmtInclDisc;                    TempServLedgEntry.Modify();                end else begin                    TempServLedgEntry := "Service Ledger Entry";                    TempServLedgEntry."Amount (LCY)" := AmtInclDisc;                    TempServLedgEntry.Insert();                end;            end;            trigger OnPostDataItem()            var                UpdateAnalysisView: Codeunit "Update Analysis View";            begin                if PostPrepaidContracts = PostPrepaidContracts::"Post Prepaid Transactions" then begin                    TempServLedgEntry.SetRange("Dimension Set ID");                    TempServLedgEntry.CalcSums("Amount (LCY)");                    if TempServLedgEntry."Amount (LCY)" <> 0 then begin                        PostGenJnlLine();                        UpdateAnalysisView.UpdateAll(0, true);                    end;                end;            end;            trigger OnPreDataItem()            begin                if PostPrepaidContracts = PostPrepaidContracts::"Print Only" then begin                    Clear(PrepaidContractEntriesTest);                    PrepaidContractEntriesTest.InitVariables(UntilDate, PostingDate);                    PrepaidContractEntriesTest.SetTableView("Service Ledger Entry");                    PrepaidContractEntriesTest.RunModal();                    CurrReport.Break();                end;                if PostPrepaidContracts = PostPrepaidContracts::"Post Prepaid Transactions" then begin                    ServContractHdr.SetFilter("Contract No.", GetFilter("Service Contract No."));                    if ServContractHdr.Find('-') then                        repeat                            ServContractHdr.CalcFields("No. of Unposted Credit Memos");                            if ServContractHdr."No. of Unposted Credit Memos" <> 0 then                                Error(Text005Err, Text007Txt, Text008Txt, ServContractHdr."Contract No.", Text006Txt);                        until ServContractHdr.Next() = 0;                end;                LastContract := '';                if UntilDate = 0D then                    Error(Text000Err);                if PostingDate = 0D then                    Error(Text001Err);                SetRange("Posting Date", 0D, UntilDate);                NoOfContracts := Count;                Window.Open(                  Text002Txt +                  Text003Txt +                  '@2@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@');                GLSetup.GetRecordOnce();                if not GLSetup."Journal Templ. Name Mandatory" then begin                    ServMgtSetup.Get();                    ServMgtSetup.TestField("Prepaid Posting Document Nos.");                end;                SourceCodeSetup.Get();                SourceCodeSetup.TestField("Service Management");                SalesSetup.Get();            end;        }    }    requestpage    {        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(UntilDate; UntilDate)                    {                        ApplicationArea = Service;                        Caption = 'Post until Date';                        MultiLine = true;                        ToolTip = 'Specifies the date up to which you want to post prepaid entries. The batch job includes service ledger entries with posting dates on or before this date.';                    }                    field(PostingDate; PostingDate)                    {                        ApplicationArea = Service;                        Caption = 'Posting Date';                        MultiLine = true;                        ToolTip = 'Specifies the date that you want to use as the posting date on the service ledger entries.';                    }                    field(JournalTemplateName; GenJnlLineReq."Journal Template Name")                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Journal Template Name';                        TableRelation = "Gen. Journal Template";                        ToolTip = 'Specifies the name of the journal template that is used for the posting.';                        Visible = IsJournalTemplNameVisible;                        trigger OnValidate()                        begin                            GenJnlLineReq."Journal Batch Name" := '';                        end;                    }                    field(JournalBatchName; GenJnlLineReq."Journal Batch Name")                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Journal Batch Name';                        Lookup = true;                        ToolTip = 'Specifies the name of the journal batch that is used for the posting.';                        Visible = IsJournalTemplNameVisible;                        trigger OnLookup(var Text: Text): Boolean                        var                            GenJnlManagement: Codeunit GenJnlManagement;                        begin                            GenJnlManagement.SetJnlBatchName(GenJnlLineReq);                            if GenJnlLineReq."Journal Batch Name" <> '' then                                GenJnlBatch.Get(GenJnlLineReq."Journal Template Name", GenJnlLineReq."Journal Batch Name");                        end;                        trigger OnValidate()                        begin                            if GenJnlLineReq."Journal Batch Name" <> '' then begin                                GenJnlLineReq.TestField("Journal Template Name");                                GenJnlBatch.Get(GenJnlLineReq."Journal Template Name", GenJnlLineReq."Journal Batch Name");                            end;                        end;                    }                    field(PostPrepaidContracts; PostPrepaidContracts)                    {                        ApplicationArea = Service;                        Caption = 'Action';                        OptionCaption = 'Post Prepaid Transactions,Print Only';                        ToolTip = 'Specifies the desired action relating to prepaid contract entries.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            GLSetup.GetRecordOnce();            IsJournalTemplNameVisible := GLSetup."Journal Templ. Name Mandatory";        end;    }    labels    {    }    trigger OnInitReport()    begin        PostingDate := WorkDate();        Clear(GenJnlPostLine);    end;    trigger OnPostReport()    begin        if PostPrepaidContracts = PostPrepaidContracts::"Post Prepaid Transactions" then            Window.Close();    end;    trigger OnPreReport()    var        NoSeries: Codeunit "No. Series";    begin        if PostPrepaidContracts = PostPrepaidContracts::"Post Prepaid Transactions" then begin            GLSetup.GetRecordOnce();            if not GLSetup."Journal Templ. Name Mandatory" then                exit;            if GenJnlLineReq."Journal Template Name" = '' then                Error(PleaseEnterErr, GenJnlLineReq.FieldCaption("Journal Template Name"));            if GenJnlLineReq."Journal Batch Name" = '' then                Error(PleaseEnterErr, GenJnlLineReq.FieldCaption("Journal Batch Name"));            Clear(DocNo);            GenJnlBatch.Get(GenJnlLineReq."Journal Template Name", GenJnlLineReq."Journal Batch Name");            GenJnlBatch.TestField("No. Series");            DocNo := NoSeries.GetNextNo(GenJnlBatch."No. Series", WorkDate());        end;    end;    var        Text000Err: Label 'You must fill in the Post Until Date field.';        Text001Err: Label 'You must fill in the Posting Date field.';        Text002Txt: Label 'Posting prepaid contract entries...\';#pragma warning disable AA0470        Text003Txt: Label 'Service Contract: #1###############\\';#pragma warning restore AA0470        Text004Txt: Label 'Service Contract';        GLSetup: Record "General Ledger Setup";        GenJnlLine: Record "Gen. Journal Line";        ServLedgEntry: Record "Service Ledger Entry";        TempServLedgEntry: Record "Service Ledger Entry" temporary;        ServContractAccGr: Record "Service Contract Account Group";        ServMgtSetup: Record "Service Mgt. Setup";        SourceCodeSetup: Record "Source Code Setup";        ServContractHdr: Record "Service Contract Header";        SalesSetup: Record "Sales & Receivables Setup";        GenJnlLineReq: Record "Gen. Journal Line";        GenJnlBatch: Record "Gen. Journal Batch";        PrepaidContractEntriesTest: Report "Prepaid Contr. Entries - Test";        GenJnlPostLine: Codeunit "Gen. Jnl.-Post Line";        Window: Dialog;        PostPrepaidContracts: Option "Post Prepaid Transactions","Print Only";        DocNo: Code[20];        UntilDate: Date;        PostingDate: Date;        NoOfContracts: Integer;        Counter: Integer;        AmtInclDisc: Decimal;        LastContract: Code[20];        IsJournalTemplNameVisible: Boolean;#pragma warning disable AA0470        Text005Err: Label 'You cannot post %1 because %2 %3 has at least one %4 linked to it.';#pragma warning restore AA0470        Text006Txt: Label 'Unposted Credit Memo';        Text007Txt: Label 'Prepaid Contract Entries';#pragma warning disable AA0074        Text008txt: Label 'Service Contract';#pragma warning restore AA0074        PleaseEnterErr: Label 'Please enter a %1.', Comment = '%1 - field caption';    local procedure PostGenJnlLine()    var        NoSeries: Codeunit "No. Series";        IsPrepaidAccountPostingHandled: Boolean;        IsNonPrepaidAccountPostingHandled: Boolean;    begin        TempServLedgEntry.Reset();        if not TempServLedgEntry.FindSet() then            exit;        GLSetup.GetRecordOnce();        if not GLSetup."Journal Templ. Name Mandatory" then            DocNo := NoSeries.GetNextNo(ServMgtSetup."Prepaid Posting Document Nos.", WorkDate());        repeat            IsNonPrepaidAccountPostingHandled := false;            OnBeforePostNonPrepaidAccount(GenJnlLine, TempServLedgEntry, IsNonPrepaidAccountPostingHandled);            if not IsNonPrepaidAccountPostingHandled then begin                GenJnlLine.Reset();                GenJnlLine.Init();                GenJnlLine."Document No." := DocNo;                GenJnlLine."Journal Template Name" := GenJnlLineReq."Journal Template Name";                GenJnlLine."Journal Batch Name" := GenJnlLineReq."Journal Batch Name";                GenJnlLine."Account Type" := GenJnlLine."Account Type"::"G/L Account";                GenJnlLine."VAT Posting" := GenJnlLine."VAT Posting"::"Manual VAT Entry";                ServContractAccGr.Get(TempServLedgEntry."Serv. Contract Acc. Gr. Code");                ServContractAccGr.TestField("Non-Prepaid Contract Acc.");                GenJnlLine.Validate("Account No.", ServContractAccGr."Non-Prepaid Contract Acc.");                GenJnlLine."Posting Date" := PostingDate;                GenJnlLine.Description := Text004Txt;                GenJnlLine."External Document No." := TempServLedgEntry."Service Contract No.";                GenJnlLine.Validate(Amount, TempServLedgEntry."Amount (LCY)");                GenJnlLine."Shortcut Dimension 1 Code" := TempServLedgEntry."Global Dimension 1 Code";                GenJnlLine."Shortcut Dimension 2 Code" := TempServLedgEntry."Global Dimension 2 Code";                GenJnlLine."Dimension Set ID" := TempServLedgEntry."Dimension Set ID";                GenJnlLine."Source Code" := SourceCodeSetup."Service Management";                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" := '';                RunGenJnlPostLine();            end;            IsPrepaidAccountPostingHandled := false;            OnBeforePostPrepaidAccount(GenJnlLine, TempServLedgEntry, IsPrepaidAccountPostingHandled);            if not IsPrepaidAccountPostingHandled then begin                ServContractAccGr.Get(TempServLedgEntry."Serv. Contract Acc. Gr. Code");                ServContractAccGr.TestField("Prepaid Contract Acc.");                GenJnlLine.Validate("Account No.", ServContractAccGr."Prepaid Contract Acc.");                GenJnlLine.Validate(Amount, -TempServLedgEntry."Amount (LCY)");                GenJnlLine."Shortcut Dimension 1 Code" := TempServLedgEntry."Global Dimension 1 Code";                GenJnlLine."Shortcut Dimension 2 Code" := TempServLedgEntry."Global Dimension 2 Code";                GenJnlLine."Dimension Set ID" := TempServLedgEntry."Dimension Set ID";                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" := '';                RunGenJnlPostLine();            end;        until TempServLedgEntry.Next() = 0;        TempServLedgEntry.Reset();        TempServLedgEntry.DeleteAll();    end;    local procedure RunGenJnlPostLine()    var        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeRunGenJnlPostLine(GenJnlLine, TempServLedgEntry, IsHandled);        if IsHandled then            exit;        GenJnlPostLine.Run(GenJnlLine);    end;    procedure InitializeRequest(UntilDateFrom: Date; PostingDateFrom: Date; PostPrepaidContractsFrom: Option "Post Prepaid Transactions","Print Only")    begin        UntilDate := UntilDateFrom;        PostingDate := PostingDateFrom;        PostPrepaidContracts := PostPrepaidContractsFrom;    end;    procedure SetGenJnlBatch(NewGenJnlBatch: Record "Gen. Journal Batch");    begin        GenJnlBatch := NewGenJnlBatch;    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePostNonPrepaidAccount(var GenJnlLine: Record "Gen. Journal Line"; var TempServLedgEntry: Record "Service Ledger Entry"; var IsNonPrepaidAccountPostingHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforePostPrepaidAccount(var GenJnlLine: Record "Gen. Journal Line"; var TempServLedgEntry: Record "Service Ledger Entry"; var IsPrepaidAccountPostingHandled: Boolean)    begin    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeRunGenJnlPostLine(var GenJnlLine: Record "Gen. Journal Line"; var TempServLedgEntry: Record "Service Ledger Entry" temporary; var IsHandled: Boolean)    begin    end;}