Query 36955 G\L Entries - Balance Sheet

PowerBI Reports, Microsoft.Finance.PowerBIReports

src/Apps/W1/PowerBIReports/App/Finance/APIs/GLEntriesBalanceSheet.Query.al79 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.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;query 36955 "G\L Entries - Balance Sheet"{    Access = Internal;    QueryType = API;    AboutText = 'Provides access to general ledger entries for balance sheet accounts including assets, liabilities, and equity. Enables Power BI reports to analyze financial position, track account balances over time, and build balance sheet reports with dimensional breakdowns and source tracing.';    Caption = 'Power BI Balance Sheet G/L Entries';    APIPublisher = 'microsoft';    APIGroup = 'analytics';    ApiVersion = 'v0.5', 'v1.0';    EntityName = 'balanceSheetGeneralLedgerEntry';    EntitySetName = 'balanceSheetGeneralLedgerEntries';    DataAccessIntent = ReadOnly;    elements    {        dataitem(GLAccount; "G/L Account")        {            DataItemTableFilter = "Income/Balance" = const("Balance Sheet");            column(incomeBalance; "Income/Balance")            {            }            column(glAccountNo; "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;    begin        DateFilterText := PBIMgt.GenerateFinanceReportDateFilter();        if DateFilterText <> '' then            CurrQuery.SetFilter(postingDate, DateFilterText);    end;}