Report 7322 Inventory Put-away List
src/Layers/W1/BaseApp/Warehouse/Reports/InventoryPutawayList.Report.al209 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.Warehouse.Reports;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using Microsoft.Purchases.Document;using Microsoft.Purchases.Vendor;report 7322 "Inventory Put-away List"{ AccessByPermission = TableData Location = R; ApplicationArea = Warehouse; Caption = 'Inventory Put-away List'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Item; Item) { PrintOnlyIfDetail = true; RequestFilterFields = "No.", "Search Description", "Assembly BOM", "Inventory Posting Group", "Shelf No.", "Bin Filter"; column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(TodayFormatted; Format(Today, 0, 4)) { } column(ItemFilter; ItemFilter) { } column(PurchLineFilter; PurchLineFilter) { } column(GroupTotal; GroupTotal) { } column(ItemTableCaption; TableCaption + ': ' + ItemFilter) { } column(PurchOrderLineFilter; StrSubstNo(Text000, PurchLineFilter)) { } column(ShelfNo_Item; "Shelf No.") { IncludeCaption = true; } column(No_Item; "No.") { } column(Description_Item; Description) { } column(BaseUnitofMeasure_Item; "Base Unit of Measure") { IncludeCaption = true; } column(InventoryPutawayListCptn; InventoryPutawayListCptnLbl) { } column(CurrReportPageNoCaption; CurrReportPageNoCaptionLbl) { } column(VendorNameCaption; VendorNameCaptionLbl) { } column(PurchLineExpRcptDateCptn; PurchLineExpRcptDateCptnLbl) { } dataitem("Purchase Line"; "Purchase Line") { DataItemLink = "No." = field("No."), "Variant Code" = field("Variant Filter"), "Location Code" = field("Location Filter"), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Bin Code" = field("Bin Filter"); DataItemTableView = sorting("Document Type", Type, "No.", "Variant Code", "Drop Shipment", "Location Code", "Expected Receipt Date") where(Type = const(Item), "Document Type" = const(Order), "Qty. to Receive" = filter(<> 0)); RequestFilterFields = "Expected Receipt Date", "Location Code"; RequestFilterHeading = 'Purchase Order Line'; column(UOMCode_PurchLine; "Unit of Measure Code") { IncludeCaption = true; } column(QtytoReceive_PurchLine; "Qty. to Receive") { IncludeCaption = true; } column(ReservedQtyBase_PurchLine; "Reserved Qty. (Base)") { IncludeCaption = true; } column(QtytoRecvBase_PurchLine; "Qty. to Receive (Base)") { IncludeCaption = true; } column(ExpRcptDate_PurchLine; Format("Expected Receipt Date")) { } column(BinCode_PurchLine; "Bin Code") { IncludeCaption = true; } column(LocationCode_PurchLine; "Location Code") { IncludeCaption = true; } column(VariantCode_PurchLine; "Variant Code") { IncludeCaption = true; } column(VendorName; Vendor.Name) { } column(DocumentNo_PurchLine; "Document No.") { IncludeCaption = true; } column(ItemVariantDescription; ItemVariant.Description) { } column(CurrReportTotalsCausedBy; TotalsCausedBy) { } column(BinCodeFieldNo_PurchLine; FieldNo("Bin Code")) { } column(No_PurchLine; "No.") { } trigger OnAfterGetRecord() begin Vendor.Get("Buy-from Vendor No."); CalcFields("Reserved Qty. (Base)"); if "Variant Code" <> '' then ItemVariant.Get("No.", "Variant Code") else ItemVariant.Description := Item.Description; end; } } } requestpage { SaveValues = true; layout { area(content) { group(Options) { Caption = 'Options'; field(GroupTotal; GroupTotal) { ApplicationArea = Warehouse; Caption = 'Print group totals'; ToolTip = 'Specifies if you would like the group totals to be printed on the report.'; } } } } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Warehouse/Reports/InventoryPutawayList.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(); PurchLineFilter := "Purchase Line".GetFilters(); end; var Vendor: Record Vendor; ItemVariant: Record "Item Variant"; ItemFilter: Text; PurchLineFilter: Text; GroupTotal: Boolean; TotalsCausedBy: Integer;#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Purchase Order Line: %1';#pragma warning restore AA0470#pragma warning restore AA0074 InventoryPutawayListCptnLbl: Label 'Inventory Put-away List'; CurrReportPageNoCaptionLbl: Label 'Page'; VendorNameCaptionLbl: Label 'Vendor'; PurchLineExpRcptDateCptnLbl: Label 'Expected Receipt Date';}