Report 716 Inventory Cost and Price List

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/InventoryCostandPriceList.Report.al257 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.Finance.GeneralLedger.Setup;using Microsoft.Inventory.Costing;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;report 716 "Inventory Cost and Price List"{    ApplicationArea = Basic, Suite;    Caption = 'Inventory Cost and Price List';    ToolTip = 'View, print, or save a list of your items and their price and cost information. The report specifies direct unit cost, last direct cost, unit price, profit percentage, and profit.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Item; Item)        {            RequestFilterFields = "No.", "Location Filter", "Variant Filter", "Search Description", "Assembly BOM", "Inventory Posting Group";            column(TodayFormatted; Format(Today, 0, 4))            {            }            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(ItemFilterCopyCaption; TableCaption + ': ' + ItemFilter)            {            }            column(ItemFilter; ItemFilter)            {            }            column(InventPostingGr_Item; "Inventory Posting Group")            {            }            column(No_Item; "No.")            {                IncludeCaption = true;            }            column(Desc_Item; Description)            {                IncludeCaption = true;            }            column(AssemblyBOM_Item; Format("Assembly BOM"))            {            }            column(BaseUOM_Item; "Base Unit of Measure")            {                IncludeCaption = true;            }            column(AverageCost; AverageCost)            {                AutoFormatType = 1;            }            column(StandardCost_Item; "Standard Cost")            {                IncludeCaption = true;            }            column(LastDirectCost_Item; "Last Direct Cost")            {                IncludeCaption = true;            }            column(UnitPrice_Item; "Unit Price")            {                IncludeCaption = true;            }            column(Profit_Item; "Profit %")            {                DecimalPlaces = 1 : 1;                IncludeCaption = true;            }            column(UnitPriceUnitCost_Item; "Unit Price" - "Unit Cost")            {            }            column(UseStockkeepingUnitBody; UseStockkeepingUnitReq)            {            }            column(LocationFilter_Item; "Location Filter")            {            }            column(VariantFilter_Item; "Variant Filter")            {            }            column(InvCostAndPriceListCaption; InvCostAndPriceListCaptionLbl)            {            }            column(PageNoCaption; PageNoCaptionLbl)            {            }            column(BOMCaption; BOMCaptionLbl)            {            }            column(AvgCostCaption; AvgCostCaptionLbl)            {            }            column(ProfitCaption; ProfitCaptionLbl)            {            }            column(LastDirCostCaption; LastDirCostCaptionLbl)            {            }            column(LocationCodeCaption; LocationCodeCaptionLbl)            {            }            column(VariantCodeCaption; VariantCodeCaptionLbl)            {            }            dataitem("Stockkeeping Unit"; "Stockkeeping Unit")            {                DataItemLink = "Item No." = field("No."), "Location Code" = field("Location Filter"), "Variant Code" = field("Variant Filter");                DataItemTableView = sorting("Item No.", "Location Code", "Variant Code");                column(ItemUnitPriceUnitCostDiff; Item."Unit Price" - Item."Unit Cost")                {                }                column(LastDirCost_StockKeepingUnit; "Last Direct Cost")                {                }                column(StandardCost_StockKeepingUnit; "Standard Cost")                {                }                column(AverageCost_StockKeepingUnit; AverageCost)                {                    AutoFormatType = 1;                }                column(ItemBaseUOM; Item."Base Unit of Measure")                {                }                column(ItemAssemblyBOM; Format(Item."Assembly BOM"))                {                }                column(LocationCode_StockKeepingUnit; "Location Code")                {                }                column(VariantCode_StockKeepingUnit; "Variant Code")                {                }                column(UseStockkeepingUnit; UseStockkeepingUnitReq)                {                }                column(SKUPrintLoop; SKUPrintLoop)                {                }                trigger OnAfterGetRecord()                var                    Item2: Record Item;                begin                    SKUPrintLoop := SKUPrintLoop + 1;                    if Item2.Get("Item No.") then begin                        Item2.SetFilter("Location Filter", "Location Code");                        Item2.SetFilter("Variant Filter", "Variant Code");                        ItemCostManagement.CalculateAverageCost(Item2, AverageCost, AverageCostACY);                        AverageCost := Round(AverageCost, GeneralLedgerSetup."Unit-Amount Rounding Precision");                    end;                end;                trigger OnPreDataItem()                begin                    if not UseStockkeepingUnitReq then                        CurrReport.Break();                    SKUPrintLoop := 0;                end;            }            trigger OnAfterGetRecord()            begin                ItemCostManagement.CalculateAverageCost(Item, AverageCost, AverageCostACY);                AverageCost := Round(AverageCost, GeneralLedgerSetup."Unit-Amount Rounding Precision");            end;        }    }    requestpage    {        AboutTitle = 'About Inventory Cost and Price List';        AboutText = 'Analyze and manage your inventory costs and pricing strategies.';        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(UseStockkeepingUnit; UseStockkeepingUnitReq)                    {                        ApplicationArea = Warehouse;                        Caption = 'Use Stockkeeping Unit';                        ToolTip = 'Specifies if you want the report to be based on stockkeeping units rather than items.';                    }                }            }        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/InventoryCostandPriceList.rdlc';            Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.';        }    }    labels    {    }    trigger OnPreReport()    begin        ItemFilter := Item.GetFilters();        GetGLSetup();    end;    var        GeneralLedgerSetup: Record "General Ledger Setup";        ItemCostManagement: Codeunit ItemCostManagement;        ItemFilter: Text;        AverageCost: Decimal;        AverageCostACY: Decimal;        GLSetupRead: Boolean;        UseStockkeepingUnitReq: Boolean;        SKUPrintLoop: Integer;        InvCostAndPriceListCaptionLbl: Label 'Inventory Cost and Price List';        PageNoCaptionLbl: Label 'Page';        BOMCaptionLbl: Label 'BOM';        AvgCostCaptionLbl: Label 'Average Cost';        ProfitCaptionLbl: Label 'Profit';        LastDirCostCaptionLbl: Label 'Last Direct Cost';        LocationCodeCaptionLbl: Label 'Location Code';        VariantCodeCaptionLbl: Label 'Variant Code';    local procedure GetGLSetup()    begin        if not GLSetupRead then            GeneralLedgerSetup.Get();        GLSetupRead := true;    end;    procedure InitializeRequest(NewUseStockkeepingUnit: Boolean)    begin        UseStockkeepingUnitReq := NewUseStockkeepingUnit;    end;}