Report 99000766 Prod. Order - Picking List
src/Layers/W1/BaseApp/Manufacturing/Reports/ProdOrderPickingList.Report.al167 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.Manufacturing.Reports;using Microsoft.Inventory.Item;using Microsoft.Manufacturing.Document;report 99000766 "Prod. Order - Picking List"{ ApplicationArea = Manufacturing; Caption = 'Prod. Order - Picking List'; ToolTip = 'View a detailed list of items that must be picked for a particular production order, from which location (and bin, if the location uses bins) they must be picked, and when the items are due for production.'; UsageCategory = ReportsAndAnalysis; DefaultRenderingLayout = RDLCLayout; dataset { dataitem(Item; Item) { PrintOnlyIfDetail = true; RequestFilterFields = "No.", "Search Description", "Assembly BOM", "Inventory Posting Group", "Location Filter", "Bin Filter", "Shelf No."; column(TodayFormatted; Format(Today, 0, 4)) { } column(CompanyName; COMPANYPROPERTY.DisplayName()) { } column(ItemTableCaptionFilter; TableCaption + ': ' + ItemFilter) { } column(ItemFilter; ItemFilter) { } column(CompneedCompFilter; StrSubstNo(Text000, ComponentFilter)) { } column(ComponentFilter; ComponentFilter) { } column(No_Item; "No.") { } column(BaseUOM_Item; "Base Unit of Measure") { IncludeCaption = true; } column(ProdOrderPickingListCapt; ProdOrderPickingListCaptLbl) { } column(CurrReportPageNoCapt; CurrReportPageNoCaptLbl) { } column(ProdOrderDescCaption; ProdOrderDescCaptionLbl) { } column(ProdOrderCompDueDateCapt; ProdOrderCompDueDateCaptLbl) { } dataitem("Prod. Order Component"; "Prod. Order Component") { DataItemLink = "Item No." = field("No."), "Variant Code" = field("Variant Filter"), "Location Code" = field("Location Filter"), "Bin Code" = field("Bin Filter"); DataItemTableView = sorting("Item No.", "Variant Code", "Location Code", Status, "Due Date"); RequestFilterFields = Status, "Due Date"; column(ProdOrdNo_ProdOrderComp; "Prod. Order No.") { IncludeCaption = true; } column(Desc_ProdOrder; ProdOrder.Description) { } column(DueDate_ProdOrderComp; "Due Date") { } column(RmngQty_ProdOrderComp; "Remaining Quantity") { IncludeCaption = true; } column(Scrap_ProdOrderComp; "Scrap %") { IncludeCaption = true; } column(LoctionCode_ProdOrderComp; "Location Code") { IncludeCaption = true; } column(BinCode_ProdOrderComp; "Bin Code") { IncludeCaption = true; } column(Description_Item; Item.Description) { } trigger OnAfterGetRecord() begin if Status = Status::Finished then CurrReport.Skip(); ProdOrder.Get(Status, "Prod. Order No."); end; trigger OnPreDataItem() begin SetFilter("Remaining Quantity", '<>0'); end; } } } requestpage { AboutTitle = 'About Prod. Order - Picking List'; AboutText = 'This report lists the production orders for which an item needs to be picked. Use it to support accurate picking and ensure timely material availability.'; layout { } actions { } } rendering { layout(RDLCLayout) { Type = RDLC; LayoutFile = './Manufacturing/Reports/ProdOrderPickingList.rdlc'; Summary = 'Report layout made in the legacy RDLC format. Use an RDLC editor to modify the layout.'; } } labels { } trigger OnPreReport() begin OnBeforeOnPreReport(Item); ItemFilter := Item.GetFilters(); ComponentFilter := "Prod. Order Component".GetFilters(); end; var#pragma warning disable AA0074#pragma warning disable AA0470 Text000: Label 'Component Need : %1.';#pragma warning restore AA0470#pragma warning restore AA0074 ProdOrder: Record "Production Order"; ItemFilter: Text; ComponentFilter: Text; ProdOrderPickingListCaptLbl: Label 'Prod. Order - Picking List'; CurrReportPageNoCaptLbl: Label 'Page'; ProdOrderDescCaptionLbl: Label 'Name'; ProdOrderCompDueDateCaptLbl: Label 'Due Date'; [IntegrationEvent(false, false)] local procedure OnBeforeOnPreReport(var Item: Record Item) begin end;}