Contact Us
Index
Version 5.0
Version 5.1 Version 5.2 Version 5.3 Version 5.4 Version 5.5 Version 5.6 Version 20.1 Version 20.2 Version 20.3 Version 20.4 Version 21.2 Version 21.3 Version 21.4 Version 22.1 Version 22.2 Version 22.3 Version 22.4 Version 23.1 Version 23.2 Version 23.3 Version 23.4 Version 24.1 Version 24.2 Version 24.4 Version 25.2
Contact Us
New Release Notification
Company Code Selection
User Profile
Excel Not Ready Error
Add-In Load Error
Multiple Instances
License Key Errors
Snapshot
Shared Templates Drive
Drive Types
File Server
SAP Database
Dropbox
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
System Administrator Options
System Administrator Licence Key
System Administrator User Permissions
System Administrator User Options
System Administrator Server Information
System Administrator Delimiter Options
System Administrator Configuration Options
Expand and Explode Level
Discover FICO Object Values
Expand and Explode
Expand FICO Object Values
Explode FICO Object Values
Explode FICO Object Value Hierarchy
Expand FICO Object Value Hierarchy
List of Values – Create
Previous FICO Object
Next FICO Object
Get Balance
Get CCA Balance
Get New GL Balance
Get Classic GL Balance
Get PCA Balance
Company Code Name
Alternative GL Account
FICO Object Description
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Criteria – CCA Balance
Drill Using a Saved Template
Drill to Document
Drill to Line Item
Template Layout
Save Template Layout
Manage Templates
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Load CCA
Create Schedule
Running the Scheduler
SMTP Email Settings
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution

Get Balance

The Get Balance functions are probably the most important functions in GL Wand. They return a balance individually or summed based on the parameters that you enter. Clicking any of the Get Balance functions on the GL Wand toolbar will open a Get Balance Wizard.

The following options are available in the Function Wizard:

  • Select a value from the drop down list. These lists are populated with the available values for each parameter or with the configuration data read directly from SAP.
  • Click the  button to link the parameter to an Excel cell.
  • With an Excel range reference in a parameter, use the F4 key to toggle the absolute and relative addressing as you would in Excel.

Note: when creating Get Balance formulas, always use “*” or blank to denote all values, as this process is faster than a range that encompasses all values e.g. “000:ZZZ”.