The teacher explained things well and, when I asked questions beyond the immediate scope of the course content,... More Testimonials »
Home > Microsoft > Dynamics > MOC 8399 - FRx 6.7 Report Design Essentials I

MOC 8399 - FRx 6.7 Report Design Essentials I

Delivery Options

Class Date and Time Price Pricing Information
$950.00
or 2 vouchers vouchers
$950.00 or 2 vouchers vouchers
Register Now
$950.00 or 2 vouchers vouchers
Register Now

Class Description

Class Overview

This Microsoft FRx training class covers the basic report design skills you need to create, maintain and distribute presentation quality reports using Microsoft FRx. The class also includes coverage of additional functionality designed to help you create new reports, and distribute and analyze your company's financial information. You learn about basic foundational skills, complex calculations, drag and drop reorganization, rounding adjustments and account sets.

A thorough understanding of these topics allows you to easily design and maintain standard and essential reports your organization needs to understand its financial position. You learn how to use templates or create customized report designs as well as how to setup self maintaining reports that will dynamically include newly added GL accounts and newly closed periods. This Microsoft FRx course also teaches you how to generate and electronically distribute reports using your in-house email system. These skills enable you to take control of the financial reporting process, allowing you to be more productive and efficient in the way you create, generate and distribute financial information, which in turn help you to enable internal and external stakeholders to make well informed decisions to positively impact your organization as a whole.

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

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

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.

Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723