Report 99000766 Prod. Order - Picking List

Base Application, Microsoft.Manufacturing.Reports

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;}