Report 322 Aged Accounts Payable
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