Query 36962 G/L Entries - Income Statement
src/Apps/W1/PowerBIReports/App/_Obsolete/Finance/APIs/GLEntriesIncomeStatement.Query.al89 lines, Copyright (c) Microsoft Corporation. MIT
#if not CLEAN26// ------------------------------------------------------------------------------------------------// 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.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;query 36962 "G/L Entries - Income Statement"{ Access = Internal; QueryType = API; AboutText = 'Provides access to G/L entries for income statement accounts including amounts, posting dates, and dimension data. This API has been replaced by the G/L Income Statement - PBI API query.'; Caption = 'Power BI Income Stmt. G/L Entries'; APIPublisher = 'microsoft'; APIGroup = 'analytics'; ApiVersion = 'v0.5', 'v1.0'; EntityName = 'incomeStatementGeneralLedgerEntry'; EntitySetName = 'incomeStatementGeneralLedgerEntries'; DataAccessIntent = ReadOnly; ObsoleteState = Pending; ObsoleteReason = 'This query has been replaced by the G/L Income Statement - PBI API query.'; ObsoleteTag = '26.0'; elements { dataitem(GLAccount; "G/L Account") { DataItemTableFilter = "Income/Balance" = const("Income Statement"); column(incomeBalance; "Income/Balance") { } column(accountNo; "No.") { } dataitem(GLEntry; "G/L Entry") { DataItemLink = "G/L Account No." = GLAccount."No."; SqlJoinType = InnerJoin; column(postingDate; "Posting Date") { } column(amount; Amount) { } column(dimensionSetID; "Dimension Set ID") { } column(sourceCode; "Source Code") { } column(entryNo; "Entry No.") { } column(systemModifiedAt; SystemModifiedAt) { } column(description; Description) { } column(sourceType; "Source Type") { } column(sourceNo; "Source No.") { } } } } trigger OnBeforeOpen() var PBIMgt: Codeunit "Finance Filter Helper"; DateFilterText: Text; SourceCodeText: Text; begin DateFilterText := PBIMgt.GenerateFinanceReportDateFilter(); if DateFilterText <> '' then CurrQuery.SetFilter(postingDate, DateFilterText); SourceCodeText := PBIMgt.GenerateFinanceReportSourceCodeFilter(); if SourceCodeText <> '' then CurrQuery.SetFilter(sourceCode, '<>%1', SourceCodeText); end;}#endif