Report 721 Inventory - Cost Variance

Base Application, Microsoft.Inventory.Reports

src/Layers/W1/BaseApp/Inventory/Reports/InventoryCostVariance.Report.al205 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 721 "Inventory - Cost Variance"{    ApplicationArea = Basic, Suite;    Caption = 'Inventory - Cost Variance';    ToolTip = 'View information about selected items, unit of measure, standard cost, and costing method, as well as additional information about item entries: unit amount, direct unit cost, unit cost variance (the difference between the unit amount and unit cost), invoiced quantity, and total variance amount (quantity * unit cost variance). The report can be used primarily if you have chosen the Standard costing method on the item card.';    UsageCategory = ReportsAndAnalysis;    DefaultRenderingLayout = RDLCLayout;    dataset    {        dataitem(Item; Item)        {            DataItemTableView = sorting("No.");            PrintOnlyIfDetail = true;            RequestFilterFields = "No.", "Costing Method", "Location Filter";            column(CompanyName; COMPANYPROPERTY.DisplayName())            {            }            column(TableCaptionItemFilter; TableCaption + ': ' + ItemFilter)            {            }            column(ItemFilter; ItemFilter)            {            }            column(ValueEntryItemLedgFilter_Item; "Value Entry".TableCaption + ': ' + ItemLedgEntryFilter)            {            }            column(ItemLedgEntryFilter; ItemLedgEntryFilter)            {            }            column(ItemNo_Item; "No.")            {            }            column(Comment_Item; Description)            {            }            column(StandardCost_Item; "Standard Cost")            {                IncludeCaption = true;            }            column(BaseUOM_Item; "Base Unit of Measure")            {                IncludeCaption = true;            }            column(CostingMethod_Item; "Costing Method")            {                IncludeCaption = true;            }            column(InvoicedQty_Item; "Value Entry"."Invoiced Quantity")            {                DecimalPlaces = 0 : 5;            }            column(Variance; Variance)            {                AutoFormatType = 1;            }            column(InvCostVarianceCaption; InvCostVarianceCaptionLbl)            {            }            column(CurrReportPAGENOCaption; CurrReportPAGENOCaptionLbl)            {            }            column(UnitAmountCaption; UnitAmountCaptionLbl)            {            }            column(CostperUnitCaption; CostperUnitCaptionLbl)            {            }            column(UnitCostVarianceCaption; UnitCostVarianceCaptionLbl)            {            }            column(TotalVarianceAmtCaption; TotalVarianceAmtCaptionLbl)            {            }            column(ItemLedEntryPostDtCaption; ItemLedEntryPostDtCaptionLbl)            {            }            column(TotalCaption; TotalCaptionLbl)            {            }            dataitem("Item Ledger Entry"; "Item Ledger Entry")            {                DataItemLink = "Item No." = field("No."), "Variant Code" = field("Variant Filter"), "Location Code" = field("Location Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter");                DataItemTableView = sorting("Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date", "Entry No.") where("Entry Type" = filter(Purchase | "Positive Adjmt."));                PrintOnlyIfDetail = true;                RequestFilterFields = "Posting Date", "Source Type", "Source No.";                dataitem("Value Entry"; "Value Entry")                {                    DataItemLink = "Item Ledger Entry No." = field("Entry No."), "Variant Code" = field("Variant Code"), "Location Code" = field("Location Code"), "Global Dimension 1 Code" = field("Global Dimension 1 Code"), "Global Dimension 2 Code" = field("Global Dimension 2 Code");                    DataItemTableView = sorting("Item Ledger Entry No.") where("Expected Cost" = const(false));                    column(No_ItemLedgerEntry; "Item Ledger Entry"."Entry No.")                    {                        IncludeCaption = true;                    }                    column(InvoicedQty_ValueEntry; "Invoiced Quantity")                    {                        IncludeCaption = true;                    }                    column(UnitAmtCostPerUnit_ValueEntry; UnitAmount - "Cost per Unit")                    {                        AutoFormatType = 1;                    }                    column(CostPerUnit_ValueEntry; "Cost per Unit")                    {                    }                    column(UnitAmount; UnitAmount)                    {                        AutoFormatType = 2;                    }                    column(DocNo_ItemLedgerEntry; "Document No.")                    {                        IncludeCaption = true;                    }                    column(EntryType_ItemLedgerEntry; "Item Ledger Entry"."Entry Type")                    {                        IncludeCaption = true;                    }                    column(PostDate_ItemLedgerEntry; Format("Item Ledger Entry"."Posting Date"))                    {                    }                    column(SourceNo_ValueEntry; "Source No.")                    {                        IncludeCaption = true;                    }                    column(ItemLedgEntryNo_ValueEntry; "Item Ledger Entry No.")                    {                    }                    trigger OnAfterGetRecord()                    begin                        UnitAmount := "Cost per Unit" * "Invoiced Quantity";                        if ("Item Charge No." <> '') and "Item Ledger Entry".Positive then                            UnitAmount := "Cost Amount (Actual)";                        Variance := 0;                        if "Entry Type" = "Entry Type"::Variance then                            Variance := "Cost Amount (Actual)";                        if "Invoiced Quantity" <> 0 then                            UnitAmount := UnitAmount / "Invoiced Quantity";                    end;                }            }        }    }    requestpage    {        layout        {        }        actions        {        }    }    rendering    {        layout(RDLCLayout)        {            Type = RDLC;            LayoutFile = './Inventory/Reports/InventoryCostVariance.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();        ItemLedgEntryFilter := "Value Entry".GetFilters();    end;    var        ItemFilter: Text;        ItemLedgEntryFilter: Text;        UnitAmount: Decimal;        Variance: Decimal;        InvCostVarianceCaptionLbl: Label 'Inventory - Cost Variance';        CurrReportPAGENOCaptionLbl: Label 'Page';        UnitAmountCaptionLbl: Label 'Unit Amount';        CostperUnitCaptionLbl: Label 'Cost per Unit';        UnitCostVarianceCaptionLbl: Label 'Unit Cost Variance';        TotalVarianceAmtCaptionLbl: Label 'Total Variance Amount';        ItemLedEntryPostDtCaptionLbl: Label 'Posting Date';        TotalCaptionLbl: Label 'Total';}