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