Report 322 Aged Accounts Payable

Base Application, Microsoft.Purchases.Reports

src/Layers/W1/BaseApp/Purchases/Reports/AgedAccountsPayable.Report.al887 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEAN28// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Purchases.Reports;using Microsoft.Finance.Currency;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Purchases.Payables;using Microsoft.Purchases.Vendor;using Microsoft.Utilities;using System.Utilities;report 322 "Aged Accounts Payable"{    ApplicationArea = Basic, Suite;    Caption = 'Aged Accounts Payable (Obsolete)';    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    ObsoleteState = Pending;    ObsoleteReason = 'This report has been replaced by the report Aged Accounts Payable (Excel). This report will be removed in a future release.';    ObsoleteTag = '28.0';    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Vendor; Vendor)        {            PrintOnlyIfDetail = true;            RequestFilterFields = "No.";            column(TodayFormatted; TodayFormatted)            {            }            column(CompanyName; CompanyDisplayName)            {            }            column(NewPagePerVendor; NewPagePerVendor)            {            }            column(AgesAsOfEndingDate; StrSubstNo(Text006, Format(EndingDate, 0, 4)))            {            }            column(SelectAgeByDuePostngDocDt; StrSubstNo(Text007, SelectStr(AgingBy + 1, Text009)))            {            }            column(PrintAmountInLCY; PrintAmountInLCY)            {            }            column(CaptionVendorFilter; TableCaption + ': ' + VendorFilter)            {            }            column(VendorFilter; VendorFilter)            {            }            column(AgingBy; AgingBy)            {            }            column(SelctAgeByDuePostngDocDt1; StrSubstNo(Text004, SelectStr(AgingBy + 1, Text009)))            {            }            column(HeaderText5; HeaderText[5])            {            }            column(HeaderText4; HeaderText[4])            {            }            column(HeaderText3; HeaderText[3])            {            }            column(HeaderText2; HeaderText[2])            {            }            column(HeaderText1; HeaderText[1])            {            }            column(PrintDetails; PrintDetails)            {            }            column(GrandTotalVLE5RemAmtLCY; GrandTotalVLERemaingAmtLCY[5])            {                AutoFormatType = 1;            }            column(GrandTotalVLE4RemAmtLCY; GrandTotalVLERemaingAmtLCY[4])            {                AutoFormatType = 1;            }            column(GrandTotalVLE3RemAmtLCY; GrandTotalVLERemaingAmtLCY[3])            {                AutoFormatType = 1;            }            column(GrandTotalVLE2RemAmtLCY; GrandTotalVLERemaingAmtLCY[2])            {                AutoFormatType = 1;            }            column(GrandTotalVLE1RemAmtLCY; GrandTotalVLERemaingAmtLCY[1])            {                AutoFormatType = 1;            }            column(GrandTotalVLE1AmtLCY; GrandTotalVLEAmtLCY)            {                AutoFormatType = 1;            }            column(PageGroupNo; PageGroupNo)            {            }            column(No_Vendor; "No.")            {            }            column(AgedAcctPayableCaption; AgedAcctPayableCaptionLbl)            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            column(AllAmtsinLCYCaption; AllAmtsinLCYCaptionLbl)            {            }            column(AgedOverdueAmsCaption; AgedOverdueAmsCaptionLbl)            {            }            column(GrandTotalVLE5RemAmtLCYCaption; GrandTotalVLE5RemAmtLCYCaptionLbl)            {            }            column(AmountLCYCaption; AmountLCYCaptionLbl)            {            }            column(DueDateCaption; DueDateCaptionLbl)            {            }            column(DocumentNoCaption; DocNoCaption)            {            }            column(PostingDateCaption; PostingDateCaptionLbl)            {            }            column(DocumentTypeCaption; DocumentTypeCaptionLbl)            {            }            column(VendorNoCaption; FieldCaption("No."))            {            }            column(VendorNameCaption; FieldCaption(Name))            {            }            column(CurrencyCaption; CurrencyCaptionLbl)            {            }            column(TotalLCYCaption; TotalLCYCaptionLbl)            {            }            column(VendorPhoneNoCaption; FieldCaption("Phone No."))            {            }            column(VendorContactCaption; FieldCaption(Contact))            {            }            dataitem("Vendor Ledger Entry"; "Vendor Ledger Entry")            {                DataItemLink = "Vendor No." = field("No.");                DataItemTableView = sorting("Vendor No.", "Posting Date", "Currency Code");                PrintOnlyIfDetail = true;                trigger OnAfterGetRecord()                var                    VendorLedgEntry: Record "Vendor Ledger Entry";                begin                    VendorLedgEntry.SetCurrentKey("Closed by Entry No.");                    VendorLedgEntry.SetRange("Closed by Entry No.", "Entry No.");                    VendorLedgEntry.SetRange("Posting Date", 0D, EndingDate);                    CopyDimFiltersFromVendor(VendorLedgEntry);                    if VendorLedgEntry.FindSet(false) then                        repeat                            InsertTemp(VendorLedgEntry);                        until VendorLedgEntry.Next() = 0;                    if "Closed by Entry No." <> 0 then begin                        VendorLedgEntry.SetRange("Closed by Entry No.", "Closed by Entry No.");                        if VendorLedgEntry.FindSet(false) then                            repeat                                InsertTemp(VendorLedgEntry);                            until VendorLedgEntry.Next() = 0;                    end;                    VendorLedgEntry.Reset();                    VendorLedgEntry.SetRange("Entry No.", "Closed by Entry No.");                    VendorLedgEntry.SetRange("Posting Date", 0D, EndingDate);                    CopyDimFiltersFromVendor(VendorLedgEntry);                    if VendorLedgEntry.FindSet(false) then                        repeat                            InsertTemp(VendorLedgEntry);                        until VendorLedgEntry.Next() = 0;                    CurrReport.Skip();                end;                trigger OnPreDataItem()                begin                    SetRange("Posting Date", EndingDate + 1, DMY2Date(31, 12, 9999));                    CopyDimFiltersFromVendor("Vendor Ledger Entry");                    Vendor.CopyFilter("Currency Filter", "Currency Code");                end;            }            dataitem(OpenVendorLedgEntry; "Vendor Ledger Entry")            {                DataItemLink = "Vendor No." = field("No.");                DataItemTableView = sorting("Vendor No.", Open, Positive, "Due Date", "Currency Code");                PrintOnlyIfDetail = true;                trigger OnAfterGetRecord()                begin                    if AgingBy = AgingBy::"Posting Date" then begin                        CalcFields("Remaining Amt. (LCY)");                        if "Remaining Amt. (LCY)" = 0 then                            CurrReport.Skip();                    end;                    InsertTemp(OpenVendorLedgEntry);                    CurrReport.Skip();                end;                trigger OnPreDataItem()                begin                    if AgingBy = AgingBy::"Posting Date" then begin                        SetRange("Posting Date", 0D, EndingDate);                        SetRange("Date Filter", 0D, EndingDate);                    end;                    CopyDimFiltersFromVendor(OpenVendorLedgEntry);                    Vendor.CopyFilter("Currency Filter", "Currency Code");                end;            }            dataitem(CurrencyLoop; "Integer")            {                DataItemTableView = sorting(Number) where(Number = filter(1 ..));                PrintOnlyIfDetail = true;                dataitem(TempVendortLedgEntryLoop; "Integer")                {                    DataItemTableView = sorting(Number) where(Number = filter(1 ..));                    column(VendorName; Vendor.Name)                    {                    }                    column(VendorNo; Vendor."No.")                    {                    }                    column(VendorPhoneNo; Vendor."Phone No.")                    {                    }                    column(VendorContactName; Vendor.Contact)                    {                    }                    column(VLEEndingDateRemAmtLCY; VendorLedgEntryEndingDate."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(AgedVLE1RemAmtLCY; AgedVendorLedgEntry[1]."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt2RemAmtLCY; AgedVendorLedgEntry[2]."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt3RemAmtLCY; AgedVendorLedgEntry[3]."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt4RemAmtLCY; AgedVendorLedgEntry[4]."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt5RemAmtLCY; AgedVendorLedgEntry[5]."Remaining Amt. (LCY)")                    {                        AutoFormatType = 1;                    }                    column(VendLedgEntryEndDtAmtLCY; VendorLedgEntryEndingDate."Amount (LCY)")                    {                        AutoFormatType = 1;                    }                    column(VendLedgEntryEndDtDueDate; Format(VendorLedgEntryEndingDate."Due Date"))                    {                    }                    column(VendLedgEntryEndDtDocNo; DocumentNo)                    {                    }                    column(VendLedgEntyEndgDtDocType; Format(VendorLedgEntryEndingDate."Document Type"))                    {                    }                    column(VendLedgEntryEndDtPostgDt; Format(VendorLedgEntryEndingDate."Posting Date"))                    {                    }                    column(AgedVendLedgEnt5RemAmt; AgedVendorLedgEntry[5]."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt4RemAmt; AgedVendorLedgEntry[4]."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt3RemAmt; AgedVendorLedgEntry[3]."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt2RemAmt; AgedVendorLedgEntry[2]."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(AgedVendLedgEnt1RemAmt; AgedVendorLedgEntry[1]."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(VLEEndingDateRemAmt; VendorLedgEntryEndingDate."Remaining Amount")                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(VendLedgEntryEndingDtAmt; VendorLedgEntryEndingDate.Amount)                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    column(TotalVendorName; StrSubstNo(Text005, Vendor.Name))                    {                    }                    column(CurrCode_TempVenLedgEntryLoop; CurrencyCode)                    {                        AutoFormatExpression = CurrencyCode;                        AutoFormatType = 1;                    }                    trigger OnAfterGetRecord()                    var                        PeriodIndex: Integer;                    begin                        if Number = 1 then begin                            if not TempVendorLedgEntry.FindSet(false) then                                CurrReport.Break();                        end else                            if TempVendorLedgEntry.Next() = 0 then                                CurrReport.Break();                        VendorLedgEntryEndingDate := TempVendorLedgEntry;                        DetailedVendorLedgerEntry.SetRange("Vendor Ledger Entry No.", VendorLedgEntryEndingDate."Entry No.");                        if DetailedVendorLedgerEntry.FindSet(false) then                            repeat                                if (DetailedVendorLedgerEntry."Entry Type" =                                    DetailedVendorLedgerEntry."Entry Type"::"Initial Entry") and                                   (VendorLedgEntryEndingDate."Posting Date" > EndingDate) and                                   (AgingBy <> AgingBy::"Posting Date")                                then                                    if (VendorLedgEntryEndingDate."Document Date" <= EndingDate) and                                       (VendorLedgEntryEndingDate."Posting Date" <= EndingDate)                                    then                                        DetailedVendorLedgerEntry."Posting Date" :=                                          VendorLedgEntryEndingDate."Document Date"                                    else                                        if (VendorLedgEntryEndingDate."Due Date" <= EndingDate) and                                           (AgingBy = AgingBy::"Due Date")                                        then                                            DetailedVendorLedgerEntry."Posting Date" :=                                              VendorLedgEntryEndingDate."Due Date";                                if (DetailedVendorLedgerEntry."Posting Date" <= EndingDate) or                                   (TempVendorLedgEntry.Open and                                    (AgingBy = AgingBy::"Due Date") and                                    (VendorLedgEntryEndingDate."Due Date" > EndingDate) and                                    (VendorLedgEntryEndingDate."Posting Date" <= EndingDate))                                then begin                                    if DetailedVendorLedgerEntry."Entry Type" in                                       [DetailedVendorLedgerEntry."Entry Type"::"Initial Entry",                                        DetailedVendorLedgerEntry."Entry Type"::"Unrealized Loss",                                        DetailedVendorLedgerEntry."Entry Type"::"Unrealized Gain",                                        DetailedVendorLedgerEntry."Entry Type"::"Realized Loss",                                        DetailedVendorLedgerEntry."Entry Type"::"Realized Gain",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount (VAT Excl.)",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount (VAT Adjustment)",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Tolerance",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount Tolerance",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Tolerance (VAT Excl.)",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Tolerance (VAT Adjustment)",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount Tolerance (VAT Excl.)",                                        DetailedVendorLedgerEntry."Entry Type"::"Payment Discount Tolerance (VAT Adjustment)"]                                    then begin                                        VendorLedgEntryEndingDate.Amount := VendorLedgEntryEndingDate.Amount + DetailedVendorLedgerEntry.Amount;                                        VendorLedgEntryEndingDate."Amount (LCY)" :=                                          VendorLedgEntryEndingDate."Amount (LCY)" + DetailedVendorLedgerEntry."Amount (LCY)";                                    end;                                    if DetailedVendorLedgerEntry."Posting Date" <= EndingDate then begin                                        VendorLedgEntryEndingDate."Remaining Amount" :=                                          VendorLedgEntryEndingDate."Remaining Amount" + DetailedVendorLedgerEntry.Amount;                                        VendorLedgEntryEndingDate."Remaining Amt. (LCY)" :=                                          VendorLedgEntryEndingDate."Remaining Amt. (LCY)" + DetailedVendorLedgerEntry."Amount (LCY)";                                    end;                                end;                            until DetailedVendorLedgerEntry.Next() = 0;                        if UseExternalDocNo then                            DocumentNo := VendorLedgEntryEndingDate."External Document No."                        else                            DocumentNo := VendorLedgEntryEndingDate."Document No.";                        if VendorLedgEntryEndingDate."Remaining Amount" = 0 then                            CurrReport.Skip();                        case AgingBy of                            AgingBy::"Due Date":                                PeriodIndex := GetPeriodIndex(VendorLedgEntryEndingDate."Due Date");                            AgingBy::"Posting Date":                                PeriodIndex := GetPeriodIndex(VendorLedgEntryEndingDate."Posting Date");                            AgingBy::"Document Date":                                begin                                    if VendorLedgEntryEndingDate."Document Date" > EndingDate then begin                                        VendorLedgEntryEndingDate."Remaining Amount" := 0;                                        VendorLedgEntryEndingDate."Remaining Amt. (LCY)" := 0;                                        VendorLedgEntryEndingDate."Document Date" := VendorLedgEntryEndingDate."Posting Date";                                    end;                                    PeriodIndex := GetPeriodIndex(VendorLedgEntryEndingDate."Document Date");                                end;                        end;                        Clear(AgedVendorLedgEntry);                        AgedVendorLedgEntry[PeriodIndex]."Remaining Amount" := VendorLedgEntryEndingDate."Remaining Amount";                        AgedVendorLedgEntry[PeriodIndex]."Remaining Amt. (LCY)" := VendorLedgEntryEndingDate."Remaining Amt. (LCY)";                        TotalVendorLedgEntry[PeriodIndex]."Remaining Amount" += VendorLedgEntryEndingDate."Remaining Amount";                        TotalVendorLedgEntry[PeriodIndex]."Remaining Amt. (LCY)" += VendorLedgEntryEndingDate."Remaining Amt. (LCY)";                        GrandTotalVLERemaingAmtLCY[PeriodIndex] += VendorLedgEntryEndingDate."Remaining Amt. (LCY)";                        TotalVendorLedgEntry[1].Amount += VendorLedgEntryEndingDate."Remaining Amount";                        TotalVendorLedgEntry[1]."Amount (LCY)" += VendorLedgEntryEndingDate."Remaining Amt. (LCY)";                        GrandTotalVLEAmtLCY += VendorLedgEntryEndingDate."Remaining Amt. (LCY)";                    end;                    trigger OnPostDataItem()                    begin                        if not PrintAmountInLCY then                            UpdateCurrencyTotals();                    end;                    trigger OnPreDataItem()                    begin                        if not PrintAmountInLCY then                            TempVendorLedgEntry.SetRange("Currency Code", TempCurrency.Code);                    end;                }                trigger OnAfterGetRecord()                begin                    Clear(TotalVendorLedgEntry);                    if Number = 1 then begin                        if not TempCurrency.FindSet(false) then                            CurrReport.Break();                    end else                        if TempCurrency.Next() = 0 then                            CurrReport.Break();                    if TempCurrency.Code <> '' then                        CurrencyCode := TempCurrency.Code                    else                        CurrencyCode := GLSetup."LCY Code";                    NumberOfCurrencies := NumberOfCurrencies + 1;                end;                trigger OnPreDataItem()                begin                    NumberOfCurrencies := 0;                end;            }            trigger OnAfterGetRecord()            begin                if NewPagePerVendor then                    PageGroupNo := PageGroupNo + 1;                TempCurrency.Reset();                TempCurrency.DeleteAll();                TempVendorLedgEntry.Reset();                TempVendorLedgEntry.DeleteAll();                Clear(GrandTotalVLERemaingAmtLCY);                GrandTotalVLEAmtLCY := 0;            end;            trigger OnPreDataItem()            begin                PageGroupNo := 1;            end;        }        dataitem(CurrencyTotals; "Integer")        {            DataItemTableView = sorting(Number) where(Number = filter(1 ..));            column(Number_CurrencyTotals; Number)            {            }            column(NewPagePerVend_CurrTotal; NewPagePerVendor)            {            }            column(TempCurrency2Code; TempCurrency2.Code)            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt6RemAmtLCY5; AgedVendorLedgEntry[6]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt1RemAmtLCY1; AgedVendorLedgEntry[1]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt2RemAmtLCY2; AgedVendorLedgEntry[2]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt3RemAmtLCY3; AgedVendorLedgEntry[3]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt4RemAmtLCY4; AgedVendorLedgEntry[4]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(AgedVendLedgEnt5RemAmtLCY5; AgedVendorLedgEntry[5]."Remaining Amount")            {                AutoFormatExpression = TempCurrency2.Code;                AutoFormatType = 1;            }            column(CurrencySpecificationCaption; CurrencySpecificationCaptionLbl)            {            }            trigger OnAfterGetRecord()            begin                if Number = 1 then begin                    if not TempCurrency2.FindSet(false) then                        CurrReport.Break();                end else                    if TempCurrency2.Next() = 0 then                        CurrReport.Break();                Clear(AgedVendorLedgEntry);                TempCurrencyAmount.SetRange("Currency Code", TempCurrency2.Code);                if TempCurrencyAmount.FindSet(false) then                    repeat                        if TempCurrencyAmount.Date <> DMY2Date(31, 12, 9999) then                            AgedVendorLedgEntry[GetPeriodIndex(TempCurrencyAmount.Date)]."Remaining Amount" :=                              TempCurrencyAmount.Amount                        else                            AgedVendorLedgEntry[6]."Remaining Amount" := TempCurrencyAmount.Amount;                    until TempCurrencyAmount.Next() = 0;            end;            trigger OnPreDataItem()            begin                PageGroupNo := 0;            end;        }    }    requestpage    {        SaveValues = true;        AboutTitle = 'About Aged Accounts Payable (Obsolete)';        AboutText = 'Analyze vendor balances at the end of each period by calculating outstanding invoice, credit memo, and payment totals in three periods of equal length. Monitor unpaid invoices, and prioritize payments for overdue accounts.** This report is obsolete and will be removed in a future release.** Please refer to the report documentation for alternative ways to retrieve this information.';        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(AgedAsOf; EndingDate)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Aged As Of';                        ToolTip = 'Specifies the date that you want the aging calculated for.';                    }                    field(AgingBy; AgingBy)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Aging by';                        OptionCaption = 'Due Date,Posting Date,Document Date';                        ToolTip = 'Specifies if the aging will be calculated from the due date, the posting date, or the document date.';                    }                    field(PeriodLength; PeriodLength)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Period Length';                        ToolTip = 'Specifies the period for which data is shown in the report. For example, enter "1M" for one month, "30D" for thirty days, "3Q" for three quarters, or "5Y" for five years.';                    }                    field(PrintAmountInLCY; PrintAmountInLCY)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Print Amounts in LCY';                        ToolTip = 'Specifies if you want the report to specify the aging per vendor ledger entry.';                    }                    field(PrintDetails; PrintDetails)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Print Details';                        ToolTip = 'Specifies if you want the report to show the detailed entries that add up the total balance for each vendor.';                    }                    field(HeadingType; HeadingType)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Heading Type';                        OptionCaption = 'Date Interval,Number of Days';                        ToolTip = 'Specifies if the column heading for the three periods will indicate a date interval or the number of days overdue.';                    }                    field(NewPagePerVendor; NewPagePerVendor)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'New Page per Vendor';                        ToolTip = 'Specifies if each vendor''s information is printed on a new page if you have chosen two or more vendors to be included in the report.';                    }                    field(UseExternalDocNo; UseExternalDocNo)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Use External Document No.';                        ToolTip = 'Specifies if you want to print the vendor''s document numbers, such as the invoice number, on all transactions. Clear this check box to print only internal document numbers.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if EndingDate = 0D then                EndingDate := WorkDate();            if Format(PeriodLength) = '' then                Evaluate(PeriodLength, '<1M>');        end;    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Purchases/Reports/AgedAccountsPayable.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    var        FormatDocument: Codeunit "Format Document";    begin        VendorFilter := FormatDocument.GetRecordFiltersWithCaptions(Vendor);        GLSetup.Get();        CalcDates();        CreateHeadings();        TodayFormatted := Format(CurrentDateTime());        CompanyDisplayName := COMPANYPROPERTY.DisplayName();        if UseExternalDocNo then            DocNoCaption := ExternalDocumentNoCaptionLbl        else            DocNoCaption := DocumentNoCaptionLbl;    end;    var        GLSetup: Record "General Ledger Setup";        VendorLedgEntryEndingDate: Record "Vendor Ledger Entry";        TotalVendorLedgEntry: array[5] of Record "Vendor Ledger Entry";        AgedVendorLedgEntry: array[6] of Record "Vendor Ledger Entry";        TempCurrency: Record Currency temporary;        TempCurrency2: Record Currency temporary;        TempCurrencyAmount: Record "Currency Amount" temporary;        DetailedVendorLedgerEntry: Record "Detailed Vendor Ledg. Entry";        PeriodLength: DateFormula;        GrandTotalVLERemaingAmtLCY: array[5] of Decimal;        GrandTotalVLEAmtLCY: Decimal;        PrintAmountInLCY: Boolean;        EndingDate: Date;        AgingBy: Option "Due Date","Posting Date","Document Date";        UseExternalDocNo: Boolean;        HeadingType: Option "Date Interval","Number of Days";        NewPagePerVendor: Boolean;        PeriodStartDate: array[5] of Date;        PeriodEndDate: array[5] of Date;        HeaderText: array[5] of Text[30];#pragma warning disable AA0074        Text000: Label 'Not Due';#pragma warning restore AA0074        AfterTok: Label 'After';        BeforeTok: Label 'Before';        CurrencyCode: Code[10];        NumberOfCurrencies: Integer;        PageGroupNo: Integer;        TodayFormatted: Text;        CompanyDisplayName: Text;        DocNoCaption: Text;        DocumentNo: Code[35];#pragma warning disable AA0074        Text002: Label 'days';#pragma warning disable AA0470        Text004: Label 'Aged by %1';        Text005: Label 'Total for %1';        Text006: Label 'Aged as of %1';        Text007: Label 'Aged by %1';#pragma warning restore AA0470        Text009: Label 'Due Date,Posting Date,Document Date';#pragma warning disable AA0470        Text010: Label 'The Date Formula %1 cannot be used. Try to restate it, for example, by using 1M+CM instead of CM+1M.';#pragma warning restore AA0470        Text027: Label '-%1', Comment = 'Negating the period length: %1 is the period length';#pragma warning restore AA0074        EnterDateFormulaErr: Label 'Enter a date formula in the Period Length field.';        AgedAcctPayableCaptionLbl: Label 'Aged Accounts Payable';        CurrReportPageNoCaptionLbl: Label 'Page';        AllAmtsinLCYCaptionLbl: Label 'All Amounts in LCY';        AgedOverdueAmsCaptionLbl: Label 'Aged Overdue Amounts';        GrandTotalVLE5RemAmtLCYCaptionLbl: Label 'Balance';        AmountLCYCaptionLbl: Label 'Original Amount';        DueDateCaptionLbl: Label 'Due Date';        DocumentNoCaptionLbl: Label 'Document No.';        ExternalDocumentNoCaptionLbl: Label 'External Document No.';        PostingDateCaptionLbl: Label 'Posting Date';        DocumentTypeCaptionLbl: Label 'Document Type';        CurrencyCaptionLbl: Label 'Currency Code';        TotalLCYCaptionLbl: Label 'Total (LCY)';        CurrencySpecificationCaptionLbl: Label 'Currency Specification';    protected var        TempVendorLedgEntry: Record "Vendor Ledger Entry" temporary;        VendorFilter: Text;        PrintDetails: Boolean;    local procedure CalcDates()    var        PeriodLength2: DateFormula;        i: Integer;    begin        if not Evaluate(PeriodLength2, StrSubstNo(Text027, PeriodLength)) then            Error(EnterDateFormulaErr);        if AgingBy = AgingBy::"Due Date" then begin            PeriodEndDate[1] := DMY2Date(31, 12, 9999);            PeriodStartDate[1] := EndingDate + 1;        end else begin            PeriodEndDate[1] := EndingDate;            PeriodStartDate[1] := CalcDate(PeriodLength2, EndingDate + 1);        end;        for i := 2 to ArrayLen(PeriodEndDate) do begin            PeriodEndDate[i] := PeriodStartDate[i - 1] - 1;            PeriodStartDate[i] := CalcDate(PeriodLength2, PeriodEndDate[i] + 1);        end;        i := ArrayLen(PeriodEndDate);        PeriodStartDate[i] := 0D;        for i := 1 to ArrayLen(PeriodEndDate) do            if PeriodEndDate[i] < PeriodStartDate[i] then                Error(Text010, PeriodLength);    end;    local procedure CreateHeadings()    var        i: Integer;    begin        if AgingBy = AgingBy::"Due Date" then begin            HeaderText[1] := Text000;            i := 2;        end else            i := 1;        while i < ArrayLen(PeriodEndDate) do begin            if HeadingType = HeadingType::"Date Interval" then                HeaderText[i] := StrSubstNo('%1\..%2', PeriodStartDate[i], PeriodEndDate[i])            else                HeaderText[i] :=                  StrSubstNo('%1 - %2 %3', EndingDate - PeriodEndDate[i] + 1, EndingDate - PeriodStartDate[i] + 1, Text002);            i := i + 1;        end;        if HeadingType = HeadingType::"Date Interval" then            HeaderText[i] := StrSubstNo('%1\%2', BeforeTok, PeriodStartDate[i - 1])        else            HeaderText[i] := StrSubstNo('%1 %2 %3', AfterTok, EndingDate - PeriodStartDate[i - 1] + 1, Text002);    end;    local procedure InsertTemp(var VendorLedgEntry: Record "Vendor Ledger Entry")    var        Currency: Record Currency;    begin        if TempVendorLedgEntry.Get(VendorLedgEntry."Entry No.") then            exit;        TempVendorLedgEntry := VendorLedgEntry;        TempVendorLedgEntry.Insert();        if PrintAmountInLCY then begin            Clear(TempCurrency);            TempCurrency."Amount Rounding Precision" := GLSetup."Amount Rounding Precision";            if TempCurrency.Insert() then;            exit;        end;        if TempCurrency.Get(TempVendorLedgEntry."Currency Code") then            exit;        if TempVendorLedgEntry."Currency Code" <> '' then            Currency.Get(TempVendorLedgEntry."Currency Code")        else begin            Clear(Currency);            Currency."Amount Rounding Precision" := GLSetup."Amount Rounding Precision";        end;        TempCurrency := Currency;        TempCurrency.Insert();    end;    local procedure GetPeriodIndex(Date: Date): Integer    var        i: Integer;    begin        for i := 1 to ArrayLen(PeriodEndDate) do            if Date in [PeriodStartDate[i] .. PeriodEndDate[i]] then                exit(i);    end;    local procedure UpdateCurrencyTotals()    var        i: Integer;    begin        TempCurrency2.Code := CurrencyCode;        if TempCurrency2.Insert() then;        for i := 1 to ArrayLen(TotalVendorLedgEntry) do begin            TempCurrencyAmount."Currency Code" := CurrencyCode;            TempCurrencyAmount.Date := PeriodStartDate[i];            if TempCurrencyAmount.Find() then begin                TempCurrencyAmount.Amount := TempCurrencyAmount.Amount + TotalVendorLedgEntry[i]."Remaining Amount";                TempCurrencyAmount.Modify();            end else begin                TempCurrencyAmount."Currency Code" := CurrencyCode;                TempCurrencyAmount.Date := PeriodStartDate[i];                TempCurrencyAmount.Amount := TotalVendorLedgEntry[i]."Remaining Amount";                TempCurrencyAmount.Insert();            end;        end;        TempCurrencyAmount."Currency Code" := CurrencyCode;        TempCurrencyAmount.Date := DMY2Date(31, 12, 9999);        if TempCurrencyAmount.Find() then begin            TempCurrencyAmount.Amount := TempCurrencyAmount.Amount + TotalVendorLedgEntry[1].Amount;            TempCurrencyAmount.Modify();        end else begin            TempCurrencyAmount."Currency Code" := CurrencyCode;            TempCurrencyAmount.Date := DMY2Date(31, 12, 9999);            TempCurrencyAmount.Amount := TotalVendorLedgEntry[1].Amount;            TempCurrencyAmount.Insert();        end;    end;    procedure InitializeRequest(NewEndingDate: Date; NewAgingBy: Option; NewPeriodLength: DateFormula; NewPrintAmountInLCY: Boolean; NewPrintDetails: Boolean; NewHeadingType: Option; NewNewPagePerVendor: Boolean)    begin        EndingDate := NewEndingDate;        AgingBy := NewAgingBy;        PeriodLength := NewPeriodLength;        PrintAmountInLCY := NewPrintAmountInLCY;        PrintDetails := NewPrintDetails;        HeadingType := NewHeadingType;        NewPagePerVendor := NewNewPagePerVendor;    end;    local procedure CopyDimFiltersFromVendor(var VendorLedgerEntry: Record "Vendor Ledger Entry")    begin        if Vendor.GetFilter("Global Dimension 1 Filter") <> '' then            VendorLedgerEntry.SetFilter("Global Dimension 1 Code", Vendor.GetFilter("Global Dimension 1 Filter"));        if Vendor.GetFilter("Global Dimension 2 Filter") <> '' then            VendorLedgerEntry.SetFilter("Global Dimension 2 Code", Vendor.GetFilter("Global Dimension 2 Filter"));    end;}#endif