Report 109 Customer - Summary Aging Simp.

Base Application, Microsoft.Sales.Reports

src/Layers/W1/BaseApp/Sales/Reports/CustomerSummaryAgingSimp.Report.al283 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.Sales.Reports;/// <summary>/// Generates a simplified aging summary showing customer balances in predefined 30-day periods./// </summary>using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using Microsoft.Utilities;report 109 "Customer - Summary Aging Simp."{    AdditionalSearchTerms = 'customer balance simplify,payment due simplify';    ApplicationArea = Suite;    Caption = 'Customer - Summary Aging Simp.';    ToolTip = 'View, print, or save a summary of each customer''s total payments due, divided into three time periods. The report can be used to decide when to issue reminders, to evaluate a customer''s creditworthiness, or to prepare liquidity analyses.';    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Customer; Customer)        {            RequestFilterFields = "No.", "Search Name", "Customer Posting Group", "Statistics Group", "Payment Terms Code";            column(STRSUBSTNO_Text001_FORMAT_StartDate__; StrSubstNo(Text001, Format(StartDate)))            {            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(Customer_TABLECAPTION__________CustFilter; TableCaption + ': ' + CustFilter)            {            }            column(CustFilter; CustFilter)            {            }            column(CustBalanceDueLCY_5_; CustBalanceDueLCY[5])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_4_; CustBalanceDueLCY[4])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_3_; CustBalanceDueLCY[3])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_2_; CustBalanceDueLCY[2])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_1_; CustBalanceDueLCY[1])            {                AutoFormatType = 1;            }            column(Customer__No__; "No.")            {            }            column(Customer_Name; Name)            {            }            column(CustBalanceDueLCY_5__Control25; CustBalanceDueLCY[5])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_4__Control26; CustBalanceDueLCY[4])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_3__Control27; CustBalanceDueLCY[3])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_2__Control28; CustBalanceDueLCY[2])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_1__Control29; CustBalanceDueLCY[1])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_5__Control37; CustBalanceDueLCY[5])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_4__Control38; CustBalanceDueLCY[4])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_3__Control39; CustBalanceDueLCY[3])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_2__Control40; CustBalanceDueLCY[2])            {                AutoFormatType = 1;            }            column(CustBalanceDueLCY_1__Control41; CustBalanceDueLCY[1])            {                AutoFormatType = 1;            }            column(Customer___Summary_Aging_Simp_Caption; Customer___Summary_Aging_Simp_CaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(All_amounts_are_in_LCYCaption; All_amounts_are_in_LCYCaptionLbl)            {            }            column(Customer__No__Caption; FieldCaption("No."))            {            }            column(Customer_NameCaption; FieldCaption(Name))            {            }            column(CustBalanceDueLCY_5__Control25Caption; CustBalanceDueLCY_5__Control25CaptionLbl)            {            }            column(CustBalanceDueLCY_4__Control26Caption; CustBalanceDueLCY_4__Control26CaptionLbl)            {            }            column(CustBalanceDueLCY_3__Control27Caption; CustBalanceDueLCY_3__Control27CaptionLbl)            {            }            column(CustBalanceDueLCY_2__Control28Caption; CustBalanceDueLCY_2__Control28CaptionLbl)            {            }            column(CustBalanceDueLCY_1__Control29Caption; CustBalanceDueLCY_1__Control29CaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            trigger OnAfterGetRecord()            var                FilteredCustomer: Record Customer;                ShouldSkipCustomer: Boolean;            begin                FilteredCustomer.CopyFilters(Customer);                FilteredCustomer.SetFilter("Date Filter", '..%1', StartDate);                FilteredCustomer.SetRange("No.", "No.");                ShouldSkipCustomer := FilteredCustomer.IsEmpty();                OnCustomerOnAfterGetRecordOnAfterCalcShouldSkipCustomer(Customer, FilteredCustomer, DtldCustLedgEntry, CustBalanceDueLCY, PrintCust, ShouldSkipCustomer);                if ShouldSkipCustomer then                    CurrReport.Skip();                PrintCust := false;                for i := 1 to 5 do begin                    DtldCustLedgEntry.SetCurrentKey("Customer No.", "Initial Entry Due Date", "Posting Date");                    DtldCustLedgEntry.SetRange("Customer No.", "No.");                    DtldCustLedgEntry.SetRange("Posting Date", 0D, StartDate);                    DtldCustLedgEntry.SetRange("Initial Entry Due Date", PeriodStartDate[i], PeriodStartDate[i + 1] - 1);                    OnAfterGetRecordOnAfterDtldCustLedgEntrySetFilters(DtldCustLedgEntry);                    DtldCustLedgEntry.CalcSums("Amount (LCY)");                    CustBalanceDueLCY[i] := DtldCustLedgEntry."Amount (LCY)";                    if CustBalanceDueLCY[i] <> 0 then                        PrintCust := true;                end;                if not PrintCust then                    CurrReport.Skip();            end;            trigger OnPreDataItem()            begin                Clear(CustBalanceDueLCY);            end;        }    }    requestpage    {        AboutTitle = 'About Customer - Summary Aging Simp.';        AboutText = 'This is a legacy version of an accounts receivables aging report. We recommend you use the Aged Accounts Receivables Excel report instead.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(StartingDate; StartDate)                    {                        ApplicationArea = Suite;                        Caption = 'Starting Date';                        ToolTip = 'Specifies the date from which the report or batch job processes information.';                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if StartDate = 0D then                StartDate := WorkDate();        end;    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Sales/Reports/CustomerSummaryAgingSimp.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        CustFilter := FormatDocument.GetRecordFiltersWithCaptions(Customer);        PeriodStartDate[5] := StartDate;        PeriodStartDate[6] := DMY2Date(31, 12, 9999);        for i := 4 downto 2 do            PeriodStartDate[i] := CalcDate('<-30D>', PeriodStartDate[i + 1]);    end;    var        DtldCustLedgEntry: Record "Detailed Cust. Ledg. Entry";        StartDate: Date;        PeriodStartDate: array[6] of Date;        CustBalanceDueLCY: array[5] of Decimal;        PrintCust: Boolean;        i: Integer;#pragma warning disable AA0074#pragma warning disable AA0470        Text001: Label 'As of %1';#pragma warning restore AA0470#pragma warning restore AA0074        Customer___Summary_Aging_Simp_CaptionLbl: Label 'Customer - Summary Aging Simp.';        CurrReport_PAGENOCaptionLbl: Label 'Page';        All_amounts_are_in_LCYCaptionLbl: Label 'All amounts are in LCY';        CustBalanceDueLCY_5__Control25CaptionLbl: Label 'Not Due';        CustBalanceDueLCY_4__Control26CaptionLbl: Label '0-30 days';        CustBalanceDueLCY_3__Control27CaptionLbl: Label '31-60 days';        CustBalanceDueLCY_2__Control28CaptionLbl: Label '61-90 days';        CustBalanceDueLCY_1__Control29CaptionLbl: Label 'Over 90 days';        TotalCaptionLbl: Label 'Total';    protected var        CustFilter: Text;    /// <summary>    /// Initializes the report request options for the Customer Summary Aging Simplified report.    /// </summary>    /// <param name="StartingDate">The starting date for the aging calculation.</param>    procedure InitializeRequest(StartingDate: Date)    begin        StartDate := StartingDate;    end;    [IntegrationEvent(false, false)]    local procedure OnAfterGetRecordOnAfterDtldCustLedgEntrySetFilters(var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry")    begin    end;    [IntegrationEvent(false, false)]    local procedure OnCustomerOnAfterGetRecordOnAfterCalcShouldSkipCustomer(Customer: Record Customer; var FilteredCustomer: Record Customer; var DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var CustBalanceDueLCY: array[5] of Decimal; var PrintCust: Boolean; var ShouldSkipCustomer: Boolean)    begin    end;}