Report 101 Customer - List

Base Application, Microsoft.Sales.Reports

src/Layers/W1/BaseApp/Sales/Reports/CustomerList.Report.al212 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.// ------------------------------------------------------------------------------------------------#if not CLEAN28namespace Microsoft.Sales.Reports;/// <summary>/// Lists customers with their basic information including name, address, phone number, and contact details./// </summary>using Microsoft.Foundation.Address;using Microsoft.Sales.Customer;using Microsoft.Utilities;report 101 "Customer - List"{    ObsoleteState = Pending;    ObsoleteReason = 'This report is obsolete and will be removed in a future version.';    ObsoleteTag = '28.0';    ApplicationArea = Basic, Suite;    Caption = 'Customer List';    DefaultRenderingLayout = "CustomerList.rdlc";    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    dataset    {        dataitem(Customer; Customer)        {            RequestFilterFields = "No.", "Search Name", "Customer Posting Group";            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(Customer_TABLECAPTION__________CustFilter; TableCaption + ': ' + CustFilter)            {            }            column(CustFilter; CustFilter)            {            }            column(Customer__No__; "No.")            {            }            column(Customer__Customer_Posting_Group_; "Customer Posting Group")            {            }            column(Customer__Customer_Disc__Group_; "Customer Disc. Group")            {            }            column(Customer__Invoice_Disc__Code_; "Invoice Disc. Code")            {            }            column(Customer__Customer_Price_Group_; "Customer Price Group")            {            }            column(Customer__Fin__Charge_Terms_Code_; "Fin. Charge Terms Code")            {            }            column(Customer__Payment_Terms_Code_; "Payment Terms Code")            {            }            column(Customer__Salesperson_Code_; "Salesperson Code")            {            }            column(Customer__Currency_Code_; "Currency Code")            {            }            column(Customer__Credit_Limit__LCY__; "Credit Limit (LCY)")            {                DecimalPlaces = 0 : 0;            }            column(Customer__Balance__LCY__; "Balance (LCY)")            {            }            column(CustAddr_1_; CustAddr[1])            {            }            column(CustAddr_2_; CustAddr[2])            {            }            column(CustAddr_3_; CustAddr[3])            {            }            column(CustAddr_4_; CustAddr[4])            {            }            column(CustAddr_5_; CustAddr[5])            {            }            column(Customer_Contact; Contact)            {            }            column(Customer__Phone_No__; "Phone No.")            {            }            column(CustAddr_6_; CustAddr[6])            {            }            column(CustAddr_7_; CustAddr[7])            {            }            column(Customer___ListCaption; Customer___ListCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(Customer__No__Caption; FieldCaption("No."))            {            }            column(Customer__Customer_Posting_Group_Caption; Customer__Customer_Posting_Group_CaptionLbl)            {            }            column(Customer__Customer_Disc__Group_Caption; Customer__Customer_Disc__Group_CaptionLbl)            {            }            column(Customer__Invoice_Disc__Code_Caption; Customer__Invoice_Disc__Code_CaptionLbl)            {            }            column(Customer__Customer_Price_Group_Caption; Customer__Customer_Price_Group_CaptionLbl)            {            }            column(Customer__Fin__Charge_Terms_Code_Caption; FieldCaption("Fin. Charge Terms Code"))            {            }            column(Customer__Payment_Terms_Code_Caption; Customer__Payment_Terms_Code_CaptionLbl)            {            }            column(Customer__Salesperson_Code_Caption; FieldCaption("Salesperson Code"))            {            }            column(Customer__Currency_Code_Caption; Customer__Currency_Code_CaptionLbl)            {            }            column(Customer__Credit_Limit__LCY__Caption; FieldCaption("Credit Limit (LCY)"))            {            }            column(Customer__Balance__LCY__Caption; FieldCaption("Balance (LCY)"))            {            }            column(Customer_ContactCaption; FieldCaption(Contact))            {            }            column(Customer__Phone_No__Caption; FieldCaption("Phone No."))            {            }            column(Total__LCY_Caption; Total__LCY_CaptionLbl)            {            }            trigger OnAfterGetRecord()            begin                CalcFields("Balance (LCY)");                FormatAddr.FormatAddr(                  CustAddr, Name, "Name 2", '', Address, "Address 2",                  City, "Post Code", County, "Country/Region Code");            end;        }    }    requestpage    {        AboutTitle = 'About Customer List';        AboutText = 'Get an overview of basic information for your customers.';        SaveValues = true;        layout        {        }        actions        {        }    }    rendering    {        layout("CustomerList.rdlc")        {            Type = RDLC;            LayoutFile = './Sales/Reports/CustomerList.rdlc';        }    }    labels    {    }    trigger OnPreReport()    var        FormatDocument: Codeunit "Format Document";    begin        CustFilter := FormatDocument.GetRecordFiltersWithCaptions(Customer);    end;    var        FormatAddr: Codeunit "Format Address";        CustFilter: Text;        CustAddr: array[8] of Text[100];        Customer___ListCaptionLbl: Label 'Customer - List';        CurrReport_PAGENOCaptionLbl: Label 'Page';        Customer__Customer_Posting_Group_CaptionLbl: Label 'Customer Posting Group';        Customer__Customer_Disc__Group_CaptionLbl: Label 'Cust./Item Disc. Gr.';        Customer__Invoice_Disc__Code_CaptionLbl: Label 'Invoice Disc. Code';        Customer__Customer_Price_Group_CaptionLbl: Label 'Price Group Code';        Customer__Payment_Terms_Code_CaptionLbl: Label 'Payment Terms Code';        Customer__Currency_Code_CaptionLbl: Label 'Currency Code';        Total__LCY_CaptionLbl: Label 'Total (LCY)';}#endif