Query 22 Cust. Remain. Amt. By Due Date

App
Base Application
Namespace
Microsoft.Sales.Receivables
Versions
17-28

Versions171819202122232425262728

Source29

Source in 29

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