Table 374 G/L Acc. Budget Buffer
src/Layers/W1/BaseApp/Finance/Analysis/GLAccBudgetBuffer.Table.al236 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.Analysis;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;/// <summary>/// Temporary buffer table for G/L account budget analysis and reporting operations./// Provides structured data storage for budget calculations with dimensional filtering capabilities./// </summary>/// <remarks>/// Used by budget analysis pages and reports for temporary data processing./// Supports multi-dimensional budget filtering and aggregation operations./// Integrates with G/L Budget Entry data and dimension filtering./// </remarks>table 374 "G/L Acc. Budget Buffer"{ Caption = 'G/L Acc. Budget Buffer'; DataCaptionFields = "Code"; DrillDownPageID = "Chart of Accounts"; LookupPageID = "G/L Account List"; ReplicateData = false; DataClassification = CustomerContent; fields { /// <summary> /// G/L account code or dimension value code used for budget analysis grouping. /// </summary> field(1; "Code"; Code[20]) { Caption = 'Code'; DataClassification = SystemMetadata; NotBlank = true; } /// <summary> /// Filter for specific budget name to limit budget data analysis scope. /// </summary> field(3; "Budget Filter"; Code[10]) { Caption = 'Budget Filter'; FieldClass = FlowFilter; TableRelation = "G/L Budget Name"; } /// <summary> /// Filter for specific G/L account or account range in budget analysis. /// </summary> field(4; "G/L Account Filter"; Code[20]) { Caption = 'G/L Account Filter'; FieldClass = FlowFilter; TableRelation = "G/L Account"; ValidateTableRelation = false; } /// <summary> /// Filter for specific business unit or business unit range in budget analysis. /// </summary> field(5; "Business Unit Filter"; Code[20]) { Caption = 'Business Unit Filter'; FieldClass = FlowFilter; TableRelation = "Business Unit"; } /// <summary> /// Filter for specific global dimension 1 values in budget analysis. /// </summary> field(6; "Global Dimension 1 Filter"; Code[20]) { CaptionClass = '1,3,1'; Caption = 'Global Dimension 1 Filter'; FieldClass = FlowFilter; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1)); } /// <summary> /// Filter for specific global dimension 2 values in budget analysis. /// </summary> field(7; "Global Dimension 2 Filter"; Code[20]) { CaptionClass = '1,3,2'; Caption = 'Global Dimension 2 Filter'; FieldClass = FlowFilter; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2)); } /// <summary> /// Filter for specific budget dimension 1 values in budget analysis. /// </summary> field(8; "Budget Dimension 1 Filter"; Code[20]) { CaptionClass = GetCaptionClass(1); Caption = 'Budget Dimension 1 Filter'; FieldClass = FlowFilter; } /// <summary> /// Filter for specific budget dimension 2 values in budget analysis. /// </summary> field(9; "Budget Dimension 2 Filter"; Code[20]) { CaptionClass = GetCaptionClass(2); Caption = 'Budget Dimension 2 Filter'; FieldClass = FlowFilter; } /// <summary> /// Filter for specific budget dimension 3 values in budget analysis. /// </summary> field(10; "Budget Dimension 3 Filter"; Code[20]) { CaptionClass = GetCaptionClass(3); Caption = 'Budget Dimension 3 Filter'; FieldClass = FlowFilter; } /// <summary> /// Filter for specific budget dimension 4 values in budget analysis. /// </summary> field(11; "Budget Dimension 4 Filter"; Code[20]) { CaptionClass = GetCaptionClass(4); Caption = 'Budget Dimension 4 Filter'; FieldClass = FlowFilter; } /// <summary> /// Filter for specific date or date range in budget analysis. /// </summary> field(12; "Date Filter"; Date) { Caption = 'Date Filter'; ClosingDates = true; FieldClass = FlowFilter; } /// <summary> /// Calculated budgeted amount from G/L Budget Entry based on applied filters. /// </summary> field(13; "Budgeted Amount"; Decimal) { AutoFormatExpression = ''; AutoFormatType = 1; CalcFormula = sum("G/L Budget Entry".Amount where("Budget Name" = field("Budget Filter"), "G/L Account No." = field("G/L Account Filter"), "Business Unit Code" = field("Business Unit Filter"), "Global Dimension 1 Code" = field("Global Dimension 1 Filter"), "Global Dimension 2 Code" = field("Global Dimension 2 Filter"), "Budget Dimension 1 Code" = field("Budget Dimension 1 Filter"), "Budget Dimension 2 Code" = field("Budget Dimension 2 Filter"), "Budget Dimension 3 Code" = field("Budget Dimension 3 Filter"), "Budget Dimension 4 Code" = field("Budget Dimension 4 Filter"), Date = field("Date Filter"))); Caption = 'Budgeted Amount'; FieldClass = FlowField; } /// <summary> /// Income or balance classification of the associated G/L account. /// </summary> field(14; "Income/Balance"; Enum "G/L Account Income/Balance") { Caption = 'Income/Balance'; DataClassification = SystemMetadata; } /// <summary> /// Account category classification of the associated G/L account. /// </summary> field(15; "Account Category"; Enum "G/L Account Category") { Caption = 'Account Category'; DataClassification = SystemMetadata; } } keys { key(Key1; "Code") { Clustered = true; } } fieldgroups { } var GLBudgetName: Record "G/L Budget Name";#pragma warning disable AA0074 Text000: Label '1,6,,Budget Dimension 1 Filter'; Text001: Label '1,6,,Budget Dimension 2 Filter'; Text002: Label '1,6,,Budget Dimension 3 Filter'; Text003: Label '1,6,,Budget Dimension 4 Filter';#pragma warning restore AA0074 /// <summary> /// Retrieves caption class text for budget dimension filter fields based on budget dimension configuration. /// Returns appropriate caption class string for dynamic dimension field captioning. /// </summary> /// <param name="BudgetDimType">Budget dimension type number (1-4) to get caption class for</param> /// <returns>Caption class text for the specified budget dimension type</returns> procedure GetCaptionClass(BudgetDimType: Integer): Text[250] begin if GLBudgetName.Name <> GetFilter("Budget Filter") then GLBudgetName.Get(GetFilter("Budget Filter")); case BudgetDimType of 1: begin if GLBudgetName."Budget Dimension 1 Code" <> '' then exit('1,6,' + GLBudgetName."Budget Dimension 1 Code"); exit(Text000); end; 2: begin if GLBudgetName."Budget Dimension 2 Code" <> '' then exit('1,6,' + GLBudgetName."Budget Dimension 2 Code"); exit(Text001); end; 3: begin if GLBudgetName."Budget Dimension 3 Code" <> '' then exit('1,6,' + GLBudgetName."Budget Dimension 3 Code"); exit(Text002); end; 4: begin if GLBudgetName."Budget Dimension 4 Code" <> '' then exit('1,6,' + GLBudgetName."Budget Dimension 4 Code"); exit(Text003); end; end; end;}