Query 22 Cust. Remain. Amt. By Due Date
src/Layers/W1/BaseApp/Sales/Customer/CustRemainAmtByDueDate.Query.al35 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 customer remaining amounts grouped by due date and posting group for aging analysis./// </summary>query 22 "Cust. Remain. Amt. By Due Date"{ Caption = 'Cust. Remain. Amt. By Due Date'; elements { dataitem(Cust_Ledger_Entry; "Cust. Ledger Entry") { filter(IsOpen; Open) { } column(Due_Date; "Due Date") { } column(Customer_Posting_Group; "Customer Posting Group") { } column(Sum_Remaining_Amt_LCY; "Remaining Amt. (LCY)") { Method = Sum; } } }}