Account Budget Overview Page

Account Budget Overview Page

Page ID: 10008094
Purpose: Provides a comprehensive view of General Ledger accounts with budget comparison functionality

Key Features

Budget vs. Actual Analysis

Compare budgeted amounts with actual net changes to identify variances and performance gaps.

Hierarchical Display

Accounts are displayed with proper indentation based on account structure, making it easy to understand the relationship between parent and child accounts.

Real-time Calculations

Automatically calculates differences between budget and actual amounts, providing immediate insight into performance.

Filtered View

Only shows accounts with activity (net changes, budget amounts, or balances) for improved focus and performance.

Page Layout

The page displays the following information for each G/L Account:

Field

Description

Notes

No.

General Ledger account number

Bold for non-posting accounts

Name

Account name with hierarchical indentation

Shows account structure

Account Type

Type of account (Posting, Heading, etc.)

Determines formatting

Net Change

Actual movements in the account

Blank zeros hidden

Budgeted Amount

Planned/budgeted amount for the account

From budget setup

Balance

Current account balance

Blank zeros hidden

Difference

Calculated variance (Budgeted Amount - Net Change)

Auto-calculated

Totaling

Account totaling range

For heading accounts

Visual Formatting

Bold Styling

Bold styling is applied to non-posting accounts (headings, totals) to distinguish them from posting accounts.

Indentation

Indentation reflects the account hierarchy structure, making it easy to understand the chart of accounts organization.

Blank Zero Handling

Blank zeros are hidden for cleaner display, focusing attention on accounts with actual values.

Technical Implementation

Data Loading

The page uses an efficient loading mechanism that:

  • Marks accounts with net changes, budget amounts, or balances

  • Applies municipal dimension filtering automatically

  • Uses MarkedOnly to display only relevant accounts

Performance Optimization

  • Auto-calculated fields for real-time budget calculations

  • Proper indexing through sorting on Income/Balance classification

  • Marked records to improve performance by showing only relevant accounts

Dimension Support

Full support for Global Dimensions 1 and 2, enabling:

  • Department-based analysis

  • Project-based filtering

  • Multi-dimensional reporting capabilities

User Interface Elements

Field Visibility

Some fields are hidden by default but can be made visible:

  • Income/Balance classification

  • Global Dimension codes

  • Various posting group fields

  • Balance at Date

Style Expressions

Dynamic styling based on account type:

  • NoStyleExpr: Controls number field styling

  • NameStyleExpr: Controls name field styling

  • Both based on whether account is a posting account

Editable Status

The repeater control is set to non-editable, making this a read-only analysis view that prevents accidental data modification.