Query 9088 Top 10 Vendor Purchases
Source AL, 37 lines
src/Layers/W1/BaseApp/Purchases/Vendor/Top10VendorPurchases.Query.allines 9 to 24 of 37, Copyright (c) Microsoft Corporation. MIT
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")