Report 119 Customer - Sales List
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