Query 1312 Num CustLedgEntries per Cust

Base Application, Microsoft.Sales.Receivables

src/Layers/W1/BaseApp/Sales/Receivables/NumCustLedgEntriesperCust.Query.al39 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.Sales.Receivables;using Microsoft.Sales.Customer;/// <summary>/// Counts the number of customer ledger entries per customer, with the ability to filter by open status./// </summary>query 1312 "Num CustLedgEntries per Cust"{    Caption = 'Num CustLedgEntries per Cust';    elements    {        dataitem(Cust_Ledger_Entry; "Cust. Ledger Entry")        {            column(Customer_No; "Customer No.")            {            }            column(OpenValue; Open)            {            }            dataitem(Customer; Customer)            {                DataItemLink = "No." = Cust_Ledger_Entry."Customer No.";                SqlJoinType = InnerJoin;                column(Count_)                {                    Method = Count;                }            }        }    }}