Report 5700 Catalog Item Sales

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/CatalogItemSales.Report.al181 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.Inventory.Reports;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;report 5700 "Catalog Item Sales"{    AdditionalSearchTerms = 'non-inventoriable sale,special sales order';    ApplicationArea = Basic, Suite;    Caption = 'Catalog Item Sales';    ToolTip = 'View a list of item sales for each catalog item during a selected time period. It can be used to review a company''s sale of catalog items.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem("Item Ledger Entry"; "Item Ledger Entry")        {            DataItemTableView = sorting("Item No.", "Entry Type");            RequestFilterFields = "Item No.", "Location Code", "Posting Date";            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(TodayFormatted; Format(Today, 0, 4))            {            }            column(CaptionLedgFilter; TableCaption + ': ' + ItemLedgerFilter)            {            }            column(ItemLedgerFilter; ItemLedgerFilter)            {            }            column(ValueEntryInvoicedQty; -"Value Entry"."Invoiced Quantity")            {                DecimalPlaces = 0 : 5;            }            column(SalesAmtAct_ValueEntry; "Value Entry"."Sales Amount (Actual)")            {            }            column(ItemDescription; Item.Description)            {            }            column(ItemLedgerEntryItemNo; "Item No.")            {            }            column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl)            {            }            column(NonstockItemSalesCaption; NonstockItemSalesCaptionLbl)            {            }            column(ItemNoCaption; ItemNoCaptionLbl)            {            }            column(QuantityCaption; QuantityCaptionLbl)            {            }            column(AmountCaption; AmountCaptionLbl)            {            }            column(ValueEntryDocDateCaption; ValueEntryDocDateCaptionLbl)            {            }            column(ValueEntryPostingDateCaption; ValueEntryPostingDateCaptionLbl)            {            }            column(TotalSalesCaption; TotalSalesCaptionLbl)            {            }            dataitem("Value Entry"; "Value Entry")            {                DataItemLink = "Item Ledger Entry No." = field("Entry No.");                DataItemTableView = sorting("Item Ledger Entry No.");                column(ValueEntryDocumentNo; "Document No.")                {                    IncludeCaption = true;                }                column(ValueEntryDocDate; Format("Document Date"))                {                }                column(ValueEntryPostingDate; Format("Posting Date"))                {                }                column(LocCode_ValueEntry; "Location Code")                {                    IncludeCaption = true;                }                column(ItemLedrEntryPurCode; "Item Ledger Entry"."Purchasing Code")                {                    IncludeCaption = true;                }                column(DropShip_ValueEntry; "Drop Shipment")                {                    IncludeCaption = true;                }                column(InvoicedQuantity; -"Invoiced Quantity")                {                    DecimalPlaces = 0 : 5;                }                column(ValueEntryItemNo; "Item No.")                {                }                column(FormatDropShipment; Format("Drop Shipment"))                {                }                trigger OnAfterGetRecord()                begin                    if "Expected Cost" then                        CurrReport.Skip();                end;            }            trigger OnAfterGetRecord()            begin                if "Entry Type" <> "Entry Type"::Sale then begin                    SetRange("Item No.", "Item No.");                    SetRange("Entry Type", "Entry Type");                    Find('+');                    SetRange("Item No.");                    SetRange("Entry Type");                end;                if not Nonstock then                    CurrReport.Skip();                if not Item.Get("Item No.") then                    Item.Description := '';            end;        }    }    requestpage    {        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/CatalogItemSales.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        ItemLedgerFilter := "Item Ledger Entry".GetFilters();    end;    var        Item: Record Item;        ItemLedgerFilter: Text;        CurrReportPageNoCaptionLbl: Label 'Page';        NonstockItemSalesCaptionLbl: Label 'Catalog Item - Sales';        ItemNoCaptionLbl: Label 'Item No.';        QuantityCaptionLbl: Label 'Quantity';        AmountCaptionLbl: Label 'Amount';        ValueEntryDocDateCaptionLbl: Label 'Document Date';        ValueEntryPostingDateCaptionLbl: Label 'Posting Date';        TotalSalesCaptionLbl: Label 'Total Sales';}