Report 721 Inventory - Cost Variance
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';}