Query 9088 Top 10 Vendor Purchases

Base Application, Microsoft.Purchases.Vendor

src/Layers/W1/BaseApp/Purchases/Vendor/Top10VendorPurchases.Query.al37 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.Purchases.Vendor;using Microsoft.Purchases.Payables;query 9088 "Top 10 Vendor Purchases"{    Caption = 'Top 10 Vendor Purchases';    DataAccessIntent = ReadOnly;    OrderBy = ascending(Sum_Purchases_LCY);    TopNumberOfRows = 10;    InherentEntitlements = X;    InherentPermissions = X;    elements    {        dataitem(Vendor_Ledger_Entry; "Vendor Ledger Entry")        {            DataItemTableFilter = "Purchase (LCY)" = filter(< 0);            filter(Posting_Date; "Posting Date")            {            }            column(Vendor_No; "Vendor No.")            {            }            column(Sum_Purchases_LCY; "Purchase (LCY)")            {                Method = Sum;            }        }    }}