Query 5402 Top-10 Prod. Orders - by Cost

Base Application, Microsoft.Manufacturing.Document

src/Layers/W1/BaseApp/Manufacturing/Document/Top10ProdOrdersbyCost.Query.al41 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.Document;using Microsoft.Inventory.Item;query 5402 "Top-10 Prod. Orders - by Cost"{    Caption = 'Top-10 Prod. Orders - by Cost';    OrderBy = descending(Cost_of_Open_Production_Orders);    TopNumberOfRows = 10;    elements    {        dataitem(Prod_Order_Line; "Prod. Order Line")        {            DataItemTableFilter = Status = filter(Planned | "Firm Planned" | Released);            column(Item_No; "Item No.")            {            }            column(Status; Status)            {            }            column(Sum_Remaining_Quantity; "Remaining Quantity")            {                Method = Sum;            }            dataitem(Item; Item)            {                DataItemLink = "No." = Prod_Order_Line."Item No.";                column(Cost_of_Open_Production_Orders; "Cost of Open Production Orders")                {                }            }        }    }}