Report 119 Customer - Sales List

Base Application, Microsoft.Sales.Reports

src/Layers/W1/BaseApp/Sales/Reports/CustomerSalesList.Report.al230 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 sales amounts and VAT registration numbers for tax reporting purposes./// </summary>using Microsoft.Foundation.Address;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;using Microsoft.Utilities;report 119 "Customer - Sales List"{    ObsoleteState = Pending;    ObsoleteReason = 'This report is obsolete and will be removed in a future version.';    ObsoleteTag = '28.0';    ApplicationArea = Basic, Suite;    Caption = 'Customer - Sales List';    PreviewMode = PrintLayout;    UsageCategory = ReportsAndAnalysis;    DataAccessIntent = ReadOnly;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Customer; Customer)        {            RequestFilterFields = "No.", "Date Filter";            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {            }            column(MinAmtLCY; MinAmtLCY)            {                AutoFormatType = 1;            }            column(TABLECAPTION__________CustFilter; TableCaption + ': ' + CustFilter)            {            }            column(Customer__No__; "No.")            {            }            column(Customer_Name; Name)            {            }            column(Customer__VAT_Registration_No__; "VAT Registration No.")            {            }            column(AmtSalesLCY; AmtSalesLCY)            {                AutoFormatType = 1;            }            column(CustAddr_2_; CustAddr[2])            {            }            column(CustAddr_3_; CustAddr[3])            {            }            column(CustAddr_4_; CustAddr[4])            {            }            column(CustAddr_5_; CustAddr[5])            {            }            column(CustAddr_6_; CustAddr[6])            {            }            column(CustAddr_7_; CustAddr[7])            {            }            column(CustAddr_8_; CustAddr[8])            {            }            column(HideAddress; HideAddress)            {            }            column(Customer___Sales_ListCaption; Customer___Sales_ListCaptionLbl)            {            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {            }            column(MinAmtLCYCaption; MinAmtLCYCaptionLbl)            {            }            column(Customer__No__Caption; FieldCaption("No."))            {            }            column(Customer_NameCaption; FieldCaption(Name))            {            }            column(Customer__VAT_Registration_No__Caption; FieldCaption("VAT Registration No."))            {            }            column(AmtSalesLCYCaption; AmtSalesLCYCaptionLbl)            {            }            column(Total_Reported_Amount_of_Sales__LCY_Caption; Total_Reported_Amount_of_Sales__LCY_CaptionLbl)            {            }            trigger OnAfterGetRecord()            var                FormatAddr: Codeunit "Format Address";            begin                AmtSalesLCY := CalculateAmtOfSaleLCY();                if AmtSalesLCY < MinAmtLCY then                    CurrReport.Skip();                if not HideAddress then                    FormatAddr.Customer(CustAddr, Customer);            end;        }    }    requestpage    {        AboutTitle = 'About Customer - Sales List';        AboutText = 'Get an overview of customer sales for a period. Use the overview to report to customs and tax authorities.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(MinAmtLCY; MinAmtLCY)                    {                        ApplicationArea = Basic, Suite;                        AutoFormatType = 1;                        AutoFormatExpression = '';                        Caption = 'Amounts (LCY) Greater Than';                        ToolTip = 'Specifies an amount so that the report will only include those customers to which you have sold more than this amount within the specified dates.';                    }                    field(HideAddress; HideAddress)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Hide Address Detail';                        ToolTip = 'Specifies that you do not want the report to show address details for each customer.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Sales/Reports/CustomerSalesList.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);    end;    var        MinAmtLCY: Decimal;        HideAddress: Boolean;        AmtSalesLCY: Decimal;        CustAddr: array[8] of Text[100];        CustFilter: Text;        Customer___Sales_ListCaptionLbl: Label 'Customer - Sales List';        CurrReport_PAGENOCaptionLbl: Label 'Page';        MinAmtLCYCaptionLbl: Label 'Amounts (LCY) greater than';        AmtSalesLCYCaptionLbl: Label 'Amount of Sales (LCY)';        Total_Reported_Amount_of_Sales__LCY_CaptionLbl: Label 'Total Reported Amount of Sales (LCY)';    local procedure CalculateAmtOfSaleLCY(): Decimal    var        CustLedgEntry: Record "Cust. Ledger Entry";        Amt: Decimal;        i: Integer;    begin        CustLedgEntry.SetCurrentKey("Document Type", "Customer No.", "Posting Date");        CustLedgEntry.SetRange("Customer No.", Customer."No.");        CustLedgEntry.SetFilter("Posting Date", Customer.GetFilter("Date Filter"));        OnCalculateAmtOfSaleLCYOnAfterSetCustLedgEntryFilters(CustLedgEntry, Customer);        for i := 1 to 2 do begin            case i of                1:                    CustLedgEntry.SetRange("Document Type", CustLedgEntry."Document Type"::Invoice);                2:                    CustLedgEntry.SetRange("Document Type", CustLedgEntry."Document Type"::"Credit Memo");            end;            CustLedgEntry.CalcSums("Sales (LCY)");            Amt := Amt + CustLedgEntry."Sales (LCY)";        end;        exit(Amt);    end;    /// <summary>    /// Initializes the report request options for the Customer Sales List report.    /// </summary>    /// <param name="MinimumAmtLCY">The minimum sales amount in LCY to include customers.</param>    /// <param name="HideAddressDetails">True to hide customer address details.</param>    procedure InitializeRequest(MinimumAmtLCY: Decimal; HideAddressDetails: Boolean)    begin        MinAmtLCY := MinimumAmtLCY;        HideAddress := HideAddressDetails;    end;    [IntegrationEvent(false, false)]    local procedure OnCalculateAmtOfSaleLCYOnAfterSetCustLedgEntryFilters(var CustLedgerEntry: Record "Cust. Ledger Entry"; Customer: Record Customer)    begin    end;}#endif