Query 21 Cust. Ledg. Entry Remain. Amt., source in 29

// ------------------------------------------------------------------------------------------------
// 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;

/// <summary>
/// Calculates the sum of remaining amounts in local currency for customer ledger entries, with filters for document type, open status, and due date.
/// </summary>
query 21 "Cust. Ledg. Entry Remain. Amt."
{
    Caption = 'Cust. Ledg. Entry Remain. Amt.';
    DataAccessIntent = ReadOnly;

    elements
    {
        dataitem(Cust_Ledger_Entry; "Cust. Ledger Entry")
        {
            filter(Document_Type; "Document Type")
            {
            }
            filter(IsOpen; Open)
            {
            }
            filter(Due_Date; "Due Date")
            {
            }
            filter(Customer_No; "Customer No.")
            {
            }
            filter(Customer_Posting_Group; "Customer Posting Group")
            {
            }
            filter(Date_Filter; "Date Filter")
            {
            }
            column(Sum_Remaining_Amt_LCY; "Remaining Amt. (LCY)")
            {
                Method = Sum;
            }
        }
    }
}