Contact Us
Index
Version 21.2
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.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
Wands for SAP 21.2 – Home
Wands
Logging On
User Profile
Company Code Selection
Excel Not Ready Error
Add-In Load Error
Toggling from V21.x to V4.x
Toggling from V4.x to V21.x
License Key
License Key Errors
Insert Wands Function
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Tools (Wands)
Snapshot
Shared Templates Drive
Drive Types
Navigator
Dropbox
File Server
Create a File
SAP Database
Delete a File
Edit a File
Open a File
Common Options
Administrator
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
Errors and Troubleshooting
Help and Shortcuts
Excel Error
Upgrade Workbook
About
Exit
GL Wand
Quick Start
Report Wizard
Add Columns
Design Layout
Add Rows
Report Wizard Output
Company Code and Object Selector
Discover
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
List of Values – Create
Insert GL Wand Function
Get Balance
Get Classic GL Balance
Get New GL Balance
Get Daily GL Balance
Get CCA Balance
Get PCA Balance
Get COPA (CB) Balance
Get Internal Order Balance
Get Activity Type Balance
Get Project Balance
Get SKF CCA Balance
Get SKF IO Balance
Get Universal Journal Balance
Get Overall Plan Balance
Get SKF PCA Balance
Company Code Name
Object Description
FICO Object Description
COPA (CB) Object Description
Next Object
Next FICO Object
Next COPA (CB) Object
Get Exchange Rate
Previous Object
Previous FICO Object
Previous COPA (CB) Object
Alternative GL Account
Get Offsetting Account
Calculating
Execute Drilldown
Drill Criteria Sheets
Drill Using a Saved Template
Drill to Line Item
Drill to Document
Drill to Document Attachment
Customize Drilldown
Edit Template Layout
Save Template Layout
Manage Templates
GL Wand Tools
GL Wand User Options
Other Tools
Hide Zeros
Clean Template
Manage Criteria Templates
Configuration Sheet
Reports Wand
Report
Create Report
Execute Report
Insert Function
Insert Run Report Function
Run Report Filter
Modify a Run Report Function
Drill On Function
Drill to Saved Template
Refresh
Refresh Reports Wand Functions
Refresh Mode
Show
Parameter List
Report Editor
Template Manager
Tools
Reports Wand User Options
Administration
Report Definition
Create
Edit
Planning Wand
Insert Planning Wand Function
Load CCA
Load PCA
Load New GL
Load Activity Input
Load Activity Output
Load SKF
Load S4 Financial
Load Option Selector
Loading Plans
Planning Wand User Options
Report Distribution Manager
Create RDM Template
Source Report
Named Ranges
Parameters
Drilldowns
Email
Advanced Options
Execute Report Distribution Manager
Load and Validation
Execution
Edit RDM Template
Scheduler
Create Schedule
Running the Scheduler
RDM User Options
SMTP Email Settings
chat icon - ignore
Live Chat
Chat Offline

Shared Templates Drive

The Shared Templates Drive is an integrated document management system that makes it easy to securely share, organize and discover Wands related Excel template files. It is accessible from the Wands and Product menus.

What type of files should be stored in the Drive?

When uploading a file you will have the opportunity to classify it using one of the following Template Type classifications:

Template Type Description
GL Wand Any file containing GL Wand related formulas and calculations.
Reports Distribution Manager RDM Template files used to replicate and distribute GL Wand Reports.
Scheduler RDM Scheduler files used to schedule the execution of RDM Template(s).
Planning Wand Upload Template RDM Scheduler files used to schedule the execution of RDM Template(s).
Reports Wand Reports Wand Reports and files containing Reports Wand Run Report functions.

The Shared Templates Drive is not intended to be a replacement for your Enterprise document management system and should only be used to store template files related to Wands Products.

To keep your Shared Templates Drive organized and uncluttered, encourage users to use this simple rule of thumb: “If you are unable to classify your file using one of the Template Type classifications, it probably means that it should not be stored in the Shared Templates Drive“.

File Permissions

File permissions are controlled by file ownership and the Wands System Administrator profile. The following table details the Shared Templates action and it’s related control.

Action Control
Open a File A file can be opened by any user.
Create a File Any user can create a new file.
Edit a File Only the owner or users assigned the Wands System Administrator profile can edit a file.
Delete a File Only the owner or users assigned the Wands System Administrator profile can delete a file.

Viewing Files – If “Restrict access based on product license” is enabled under the System Administrator Configuration Options then a user can only see files which they have a license for, unless they are an Wands System Administrator in which case they can see all files on the shared templates drive.