MOC 8399 - FRx 6.7 Report Design Essentials I

Delivery Options

• Live eLearning (2 days): $950.00 (Register)

» Register Now

» Free Demo

» Watch Presentation

» Contact Education Consultant

• Customized Onsite Training (2 days): Request a Proposal

Class Date and Time	Price Volume Discounts Students Discounts 2 5% 3-4 10% 5 or more 15% GSA Price: $902.50	Register
Apr 15 - 16, 2010 10:00 AM - 6:00 PM ET	$950.00 or 2 vouchers	Register
May 13 - 14, 2010 10:00 AM - 6:00 PM ET	$950.00 or 2 vouchers	Register
Jun 10 - 11, 2010 10:00 AM - 6:00 PM ET	$950.00 or 2 vouchers	Register

Class Description

Class Overview

Class Goals

• Understand basic navigation and report creation in Microsoft FRx.
• Learn to drill down, analyze, print and export from FRx Drilldown Viewer.
• Learn to efficiently create and distribute many financial reports including:.
• Learn to implement trial balances.
• Learn to implement balance Sheets.
• Learn to implement transaction detail reporting.
• Learn to implement trended reports.
• Learn to implement side-by-side presentation.
• Learn to implement relational reporting.
• Learn to implement Actual vs. Budget.
• Learn to implement rolling quarters.
• Learn some tips and tricks for increasing speed and accuracy of month-end close.
• Learn to create presentation quality reports.
• Understand security settings within Microsoft FRx.
• Understand many ways to improve your company's financial reporting package.

Class Outline

1. Overview and Introduction
   1. About FRx Software Corporation products
   2. Terminology
   3. Demo company account structure
   4. Sample report demonstration
2. Creating a Trial Balance
   1. Using the "Add Rows from Chart of Accounts" feature to automatically populate the row format with account numbers and descriptions
   2. Using wildcards or ranges to summarize data
   3. Using the Normal Balance field and how C's affect the account presentation
   4. Using underscores and totals
   5. Using Header Codes to automatically update column headers each month
   6. Use of the BASE Period and Year in the Column Layout to ease maintenance
   7. Setting the Report Date to an option that automatically progresses through the year for ease of report maintenance
   8. Defining a detail level in the Catalog
   9. Introduce the default Formatting options
   10. Using existing building blocks to speed setup time
   11. Using the View, Subtotals function in FRx DrillDown Viewer
   12. Lab: Detailed Trial Balance
   13. Lab: Summary Trial Balance
3. Creating an Income Statement
   1. Using the Add Rows from Chart of Accounts function to quickly create a basic template
   2. How proper placement of C's in the Account Balance column of the Row Format will flip the balance of an account for presentation
   3. How the presentation of the accounts included determine the math for related TOT or CAL formulas
   4. How to use a Special Format Mask on a row formula to determine display
   5. Using system defined or custom fonts for emphasis
   6. Working with rounding options
   7. Lab: Detailed Income Statement
4. Reporting Trees
   1. Characters used with Add Reporting Units
   2. Segment hierarchy
   3. Defining a segment range
   4. Adding custom units to a tree
   5. The default Reporting Tree
   6. Relating Reporting Trees to Row Formats
   7. How trees define multiple reports in a single catalog
   8. Using check rows to insure all accounts are included
   9. Rounding options and how they relate to calculations
   10. How to relate description or underscore rows to other rows
   11. Exception reports and how they work
   12. Lab: Creating Reporting Trees
   13. Lab: Departmental Income Statement
5. Review
   1. Review basic report design concepts
   2. Lab: What's Wrong?
6. More on Reporting Trees
   1. How to create a Column Layout based on current and prior results
   2. Defining unit hierarchy when building a Reporting Tree
   3. How to split a segment to create a virtual segment in Reporting Trees
   4. Adding custom units to a Reporting Tree
   5. Generating specific Reporting Tree units
   6. Using header and footer codes in the Catalog
   7. Lab: This year vs. last year Income Statement
   8. Lab: Income Statement by Location
7. Transaction Detail Reporting
   1. Creating a transaction detail Column Layout
   2. Restricting a column to either debit or credit activity
   3. Restricting a column to display beginning balances
   4. Generating a Catalog to the Microsoft Office Excel output option
   5. How report presentation varies between Microsoft Excel and FRx DrillDown Viewer
   6. Lab: Cash Transaction Details
   7. Lab: Debit/Credit Details
8. Using FRx DrillDown Viewer
   1. Printing reports from FRx DrillDown Viewer
   2. Sending reports
   3. Export options in FRx DrillDown Viewer
   4. Lab: Viewing/Printing Account Detail
   5. Lab: Using the Send feature
   6. Lab: Export Options
9. Working with Specification Sets
   1. Understand the specification set (.F32) file
   2. Defining the active spec set in the Company Information settings
   3. Navigation in the Specification Sets window
   4. Learn to "save as" between spec sets
   5. Learn to export and import between spec sets
   6. Lab: Saving between Spec Sets
   7. Lab: Export and Import between Spec Sets
10. What we Know
    1. Review basic report design concepts
    2. Lab: Modify Building Blocks
11. Balance Sheets
    1. Account Sets
    2. Presentation of Balance Sheet accounts (using C in the Normal Balance)
    3. Defining Year to Date Income in the Balance Sheet
    4. Using the XD code to suppress drill down on specific rows
    5. Using column G of the Row Format to define placement in the Column Layout
    6. Using the Rounding Adjustments function
    7. Using XD in the Column Layout to suppress GL details
    8. Lab: Detailed Balance Sheet
    9. Lab: Comparative Balance Sheet
12. Income Statement Variations
    1. Summary Income Statement design
    2. Trended Income Statement design
    3. Using conditional statements in the Column Layout
    4. Using Account Modifiers in the Row Format to override the Column Layout
    5. Variance reporting (Over/(Under) and Favorable/(Unfavorable) methods
    6. Sort commands
    7. Lab: Summary Income Statement
    8. Lab: Trended Income Statement
    9. Lab: Current & YTD Trended Income Statement
    10. Lab: Over/(Under) Budget Income Statement
    11. Lab: Favorable/(Unfavorable) Budget Variances
13. Relational Reporting
    1. Defining CBR (Base) rows in the Row Format
    2. Defining Column Layout calculations that work with CBR in the Row Format
    3. Suppressing CBR in detail reports
    4. Lab: Defining a Base Row
    5. Lab: Multiple Base Row Definitions
14. Side by Side Reporting
    1. Using Account Filters in the Column Layout
    2. Restricting columns to specific Tree Units in the Column Layout
    3. Lab: Side by Side Reporting with Filters
    4. Lab: Side by Side Reporting with a Reporting Tree
15. Report Distribution
    1. Naming conventions
    2. Chain to Catalog ID functionality
    3. Report archive options
    4. E-mail distribution methods available in Microsoft FRx
    5. FRx WebPort distribution
    6. FRx Report Manager Demonstration
    7. Lab: Chaining Report Catalogs
16. What's Wrong?
    1. Importing a .tdb file
    2. Troubleshooting a report
    3. Lab: Broken Income Statement
17. Troubleshooting
    1. Rebuilding the GL Index (.G32 file)
    2. Compacting the Microsoft FRx Databases
    3. Getting additional help
    4. Report Design Guidelines
    5. Lab: Rebuilding the GL Index
    6. Lab: Compacting the Microsoft FRx Databases
18. Advanced Concepts
    1. Adding a Microsoft FRx report to Microsoft Office Outlook
    2. Adding report information to Excel and Microsoft Office Word documents
    3. Overview of Microsoft FRx Report Design Essentials II training class

Class Materials

All students receive a course manual or book and all the class examples.

Students in private onsite classes will also receive:

• Technical Reference Library

Class Prerequisites

Experience in the following areas is required:

• Basic knowledge of accounting principles

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Course technical requirements and setup instructions.