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.