Query 36962 G/L Entries - Income Statement

PowerBI Reports, Microsoft.Finance.PowerBIReports

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