Contact Us
Index
Version 20.4
Version 20.3 Version 21.1 Version 25.2
Contact Us
Combine Text
Last Refreshed By
Last Refreshed Time
Split Text
Common Options
Snapshot
Shared Templates Drive
Edit a File
Open a File
Drive Types
Dropbox
File Server
Oracle Cloud Connector Database
Navigator
Create a File
Delete a File
System Administrator Options
System Administrator User Options
System Administrator Delimiter Options
System Administrator Configuration Options
System Administrator Server Information
Discover Period Names
Discover Segment Properties
Expand and Explode
Expand Segment Values
Expand Segment Value Hierarchy
Explode Segment Values
Explode Segment Value Hierarchy
Discover Segment Values
Discover Level
List of Values – Create
Financial Category
Period Name by Date
Period Start Date
Period End Date
Segment Tree
Get Balance
Multiple Ledgers
Get Balance Options
Get Average Balance Summary
Functional Currency
Segment Start Date
Enabled Flag
Ledger Name
Account Type
Segment End Date
Segment Description
Previous Segment Value
Period Offset
Period Name
Parent Flag
Next Segment Value
Ledger Set
Analyze Balances
Drill to Journal or Subledger
Drill Using a Saved Template
Drill Criteria Sheets
Drill Criteria – Journal Extract
Drill Criteria – Balance
Edit Template Layout
Save Template Layout
Manage Templates
Other Tools
Create a Template
Template Storage Requirement
Edit a Template
Delete a Template
Hide Zeros
GL Wand User Options
Advanced Options
Email
Drilldowns
Parameters
Source Report
Named Ranges
Execution
Load and Validation
Running the Scheduler
Create Schedule
SMTP Email Settings

Load and Validation

Execution begins with loading the selected rows from the RDM template. Each row is called a RDM job and the number of rows selected is based on the execution action selected from the toolbar.

The Validation Level selected in the RDM User Options determines if validation and confirmation is performed. When the validation of all the selected jobs is completed, any validation errors are shown by highlighting the specific spreadsheet cell and adding a comment to the cell explaining the error. In order to simplify the identification of jobs with validation errors the Source Report cell is also highlighted.

If validation is passed and the Validation Level requires confirmation, a confirmation dialog will be presented which will provide information on the number of reports and output files that will be generated.

Open Workbooks

If any non RDM Template workbooks are open you will first be prompted to confirm if you would like to continue, opting to continue without closing these workbooks could result in an execution failure. If any of the source report workbooks are open during validation, the validation process will stop immediately.

Warnings

Cell(s) marked with yellow indicates a warning. If the source report cell is highlighted in yellow this indicates that the output file already exists and will be merged.