Codeunit 763 Aged Acc. Receivable
src/Layers/W1/BaseApp/Finance/ReceivablesPayables/AgedAccReceivable.Codeunit.al578 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.Finance.ReceivablesPayables;using Microsoft.CRM.Outlook;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using Microsoft.Utilities;using System.Visualization;/// <summary>/// Provides aged accounts receivable analysis and chart generation for customer outstanding balances./// Calculates aging periods, generates business chart data, and supports drill-down functionality for receivables management./// </summary>/// <remarks>/// Generates aging analysis using customer ledger entries with configurable period lengths and aging intervals./// Supports both summary view across all customers and detailed per-customer aging analysis./// Integrates with business chart controls for visual representation of aged receivables data./// Chart generation includes period-based aging buckets and overdue amount calculations./// </remarks>codeunit 763 "Aged Acc. Receivable"{ trigger OnRun() begin BackgroundUpdateDataPerCustomer(); end; var GeneralLedgerSetup: Record "General Ledger Setup"; GLSetupLoaded: Boolean; OverdueTxt: Label 'Overdue'; AmountTxt: Label 'Amount'; NotDueTxt: Label 'Not Overdue'; OlderTxt: Label 'Older'; StatusNonPeriodicTxt: Label 'All receivables, not overdue and overdue'; StatusPeriodLengthTxt: Label 'Period Length: '; Status2WeekOverdueTxt: Label '2 weeks overdue'; Status3MonthsOverdueTxt: Label '3 months overdue'; Status1YearOverdueTxt: Label '1 year overdue'; Status3YearsOverdueTxt: Label '3 years overdue'; Status5YearsOverdueTxt: Label '5 years overdue'; ChartDescriptionMsg: Label 'Shows customers'' pending payment amounts summed for a period that you select.\\The first column shows the amount on pending payments that are not past the due date. The following column or columns show overdue amounts within the selected period from the payment due date. The chart shows overdue payment amounts going back up to five years from today''s date depending on the period that you select.'; ChartPerCustomerDescriptionMsg: Label 'Shows the customer''s pending payment amount summed for a period that you select.\\The first column shows the amount on pending payments that are not past the due date. The following column or columns show overdue amounts within the selected period from the payment due date. The chart shows overdue payment amounts going back up to five years from today''s date depending on the period that you select.'; Status1MonthOverdueTxt: Label '1 month overdue'; Status1QuarterOverdueTxt: Label '1 quarter overdue'; local procedure BackgroundUpdateDataPerCustomer() var BusinessChartBuffer: Record "Business Chart Buffer"; TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary; CustomerNo: Code[20]; PeriodLength: Text[1]; NoOfPeriods: Integer; Params: Dictionary of [Text, Text]; Results: Dictionary of [Text, Text]; RowNo: Integer; begin Params := Page.GetBackgroundParameters(); CustomerNo := CopyStr(Params.Get('CustomerNo'), 1, MaxStrLen(CustomerNo)); if CustomerNo = '' then exit; if not evaluate(BusinessChartBuffer."Period Filter Start Date", Params.Get('StartDate'), 9) then exit; if not evaluate(BusinessChartBuffer."Period Length", Params.Get('PeriodLength'), 9) then exit; InitParameters(BusinessChartBuffer, PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); CalculateAgedAccReceivable( CustomerNo, '', BusinessChartBuffer."Period Filter Start Date", PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); if TempEntryNoAmountBuf.FindSet() then repeat RowNo += 1; Results.Add('EntryNo¤%1' + Format(RowNo), Format(TempEntryNoAmountBuf."Entry No.", 0, 9)); Results.Add('Amount¤%1' + Format(RowNo), Format(TempEntryNoAmountBuf.Amount, 0, 9)); Results.Add('Amount2¤%1' + Format(RowNo), Format(TempEntryNoAmountBuf.Amount2, 0, 9)); Results.Add('EndDate¤%1' + Format(RowNo), Format(TempEntryNoAmountBuf."End Date", 0, 9)); Results.Add('StartDate¤%1' + Format(RowNo), Format(TempEntryNoAmountBuf."Start Date", 0, 9)); until TempEntryNoAmountBuf.Next() = 0; Page.SetBackgroundTaskResult(Results); end; /// <summary> /// Updates business chart buffer with aged receivable data for a specific customer. /// Generates aging analysis with default initialization settings. /// </summary> /// <param name="BusChartBuf">Business chart buffer to populate with aging data</param> /// <param name="CustomerNo">Customer number for aging analysis</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer for amount calculations</param> [Scope('OnPrem')] procedure UpdateDataPerCustomer(var BusChartBuf: Record "Business Chart Buffer"; CustomerNo: Code[20]; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary) begin UpdateDataPerCustomer(BusChartBuf, CustomerNo, TempEntryNoAmountBuf, false); end; /// <summary> /// Updates business chart buffer with aged receivable data for a specific customer with initialization control. /// Configures chart structure and calculates aging buckets based on period settings. /// </summary> /// <param name="BusChartBuf">Business chart buffer to populate with aging data</param> /// <param name="CustomerNo">Customer number for aging analysis</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer for amount calculations</param> /// <param name="AlreadyInitialized">Whether chart parameters are already initialized</param> [Scope('OnPrem')] procedure UpdateDataPerCustomer(var BusChartBuf: Record "Business Chart Buffer"; CustomerNo: Code[20]; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary; AlreadyInitialized: Boolean) var PeriodIndex: Integer; PeriodLength: Text[1]; NoOfPeriods: Integer; begin BusChartBuf.Initialize(); BusChartBuf.SetXAxis(OverDueText(), BusChartBuf."Data Type"::String); BusChartBuf.AddDecimalMeasure(AmountText(), 1, BusChartBuf."Chart Type"::Column); if AlreadyInitialized then InitParameters(BusChartBuf, PeriodLength, NoOfPeriods) else begin InitParameters(BusChartBuf, PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); CalculateAgedAccReceivable( CustomerNo, '', BusChartBuf."Period Filter Start Date", PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); end; if TempEntryNoAmountBuf.FindSet() then repeat PeriodIndex := TempEntryNoAmountBuf."Entry No."; BusChartBuf.AddColumn(FormatColumnName(PeriodIndex, PeriodLength, NoOfPeriods, BusChartBuf."Period Length")); BusChartBuf.SetValueByIndex(0, PeriodIndex, RoundAmount(TempEntryNoAmountBuf.Amount)); until TempEntryNoAmountBuf.Next() = 0 end; /// <summary> /// Updates business chart buffer with aged receivable data grouped by customer posting groups. /// Creates stacked column chart showing aging distribution across posting groups. /// </summary> /// <param name="BusChartBuf">Business chart buffer to populate with grouped aging data</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer for amount calculations by group</param> procedure UpdateDataPerGroup(var BusChartBuf: Record "Business Chart Buffer"; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary) var CustPostingGroup: Record "Customer Posting Group"; PeriodIndex: Integer; GroupIndex: Integer; PeriodLength: Text[1]; NoOfPeriods: Integer; begin BusChartBuf.Initialize(); BusChartBuf.SetXAxis(OverdueTxt, BusChartBuf."Data Type"::String); InitParameters(BusChartBuf, PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); CalculateAgedAccReceivablePerGroup( BusChartBuf."Period Filter Start Date", PeriodLength, NoOfPeriods, TempEntryNoAmountBuf); if CustPostingGroup.FindSet() then repeat BusChartBuf.AddDecimalMeasure(CustPostingGroup.Code, GroupIndex, BusChartBuf."Chart Type"::StackedColumn); TempEntryNoAmountBuf.Reset(); TempEntryNoAmountBuf.SetRange("Business Unit Code", CustPostingGroup.Code); if TempEntryNoAmountBuf.FindSet() then repeat PeriodIndex := TempEntryNoAmountBuf."Entry No."; if GroupIndex = 0 then BusChartBuf.AddColumn(FormatColumnName(PeriodIndex, PeriodLength, NoOfPeriods, BusChartBuf."Period Length")); BusChartBuf.SetValueByIndex(GroupIndex, PeriodIndex, RoundAmount(TempEntryNoAmountBuf.Amount)); until TempEntryNoAmountBuf.Next() = 0; GroupIndex += 1; until CustPostingGroup.Next() = 0; TempEntryNoAmountBuf.Reset(); end; local procedure CalculateAgedAccReceivable(CustomerNo: Code[20]; CustomerGroupCode: Code[20]; StartDate: Date; PeriodLength: Text[1]; NoOfPeriods: Integer; var TempEntryNoAmountBuffer: Record "Entry No. Amount Buffer" temporary) var CustLedgEntryRemainAmt: Query "Cust. Ledg. Entry Remain. Amt."; RemainingAmountLCY: Decimal; EndDate: Date; Index: Integer; begin if CustomerNo <> '' then CustLedgEntryRemainAmt.SetRange(Customer_No, CustomerNo); if CustomerGroupCode <> '' then CustLedgEntryRemainAmt.SetRange(Customer_Posting_Group, CustomerGroupCode); CustLedgEntryRemainAmt.SetRange(IsOpen, true); for Index := 0 to NoOfPeriods - 1 do begin RemainingAmountLCY := 0; CustLedgEntryRemainAmt.SetFilter( Due_Date, DateFilterByAge(Index, StartDate, PeriodLength, NoOfPeriods, EndDate)); CustLedgEntryRemainAmt.Open(); if CustLedgEntryRemainAmt.Read() then RemainingAmountLCY := CustLedgEntryRemainAmt.Sum_Remaining_Amt_LCY; InsertAmountBuffer(Index, CustomerGroupCode, RemainingAmountLCY, StartDate, EndDate, TempEntryNoAmountBuffer) end; end; local procedure CalculateAgedAccReceivablePerGroup(StartDate: Date; PeriodLength: Text[1]; NoOfPeriods: Integer; var TempEntryNoAmountBuffer: Record "Entry No. Amount Buffer" temporary) var CustPostingGroup: Record "Customer Posting Group"; TempEntryNoAmtBuf: Record "Entry No. Amount Buffer" temporary; CustRemainAmtByDueDate: Query "Cust. Remain. Amt. By Due Date"; EntryNo: Integer; Index: Integer; RemainingAmountLCY: Decimal; PeriodStartDate: Date; PeriodEndDate: Date; begin CustRemainAmtByDueDate.SetRange(IsOpen, true); CustRemainAmtByDueDate.Open(); while CustRemainAmtByDueDate.Read() do begin EntryNo += 1; TempEntryNoAmtBuf."Entry No." := EntryNo; TempEntryNoAmtBuf."Business Unit Code" := CustRemainAmtByDueDate.Customer_Posting_Group; TempEntryNoAmtBuf.Amount := CustRemainAmtByDueDate.Sum_Remaining_Amt_LCY; TempEntryNoAmtBuf."Start Date" := CustRemainAmtByDueDate.Due_Date; TempEntryNoAmtBuf.Insert(); end; if CustPostingGroup.FindSet() then repeat PeriodStartDate := StartDate; TempEntryNoAmtBuf.SetRange("Business Unit Code", CustPostingGroup.Code); for Index := 0 to NoOfPeriods - 1 do begin RemainingAmountLCY := 0; TempEntryNoAmtBuf.SetFilter("Start Date", DateFilterByAge(Index, PeriodStartDate, PeriodLength, NoOfPeriods, PeriodEndDate)); if TempEntryNoAmtBuf.FindSet() then repeat RemainingAmountLCY += TempEntryNoAmtBuf.Amount; until TempEntryNoAmtBuf.Next() = 0; InsertAmountBuffer(Index, CustPostingGroup.Code, RemainingAmountLCY, PeriodStartDate, PeriodEndDate, TempEntryNoAmountBuffer) end; until CustPostingGroup.Next() = 0; end; /// <summary> /// Generates date filter string for aging period based on index and period settings. /// Calculates appropriate date ranges for not due and overdue amounts. /// </summary> /// <param name="Index">Period index for aging bucket calculation</param> /// <param name="StartDate">Starting date for aging calculation</param> /// <param name="PeriodLength">Period length code for aging intervals</param> /// <param name="NoOfPeriods">Total number of aging periods</param> /// <param name="EndDate">Calculated end date for the period</param> /// <returns>Date filter string for the aging period</returns> procedure DateFilterByAge(Index: Integer; var StartDate: Date; PeriodLength: Text[1]; NoOfPeriods: Integer; var EndDate: Date): Text begin if Index = 0 then // First period - Not due remaining amounts exit(StrSubstNo('>=%1', StartDate)); EndDate := CalcDate('<-1D>', StartDate); if Index = NoOfPeriods - 1 then // Last period - Older remaining amounts StartDate := 0D else StartDate := CalcDate(StrSubstNo('<-1%1>', PeriodLength), StartDate); exit(StrSubstNo('%1..%2', StartDate, EndDate)); end; /// <summary> /// Inserts calculated amount data into temporary buffer for aging period. /// Creates buffer entry with period information and calculated amounts. /// </summary> /// <param name="Index">Period index for the aging bucket</param> /// <param name="BussUnitCode">Business unit code for grouping</param> /// <param name="AmountLCY">Amount in local currency for the period</param> /// <param name="StartDate">Period start date</param> /// <param name="EndDate">Period end date</param> /// <param name="TempEntryNoAmountBuffer">Temporary buffer to insert data into</param> procedure InsertAmountBuffer(Index: Integer; BussUnitCode: Code[20]; AmountLCY: Decimal; StartDate: Date; EndDate: Date; var TempEntryNoAmountBuffer: Record "Entry No. Amount Buffer" temporary) begin TempEntryNoAmountBuffer.Init(); TempEntryNoAmountBuffer."Entry No." := Index; TempEntryNoAmountBuffer."Business Unit Code" := BussUnitCode; TempEntryNoAmountBuffer.Amount := AmountLCY; TempEntryNoAmountBuffer."Start Date" := StartDate; TempEntryNoAmountBuffer."End Date" := EndDate; TempEntryNoAmountBuffer.Insert(); end; /// <summary> /// Initializes aging parameters from business chart buffer settings. /// Extracts period length and number of periods for aging calculation. /// </summary> /// <param name="BusChartBuf">Business chart buffer with parameter settings</param> /// <param name="PeriodLength">Extracted period length for aging intervals</param> /// <param name="NoOfPeriods">Extracted number of aging periods</param> procedure InitParameters(BusChartBuf: Record "Business Chart Buffer"; var PeriodLength: Text[1]; var NoOfPeriods: Integer) begin PeriodLength := GetPeriod(BusChartBuf); NoOfPeriods := GetNoOfPeriods(BusChartBuf); end; /// <summary> /// Initializes aging parameters and clears temporary buffer for fresh calculation. /// Prepares buffer and extracts period settings from chart configuration. /// </summary> /// <param name="BusChartBuf">Business chart buffer with parameter settings</param> /// <param name="PeriodLength">Extracted period length for aging intervals</param> /// <param name="NoOfPeriods">Extracted number of aging periods</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer to clear and initialize</param> procedure InitParameters(BusChartBuf: Record "Business Chart Buffer"; var PeriodLength: Text[1]; var NoOfPeriods: Integer; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary) begin TempEntryNoAmountBuf.DeleteAll(); PeriodLength := GetPeriod(BusChartBuf); NoOfPeriods := GetNoOfPeriods(BusChartBuf); end; local procedure GetPeriod(BusChartBuf: Record "Business Chart Buffer"): Text[1] begin if BusChartBuf."Period Length" = BusChartBuf."Period Length"::None then exit('W'); exit(BusChartBuf.GetPeriodLength()); end; local procedure GetNoOfPeriods(BusChartBuf: Record "Business Chart Buffer"): Integer var NoOfPeriods: Integer; begin NoOfPeriods := 14; case BusChartBuf."Period Length" of BusChartBuf."Period Length"::Day: NoOfPeriods := 16; BusChartBuf."Period Length"::Week, BusChartBuf."Period Length"::Quarter, BusChartBuf."Period Length"::Month: NoOfPeriods := 14; BusChartBuf."Period Length"::Year: NoOfPeriods := 7; BusChartBuf."Period Length"::None: NoOfPeriods := 2; end; exit(NoOfPeriods); end; /// <summary> /// Formats column name for aging chart based on period index and settings. /// Generates appropriate labels for aging buckets and periods. /// </summary> /// <param name="Index">Period index for the aging bucket</param> /// <param name="PeriodLength">Period length code for aging intervals</param> /// <param name="NoOfColumns">Total number of aging columns</param> /// <param name="Period">Period option for formatting</param> /// <returns>Formatted column name for the aging period</returns> procedure FormatColumnName(Index: Integer; PeriodLength: Text[1]; NoOfColumns: Integer; Period: Option): Text var BusChartBuf: Record "Business Chart Buffer"; PeriodDateFormula: DateFormula; begin if Index = 0 then exit(NotDueTxt); if Index = NoOfColumns - 1 then begin if Period = BusChartBuf."Period Length"::None then exit(OverdueTxt); exit(OlderTxt); end; // Period length text localized by date formula Evaluate(PeriodDateFormula, StrSubstNo('<1%1>', PeriodLength)); exit(StrSubstNo('%1%2', Index, DelChr(Format(PeriodDateFormula), '=', '1'))); end; /// <summary> /// Handles drill-down navigation from aging chart to detailed customer ledger entries. /// Opens customer ledger entries filtered by aging period and customer. /// </summary> /// <param name="BusChartBuf">Business chart buffer with drill-down context</param> /// <param name="CustomerNo">Customer number for filtering entries</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer with aging period data</param> procedure DrillDown(var BusChartBuf: Record "Business Chart Buffer"; CustomerNo: Code[20]; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary) var MeasureName: Text; CustomerGroupCode: Code[20]; begin if CustomerNo <> '' then CustomerGroupCode := '' else begin MeasureName := BusChartBuf.GetMeasureName(BusChartBuf."Drill-Down Measure Index"); CustomerGroupCode := CopyStr(MeasureName, 1, MaxStrLen(CustomerGroupCode)); end; if TempEntryNoAmountBuf.Get(CustomerGroupCode, BusChartBuf."Drill-Down X Index") then DrillDownCustLedgEntries(CustomerNo, CustomerGroupCode, TempEntryNoAmountBuf."Start Date", TempEntryNoAmountBuf."End Date"); end; /// <summary> /// Handles drill-down navigation from grouped aging chart to detailed entries. /// Opens customer ledger entries filtered by aging period and posting group. /// </summary> /// <param name="BusChartBuf">Business chart buffer with drill-down context</param> /// <param name="TempEntryNoAmountBuf">Temporary buffer with aging period data by group</param> procedure DrillDownByGroup(var BusChartBuf: Record "Business Chart Buffer"; var TempEntryNoAmountBuf: Record "Entry No. Amount Buffer" temporary) begin DrillDown(BusChartBuf, '', TempEntryNoAmountBuf); end; /// <summary> /// Opens customer ledger entries page with filters for aging period and customer/group. /// Provides detailed view of entries contributing to aging amounts. /// </summary> /// <param name="CustomerNo">Customer number filter for entries</param> /// <param name="CustomerGroupCode">Customer posting group filter for entries</param> /// <param name="StartDate">Start date for aging period filter</param> /// <param name="EndDate">End date for aging period filter</param> procedure DrillDownCustLedgEntries(CustomerNo: Code[20]; CustomerGroupCode: Code[20]; StartDate: Date; EndDate: Date) var CustLedgEntry: Record "Cust. Ledger Entry"; begin CustLedgEntry.SetCurrentKey("Customer No.", Open, Positive, "Due Date"); if CustomerNo <> '' then CustLedgEntry.SetRange("Customer No.", CustomerNo); if EndDate = 0D then CustLedgEntry.SetFilter("Due Date", '>=%1', StartDate) else CustLedgEntry.SetRange("Due Date", StartDate, EndDate); CustLedgEntry.SetRange(Open, true); if CustomerGroupCode <> '' then CustLedgEntry.SetRange("Customer Posting Group", CustomerGroupCode); if CustLedgEntry.IsEmpty() then exit; PAGE.Run(PAGE::"Customer Ledger Entries", CustLedgEntry); end; /// <summary> /// Returns appropriate description text for aging chart based on analysis scope. /// Provides different descriptions for per-customer vs. summary analysis. /// </summary> /// <param name="PerCustomer">Whether analysis is per customer or summary</param> /// <returns>Description text for the aging chart</returns> procedure Description(PerCustomer: Boolean): Text begin if PerCustomer then exit(ChartPerCustomerDescriptionMsg); exit(ChartDescriptionMsg); end; /// <summary> /// Generates status text for aging chart based on period settings and analysis type. /// Creates descriptive status showing period length and aging configuration. /// </summary> /// <param name="BusChartBuf">Business chart buffer with period settings</param> /// <returns>Formatted status text for the chart</returns> procedure UpdateStatusText(BusChartBuf: Record "Business Chart Buffer"): Text var OfficeMgt: Codeunit "Office Management"; StatusText: Text; begin StatusText := StatusPeriodLengthTxt + Format(BusChartBuf."Period Length"); case BusChartBuf."Period Length" of BusChartBuf."Period Length"::Day: StatusText := StatusText + ' | ' + Status2WeekOverdueTxt; BusChartBuf."Period Length"::Week: if OfficeMgt.IsAvailable() then StatusText := StatusText + ' | ' + Status1MonthOverdueTxt else StatusText := StatusText + ' | ' + Status3MonthsOverdueTxt; BusChartBuf."Period Length"::Month: if OfficeMgt.IsAvailable() then StatusText := StatusText + ' | ' + Status1QuarterOverdueTxt else StatusText := StatusText + ' | ' + Status1YearOverdueTxt; BusChartBuf."Period Length"::Quarter: if OfficeMgt.IsAvailable() then StatusText := StatusText + ' | ' + Status1YearOverdueTxt else StatusText := StatusText + ' | ' + Status3YearsOverdueTxt; BusChartBuf."Period Length"::Year: if OfficeMgt.IsAvailable() then StatusText := StatusText + ' | ' + Status3YearsOverdueTxt else StatusText := StatusText + ' | ' + Status5YearsOverdueTxt; BusChartBuf."Period Length"::None: StatusText := StatusNonPeriodicTxt; end; exit(StatusText); end; /// <summary> /// Saves user-specific chart settings for aging analysis preferences. /// Persists period length and chart configuration to user setup. /// </summary> /// <param name="BusChartBuf">Business chart buffer with settings to save</param> procedure SaveSettings(BusChartBuf: Record "Business Chart Buffer") var BusChartUserSetup: Record "Business Chart User Setup"; begin BusChartUserSetup."Period Length" := BusChartBuf."Period Length"; BusChartUserSetup.SaveSetupCU(BusChartUserSetup, CODEUNIT::"Aged Acc. Receivable"); end; /// <summary> /// Calculates average payment days for customer invoices for performance analysis. /// Provides rounded average days between invoice and payment dates. /// </summary> /// <param name="CustomerNo">Customer number for payment days calculation</param> /// <returns>Average payment days rounded to nearest whole number</returns> procedure InvoicePaymentDaysAverage(CustomerNo: Code[20]): Decimal begin exit(Round(CalcInvPmtDaysAverage(CustomerNo), 1)); end; local procedure CalcInvPmtDaysAverage(CustomerNo: Code[20]): Decimal var CustLedgEntry: Record "Cust. Ledger Entry"; DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; PaymentDays: Integer; InvoiceCount: Integer; begin CustLedgEntry.SetCurrentKey("Document Type", "Customer No.", Open); if CustomerNo <> '' then CustLedgEntry.SetRange("Customer No.", CustomerNo); CustLedgEntry.SetRange("Document Type", CustLedgEntry."Document Type"::Invoice); CustLedgEntry.SetRange(Open, false); CustLedgEntry.SetFilter("Due Date", '<>%1', 0D); if not CustLedgEntry.FindSet() then exit(0); repeat DetailedCustLedgEntry.SetCurrentKey("Cust. Ledger Entry No."); DetailedCustLedgEntry.SetRange("Cust. Ledger Entry No.", CustLedgEntry."Entry No."); DetailedCustLedgEntry.SetRange("Document Type", DetailedCustLedgEntry."Document Type"::Payment); if DetailedCustLedgEntry.FindLast() then begin PaymentDays += DetailedCustLedgEntry."Posting Date" - CustLedgEntry."Due Date"; InvoiceCount += 1; end; until CustLedgEntry.Next() = 0; if InvoiceCount = 0 then exit(0); exit(PaymentDays / InvoiceCount); end; /// <summary> /// Rounds amount to the precision defined in General Ledger Setup. /// </summary> /// <param name="Amount">Amount to round</param> /// <returns>Rounded amount using G/L amount rounding precision</returns> procedure RoundAmount(Amount: Decimal): Decimal begin if not GLSetupLoaded then begin GeneralLedgerSetup.Get(); GLSetupLoaded := true; end; exit(Round(Amount, GeneralLedgerSetup."Amount Rounding Precision")); end; /// <summary> /// Returns the localized text for overdue amounts in aged analysis reports. /// </summary> /// <returns>Overdue label text for display in charts and reports</returns> procedure OverDueText(): Text begin exit(OverdueTxt); end; /// <summary> /// Returns the localized text for amount labels in aged analysis reports. /// </summary> /// <returns>Amount label text for display in charts and reports</returns> procedure AmountText(): Text begin exit(AmountTxt); end;}