Report 711 Inventory - Top 10 List

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/InventoryTop10List.Report.al464 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 System.Utilities;report 711 "Inventory - Top 10 List"{    ApplicationArea = Basic, Suite;    Caption = 'Inventory Top 10 List';    ToolTip = 'View information about the items with the highest or lowest sales within a selected period. You can also choose that items that are not on hand or have not been sold are not included in the report. The items are sorted by order size within the selected period. The list gives a quick overview of the items that have sold either best or worst, or the items that have the most or fewest units on inventory.';    DefaultRenderingLayout = Excel;    UsageCategory = ReportsAndAnalysis;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("No.");            RequestFilterFields = "No.", "Inventory Posting Group", "Statistics Group", "Date Filter";            trigger OnAfterGetRecord()            begin                WindowDialog.Update(1, "No.");                CalcFields("Sales (LCY)", Inventory);                if ("Sales (LCY)" = 0) and (Inventory = 0) and not PrintAlsoIfZeroReq then                    CurrReport.Skip();                TempItemAmount.Init();                TempItemAmount."Item No." := "No.";                if ShowTypeReq = ShowTypeReq::"Sales (LCY)" then begin                    TempItemAmount.Amount := "Sales (LCY)";                    TempItemAmount."Amount 2" := Inventory;                end else begin                    TempItemAmount.Amount := Inventory;                    TempItemAmount."Amount 2" := "Sales (LCY)";                end;                if ShowSortingReq = ShowSortingReq::Largest then begin                    TempItemAmount.Amount := -TempItemAmount.Amount;                    TempItemAmount."Amount 2" := -TempItemAmount."Amount 2";                end;                TempItemAmount.Insert();                if (NoOfRecordsToPrintReq = 0) or (i < NoOfRecordsToPrintReq) then                    i := i + 1                else begin                    TempItemAmount.Find('+');                    TempItemAmount.Delete();                end;                TotalItemSales += "Sales (LCY)";                TotalItemBalance += Inventory;            end;            trigger OnPreDataItem()            begin                WindowDialog.Open(SortingItemsTxt);                TempItemAmount.DeleteAll();                i := 0;            end;        }        dataitem("Integer"; "Integer")        {            DataItemTableView = sorting(Number) where(Number = filter(1 ..));            column(PrintAlsoIfZero; PrintAlsoIfZeroReq)            {            }            column(Integer_Number; Number)            {            }            column(Item__No__; Item."No.")            {                IncludeCaption = true;            }            column(Item_Description; Item.Description)            {                IncludeCaption = true;            }            column(Item__Sales__LCY__; Item."Sales (LCY)")            {                AutoFormatType = 1;                IncludeCaption = true;            }            column(Item_Inventory; Item.Inventory)            {                DecimalPlaces = 0 : 5;                IncludeCaption = true;            }            column(ItemSales; ItemSales)            {                AutoFormatType = 1;            }            column(QtyOnHand; QtyOnHand)            {                DecimalPlaces = 0 : 5;            }            column(TotalItemBalance; TotalItemBalance)            {            }            column(TotalItemSales; TotalItemSales)            {            }#if not CLEAN28            column(STRSUBSTNO_Text001_ItemDateFilter_; StrSubstNo(PeriodInfoTxt, ItemDateFilter))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(COMPANYNAME; COMPANYPROPERTY.DisplayName())            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(STRSUBSTNO_Text002_Sequence_Heading_; StrSubstNo(RankedAccordingTxt, Sequence, Heading))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(STRSUBSTNO___1___2__Item_TABLECAPTION_ItemFilter_; StrSubstNo(TableFiltersTxt, Item.TableCaption(), ItemFilter))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(ItemFilter; ItemFilter)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(STRSUBSTNO_Text003_Heading_; StrSubstNo(PortionOfTxt, Heading))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(BarText; BarText)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item__Sales__LCY___Control24; Item."Sales (LCY)")            {                AutoFormatType = 1;                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(SalesAmountPct; SalesAmountPct)            {                AutoFormatType = 1;                DecimalPlaces = 1 : 1;                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(QtyOnHandPct; QtyOnHandPct)            {                DecimalPlaces = 1 : 1;                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Inventory___Top_10_ListCaption; Inventory___Top_10_ListCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(CurrReport_PAGENOCaption; CurrReport_PAGENOCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(This_report_also_includes_items_not_on_inventory_or_that_are_not_sold_Caption; This_report_also_includes_items_not_on_inventory_or_that_are_not_sold_CaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Integer_NumberCaption; Integer_NumberCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item__No__Caption; Item.FieldCaption("No."))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item_DescriptionCaption; Item.FieldCaption(Description))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item__Sales__LCY__Caption; Item.FieldCaption("Sales (LCY)"))            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item_InventoryCaption; Item_InventoryCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(Item__Sales__LCY___Control24Caption; Item__Sales__LCY___Control24CaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(ItemSalesCaption; ItemSalesCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }            column(SalesAmountPctCaption; SalesAmountPctCaptionLbl)            {                ObsoleteState = Pending;                ObsoleteReason = 'RDLC Only layout column. To be removed along with the RDLC layout.';                ObsoleteTag = '28.0';            }#endif            trigger OnAfterGetRecord()            begin                if Number = 1 then begin                    if not TempItemAmount.Find('-') then                        CurrReport.Break();                    if ShowSortingReq = ShowSortingReq::Largest then                        MaxAmount := -TempItemAmount.Amount                    else begin                        ItemAmount2 := TempItemAmount;                        if TempItemAmount.Next(NoOfRecordsToPrintReq - 1) > 0 then;                        MaxAmount := TempItemAmount.Amount;                        TempItemAmount := ItemAmount2;                    end;                end else                    if TempItemAmount.Next() = 0 then                        CurrReport.Break();                Item.Get(TempItemAmount."Item No.");                Item.CalcFields("Sales (LCY)", Inventory);                if ShowSortingReq = ShowSortingReq::Largest then begin                    TempItemAmount.Amount := -TempItemAmount.Amount;                    TempItemAmount."Amount 2" := -TempItemAmount."Amount 2";                end;                if (MaxAmount > 0) and (TempItemAmount.Amount > 0) then                    BarText := CopyStr(PadStr('', Round(TempItemAmount.Amount / MaxAmount * 45, 1), '*'), 1, 50)                else                    BarText := '';                if ShowSortingReq = ShowSortingReq::Largest then begin                    TempItemAmount.Amount := -TempItemAmount.Amount;                    TempItemAmount."Amount 2" := -TempItemAmount."Amount 2";                end;            end;            trigger OnPreDataItem()            begin                WindowDialog.Close();                ItemSales := Item."Sales (LCY)";                QtyOnHand := Item.Inventory;            end;        }    }    requestpage    {        AboutTitle = 'About Inventory Top 10 List';        AboutText = 'Review a summary of items with the highest or lowest sales or Inventory within a selected period to assist with purchase planning. You can choose to display more than 10 Items';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(ShowSorting; ShowSortingReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show';                        OptionCaption = 'Largest,Smallest';                        ToolTip = 'Specifies if you want a report on the items that have the highest sales; select the Smallest option if you want a report on the items that have the lowest sales.';                    }                    field(ShowType; ShowTypeReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Show';                        OptionCaption = 'Sales (LCY),Inventory';                        ToolTip = 'Specifies if you want a report on item sales; select the Inventory option if you want a report on the items'' inventory.';                    }                    field(NoOfRecordsToPrint; NoOfRecordsToPrintReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Quantity';                        ToolTip = 'Specifies the number of items to be shown in the report.';                    }                    field(PrintAlsoIfZero; PrintAlsoIfZeroReq)                    {                        ApplicationArea = Basic, Suite;                        Caption = 'Include Items Not on Inventory or Not Sold';                        MultiLine = true;                        ToolTip = 'Specifies if you want items that are not on hand or have not been sold to be included in the report.';                    }                    // Used to set a report header across multiple languages                    field(RequestItemFilterHeading; ItemFilterHeading)                    {                        ApplicationArea = All;                        Caption = 'Item Filter';                        ToolTip = 'Specifies the Item Filters applied to this report.';                        Visible = false;                    }                }            }        }        actions        {        }        trigger OnOpenPage()        begin            if NoOfRecordsToPrintReq = 0 then                NoOfRecordsToPrintReq := 10;        end;        trigger OnClosePage()        begin            UpdateRequestPageFilterValues();        end;    }    rendering    {        layout(Excel)        {            Caption = 'Inventory Top 10 List Excel';            Type = Excel;            LayoutFile = './Inventory/Reports/InventoryTop10List.xlsx';            Summary = 'Built in layout for the Inventory Top 10 List Excel report.';        }#if not CLEAN28        layout(RDLC)        {            Caption = 'Inventory Top 10 List RDLC (Obsolete)';            Type = RDLC;            LayoutFile = './Inventory/Reports/InventoryTop10List.rdlc';            ObsoleteState = Pending;            ObsoleteReason = 'The RDLC layout has been replaced by an Excel layout and will be removed in a future release.';            ObsoleteTag = '28.0';            Summary = 'Built in layout for the Inventory Top 10 List RDLC (Obsolete) report.';        }#endif    }    labels    {        InventoryTop10ListLbl = 'Inventory Top 10 List';        InventoryTop10ListPrintLbl = 'Inv. Top 10 List (Print)', MaxLength = 31, Comment = 'Excel worksheet name.';        InventoryTop10ListAnalysisLbl = 'Inv. Top 10 List (Analysis)', MaxLength = 31, Comment = 'Excel worksheet name.';        DataRetrievedLbl = 'Data retrieved:';        RankLbl = 'Rank';        RankAccordingToLbl = 'Rank according to ';        TotalSalesLbl = 'Total Sales';        PercentOfTotalSalesLbl = '% of Total Sales';        IncludeNonInventoryItemsLbl = 'This report also includes items not on inventory or that are not sold.';        // About the report labels        AboutTheReportLbl = 'About the report';        EnvironmentLbl = 'Environment';        CompanyLbl = 'Company';        UserLbl = 'User';        RunOnLbl = 'Run on';        ReportNameLbl = 'Report name';        DocumentationLbl = 'Documentation';    }    trigger OnPreReport()    begin        UpdateRequestPageFilterValues();    end;    var        TempItemAmount: Record "Item Amount" temporary;        ItemAmount2: Record "Item Amount";        WindowDialog: Dialog;        ItemFilter: Text;        ItemFilterHeading: Text;#if not CLEAN28        ItemDateFilter: Text;        Sequence: Text;        Heading: Text[30];#endif        ShowSortingReq: Option Largest,Smallest;        ShowTypeReq: Option "Sales (LCY)",Inventory;        NoOfRecordsToPrintReq: Integer;        PrintAlsoIfZeroReq: Boolean;        ItemSales: Decimal;        QtyOnHand: Decimal;#if not CLEAN28        SalesAmountPct: Decimal;        QtyOnHandPct: Decimal;#endif        MaxAmount: Decimal;        BarText: Text[50];        i: Integer;        TotalItemSales: Decimal;        TotalItemBalance: Decimal;        SortingItemsTxt: Label 'Sorting items    #1##########', Comment = '%1 - progress bar';#if not CLEAN28        Text004Txt: Label 'Largest,Smallest';        Text005Txt: Label 'Sales (LCY),Inventory';        PeriodInfoTxt: Label 'Period: %1', Comment = '%1 - period name';        TableFiltersTxt: Label '%1: %2', Locked = true;        RankedAccordingTxt: Label 'Ranked according to %1 %2', Comment = '%1 - Sequence, %2 - Heading';        PortionOfTxt: Label 'Portion of %1', Comment = '%1 - heading';        Inventory___Top_10_ListCaptionLbl: Label 'Inventory - Top 10 List';        CurrReport_PAGENOCaptionLbl: Label 'Page';        This_report_also_includes_items_not_on_inventory_or_that_are_not_sold_CaptionLbl: Label 'This report also includes items not on inventory or that are not sold.';        Integer_NumberCaptionLbl: Label 'Rank';        Item_InventoryCaptionLbl: Label 'Inventory';        Item__Sales__LCY___Control24CaptionLbl: Label 'Total';        ItemSalesCaptionLbl: Label 'Total Sales';        SalesAmountPctCaptionLbl: Label '% of Total Sales';#endif    procedure InitializeRequest(NewShowSorting: Option; NewShowType: Option; NewNoOfRecordsToPrint: Integer; NewPrintAlsoIfZero: Boolean)    begin        ShowSortingReq := NewShowSorting;        ShowTypeReq := NewShowType;        NoOfRecordsToPrintReq := NewNoOfRecordsToPrint;        PrintAlsoIfZeroReq := NewPrintAlsoIfZero;    end;    // Ensures Layout Filter Headings are up to date    local procedure UpdateRequestPageFilterValues()    begin        ItemFilter := Item.GetFilters();        if ItemFilter <> '' then            ItemFilterHeading := Item.TableCaption + ': ' + ItemFilter;#if not CLEAN28        ItemDateFilter := Item.GetFilter("Date Filter");        Sequence := LowerCase(Format(SelectStr(ShowSortingReq + 1, Text004Txt)));        Heading := Format(SelectStr(ShowTypeReq + 1, Text005Txt));#endif    end;}