Query 58 Power BI GL Budgeted Amount
src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBIGLBudgetedAmount.Query.al45 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.Integration.PowerBI;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;query 58 "Power BI GL Budgeted Amount"{ Caption = 'Power BI GL Budgeted Amount'; elements { dataitem(G_L_Account; "G/L Account") { column(GL_Account_No; "No.") { } column(Name; Name) { } column(Account_Type; "Account Type") { ColumnFilter = Account_Type = const(Posting); } column(Debit_Credit; "Debit/Credit") { } dataitem(G_L_Budget_Entry; "G/L Budget Entry") { DataItemLink = "G/L Account No." = G_L_Account."No."; column(Amount; Amount) { } column(Date; Date) { } } } }}