Query 33 Recon. Cust. Posting Gr. Sum
src/Layers/W1/BaseApp/Finance/GeneralLedger/Reports/ReconCustPostingGrSum.Query.al60 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.Finance.GeneralLedger.Reports;using Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;/// <summary>/// Aggregates Detailed Cust. Ledger Entry amounts in a single SQL round-trip by JOINing to Customer/// for entries with a blank "Posting Group" (legacy/upgraded data). Used by report 33 "Reconcile/// Cust. and Vend. Accs" to attribute historical detail entries to the customer's current master/// "Customer Posting Group" without iterating customers in AL./// </summary>query 33 "Recon. Cust. Posting Gr. Sum"{ Caption = 'Reconcile Customer Posting Group Sum'; QueryType = Normal; DataAccessIntent = ReadOnly; Access = Internal; elements { dataitem(DtldCustLedgEntry; "Detailed Cust. Ledg. Entry") { column(EntryType; "Entry Type") { } filter(PostingDate; "Posting Date") { } filter(PostingGroup; "Posting Group") { } column(SumAmountLCY; "Amount (LCY)") { Method = Sum; } column(SumCreditAmountLCY; "Credit Amount (LCY)") { Method = Sum; } column(SumDebitAmountLCY; "Debit Amount (LCY)") { Method = Sum; } dataitem(Customer; Customer) { DataItemLink = "No." = DtldCustLedgEntry."Customer No."; SqlJoinType = InnerJoin; filter(CustomerPostingGroup; "Customer Posting Group") { } } } }}