Query 9151 My Vendors

Base Application, Microsoft.Purchases.Vendor

src/Layers/W1/BaseApp/Purchases/Vendor/MyVendors.Query.al45 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;query 9151 "My Vendors"{    Caption = 'My Vendors';    elements    {        dataitem(My_Vendor; "My Vendor")        {            filter(User_ID; "User ID")            {            }            column(Vendor_No; "Vendor No.")            {            }            dataitem(Vendor; Vendor)            {                DataItemLink = "No." = My_Vendor."Vendor No.";                filter(Date_Filter; "Date Filter")                {                }                column(Sum_Balance; Balance)                {                    Method = Sum;                }                column(Sum_Invoice_Amounts; "Invoice Amounts")                {                    Method = Sum;                }            }        }    }    trigger OnBeforeOpen()    begin        SetRange(User_ID, UserId);    end;}