Query 36957 Customer Ledger Entries
src/Apps/W1/PowerBIReports/App/Finance/APIs/CustomerLedgerEntries.Query.al116 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.PowerBIReports;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;query 36957 "Customer Ledger Entries"{ Access = Internal; QueryType = API; AboutText = 'Provides access to customer ledger entries with detailed entry information including due dates, amounts, payment terms, and application data. Enables Power BI reports to analyze accounts receivable aging, customer payment performance, and cash flow forecasting for receivables management dashboards.'; Caption = 'Power BI Customer Ledger Entries'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'customerLedgerEntry'; EntitySetName = 'customerLedgerEntries'; DataAccessIntent = ReadOnly; elements { dataitem(CustomerLedgerEntry; "Cust. Ledger Entry") { column(cleEntryNo; "Entry No.") { } column(cleDueDate; "Due Date") { } column(cleOpen; Open) { } column(clePostingDate; "Posting Date") { } column(cleDocumentDate; "Document Date") { } column(cleDimensionSetID; "Dimension Set ID") { } column(cleClosedAtDate; "Closed at Date") { } column(cleReasonCode; "Reason Code") { } dataitem(DetailedCustLedgEntry; "Detailed Cust. Ledg. Entry") { DataItemLink = "Cust. Ledger Entry No." = CustomerLedgerEntry."Entry No."; column(dcleEntryNo; "Entry No.") { } column(dclePostingDate; "Posting Date") { } column(dcleLedgerEntryAmount; "Ledger Entry Amount") { } column(dcleEntryType; "Entry Type") { } column(dcleDocumentType; "Document Type") { } column(dcleDocumentNo; "Document No.") { } column(dcleInitialEntryDueDate; "Initial Entry Due Date") { } column(dcleAmountLCY; "Amount (LCY)") { } column(dcleCustomerNo; "Customer No.") { } column(dcleApplicationNo; "Application No.") { } column(dcleAppliedCustLedgerEntryNo; "Applied Cust. Ledger Entry No.") { } dataitem(SalesInvoiceHeader; "Sales Invoice Header") { DataItemLink = "No." = DetailedCustLedgEntry."Document No."; SqlJoinType = LeftOuterJoin; column(salesInvHeaderDocumentNo; "No.") { } column(salesInvHeaderPaymentTermsCode; "Payment Terms Code") { } column(salesInvHeaderPmtDiscountDate; "Pmt. Discount Date") { } } } } } trigger OnBeforeOpen() var PBIMgt: Codeunit "Finance Filter Helper"; DateFilterText: Text; begin DateFilterText := PBIMgt.GenerateCLEReportDateFilter(); if DateFilterText <> '' then CurrQuery.SetFilter(clePostingDate, DateFilterText); end;}