Query 21 Cust. Ledg. Entry Remain. Amt.
src/Layers/W1/BaseApp/Sales/Receivables/CustLedgEntryRemainAmt.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.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; } } }}