Contact Us
Index
Version 5.1
Version 5.0 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
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
License Key Errors
Snapshot
Shared Templates Drive
Drive Types
Dropbox
File Server
SAP Database
Navigator
Create a File
Delete a File
Edit a File
Open a File
Common Options
System Administrator Options
System Administrator License Key
System Administrator User Permissions
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Discover FICO Object Values
Expand/Explode Level
Expand and Explode
Expand FICO Object Values
Expand FICO Object Value Hierarchy
Explode FICO Object Values
Explode FICO Object Value Hierarchy
List of Values – Create
Next FICO Object
Next COPA (CB) Object
Previous FICO Object
Get Balance
Get Classic GL Balance
Get PCA Balance
Get New GL Balance
Get CCA Balance
Get COPA (CB) Balance
Get Internal Order Balance
Get Project Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next FICO Object
Next COPA (CB) Object
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Drill Criteria Sheets
Drill Criteria – Classic GL Balance
Drill Criteria – CCA Balance
Drill Criteria – New GL Balance
Drill Criteria – PCA Balance
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Edit Template Layout
Save Template Layout
Manage Templates
Other Tools
Hide Zeros
Clean Template
Configuration Sheet
GL Wand User Options
Open Report
Create Report
Execute Report
Insert Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh Mode
Refresh Reports Wand Functions
Parameter List
Report Editor
Template Manager
Reports Wand User Options
Load CCA
Load PCA
Load New GL
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Load and Validation
Execution
Create Schedule
Running the Scheduler
SMTP Email Settings

System Administrator User Options

Set the default user options. Additionally, prevent the user from changing the option locking the applicable items.

Option Description
Include product usage with the overall company statistics Determines if the user’s product usage will be included in the company statistics.

This option cannot be disabled during a trial of the product.
Suppress unsafe exit warnings If you you do not use the Exit button to quit the application you will be prompted with the warning at the next launch. Use this option to suppress that warning message for all users.

The Exit process performs a number of important tasks and users must therefore use this button to quit the application. We do not recommend that you enable this option to suppress the warning message.
Show last calculated values Shows the last calculated value, if available, when performing an action that triggers an Excel calculation (except using the refresh buttons which always calculates a new result).
Auto refresh when workbook opened By default a workbook will not calculate Wands formulas when it is opened. This option can be used to control this behavior.
Disable Excel multi-threaded calculation mode Disables Excel’s multi-threaded calculation mode during an Wands calculation. Due to an Excel bug, which has not yet been addressed by Microsoft, an error can occur during the calculation of larger, more complex reports. The error manifests as an “Out of resources” message or an Excel crash which occurs during the process where the results of Wands functions are returned to Excel. Disabling the multi-threaded calculation mode is a workaround to avoid this bug. The overall effect on calculation time should be minimal as the results are returned to Excel in-between processing other calculations.

The bug does not affect all reports and you may therefore uncheck this option should you wish. However if you experience the Excel bug then checking this option will be required.
Calculation drills to new workbook When enabled, drilling down from a function (calculation) will populate the results into a new workbook.
Drilldown drills to new workbook When enabled, drilling down from a previous drilldown report will populate the results into a new workbook.
Double click enabled When disabled, a double click in Excel will no longer open lists of values and execute drilldowns.

Changes to this option are only effective at the next logon or after changing company code.
With this setting enabled, double clicking in a cell that does not contain an Wands drilldown function or list of values will always result in the cell being put into edit mode. Excel’s option to select the cells that are referenced by the active cell will be disabled.
Suppress zeros on drilldown Exclude items in the balance drilldown report if the opening balance, dr movement, cr movement and closing balance are all zero.
Email Client Your choice of which email option to use. Can be Microsoft Outlook (uses the Microsoft Outlook Client to create and send emails) or SMTP (uses the defined SMTP server settings to create and distribute emails). If you do not intend sending email then set this option to Unsupported.
SMTP Host The SMTP host name; e.g. smtp.gmail.com.
SMTP Port The SMTP port; e.g. 465.
SMTP Encryption Type Select the applicable encryption type.
Address Book Client This is used to get the list of email addresses in your address lists. Currently only supports Microsoft Outlook.
Default Address Book Choose which Address Book is used when opening an email address list.
SMTP requires authentication Tick this option if your SMTP server requires authentication.