MOC 8400 - FRx 6.7 Report Design Essentials II

Delivery Options

• Live Online Training - Public Class (2 days): $950.00

» Free Demo

» Watch Presentation

» More Info

» Contact Education Consultant

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

Upcoming Live eLearning Classes

There are currently no upcoming Live eLearning classes. Please contact us if you would like us to schedule a class.

Class Description

Class Overview

Class Goals

• Review basic Microsoft FRx report design concepts.
• Explore ways to efficiently create and distribute many financial report designs including:.
• Learn to create trial balances.
• Learn to create reports linking to external worksheet data.
• Learn to create statements of Cash Flow.
• Learn to create reports using full accounts or multiple GL segments.
• Learn to create allocation reporting.
• Learn to use linking Row Formats.
• Learn relational reporting.
• Learn to handle multi-company consolidations.
• Learn to handle currency Translation.
• Learn about OLAP (Online Analytical Processing) output.
• Learn about XBRL (eXtensible Business Reporting Language) output.
• Learn advanced formatting tips and tricks.

Class Outline

1. Overview and Introduction
   1. About FRx Software Corporation products
   2. Terminology
   3. Demo company account structure
   4. Sample report demonstration
2. Concept Overview
   1. Basic Row Format review
   2. Working with TOTs and CALs in the Row Format
   3. How C's affect TOT and CAL rows and why to use them
   4. Defining a sort in the Row Format
   5. Relating rows to other rows
   6. Basic Column Layout review
   7. Defining a favorable/(unfavorable) variance Column Layout
   8. Working with BASE periods and years in the Column Layout
   9. Using "Add Reporting Units from Chart of Accounts" to build a Reporting Tree
   10. Using the split function to isolate a single account mask character
   11. Creating a new Reporting Catalog
   12. Defining report headers and footers
   13. Working with sub-totals in FRx DrillDown Viewer
   14. Lab: Row Repair
   15. Lab: Column Repair
   16. Lab: Build a Tree
   17. Lab: Build a Catalog
3. Linking to External Worksheets
   1. Referencing external worksheet data
   2. Optional row modifiers
   3. Determining the period of data to be reported on
   4. Using the combined GL+Worksheet link in the Row Format
   5. Calculation priority with working with intersecting row and column calculations
   6. Adding an external worksheet link to the Row Format
   7. Proper syntax in combined vs. separate linking
   8. Using the optional row modifiers /CPO and /RPO when referencing worksheet data
   9. Designing Column Layouts that report on either/or data (i.e. either Actual or Budget) depending on the report date
   10. Lab: Combined Worksheet Method
   11. Lab: Separate Worksheet Method
4. Practice
   1. Defining the GL+Worksheet link
   2. Working with the /CPO and /RPO row modifiers
   3. Using account and book code modifiers
   4. Advanced calculations and non-printing rows
   5. Modifying a Column Layout to link to worksheet data
   6. Lab: Gross Profit per Unit
   7. Lab: Modified Favorable/(Unfavorable) Budget Variances
5. Full Account Code & Multiple Segments
   1. Defining a fully qualified account in the Row Format
   2. How a full account in the Row Format affects units in a Reporting Tree
   3. Defining a range of periods in the Column Layout
   4. Using conditional dates in the Column Layout
   5. Using a range in a calculated column in the Column Layout
   6. Lab: Using Full Account Codes
   7. Lab: Using Multiple Segments
6. Rotate the Building Blocks
   1. Defining the Department segment in the Row Format
   2. Defining a Reporting Tree that recognizes the Department in the Row Format
   3. Using Account Filters in the Column Layout
   4. Lab: Defining Departments in the Row Format
   5. Lab: Unit Restrictions in the Row Format
7. Statements of Cash Flow
   1. Using "C" in the normal balance to properly state sources and uses of cash
   2. Using the beginning balance and year to date account modifiers
   3. Defining a non-printing check row
   4. Using specific placement calculations in the Row Format
   5. Designing Column Layout's that display the changes in activity for the time frame being reported on
   6. Defining calculation priority for intersecting row and column calculations
   7. Lab: Monthly Statement of Cash Flow
   8. Lab: Current and Year to Date Statement of Cash Flow
8. Practice
   1. Modifying an existing report design
   2. Using a combined GL+Worksheet link
   3. Using the /RPO row modifier
   4. Using non-printing check rows to validate report accuracy
   5. Lab: FASB Style Statement of Cash Flow
9. Allocations
   1. Using specific column placement in Row Format calculation
   2. Column G restrictions in the Row Format
   3. Using Book Code modifiers in the Row Format
   4. How to work with full accounts in the Row Format when using a Reporting Tree
   5. Suppressing data from rolling up in the Reporting Tree
   6. Using multiple GL Links in the Row Format and Reporting Tree
   7. Presentation of external worksheet data in calculated columns
   8. Advanced calculations in the Column Layout
   9. Advanced formatting
   10. Lab: Allocation Journal Entry
   11. Lab: Allocation Reporting
   12. Lab: Two-pass Allocation Reports
10. Practice
    1. Modifying existing building blocks
    2. Use non-printing columns for period specific information
    3. Using print controls to determine active columns
    4. Using non-printing rows and specific column placement calculations in the Row Format
    5. Lab: Modified Allocation of Corporate Expenses
11. Row Linking
    1. Adding a Row Format link to a Row Format
    2. Using text labels for row codes
    3. Defining a Reporting Tree that relates to multiple Row Formats
    4. Advanced formatting concepts
    5. How rounding options work with Row Linking
    6. Lab: Row Linking
    7. Lab: Row and General Ledger Linking
12. Practice
    1. Linking to another Row Format
    2. Defining a Reporting Tree that can access multiple Row Formats
    3. Using the BASE+ concept in the Column Layout
    4. Rounding options when using Row Linking
    5. Lab: Row Linking Income Statement
13. Review
    1. Concept Review
    2. Lab: Crossword Puzzle#Relational Reporting
    3. Defining the CBR or Base Row(s)
    4. Defining Column Layout calculations that work with CBR in the Row Format
    5. Using Reporting Unit restrictions in the Row Format vs. full account codes to restrict the data being reported on
    6. Using Reporting Unit restrictions in the Column Layout vs. Account Filters to restrict the data being reported on
    7. Lab: Multiple Base Row Definitions
    8. Lab: Using Statistical Information as a Base Row
14. Effective Dates
    1. Using save as to create multiple Column Layouts with simple updates to each
    2. Defining effective dates in the catalog
    3. Lab: Variable Income Statement
15. What's Wrong?
    1. IF/THEN/ELSE calculations in the Row Format
    2. IF/THEN/ELSE calculations related to Reporting Tree Units
    3. IF ABS (absolute value) calculations in the Column Layout
    4. Lab: Using Conditional Statement
    5. Lab: If-Then-Else and Reporting Tree units
    6. Lab: Variance Reporting
16. Additional Formatting Concepts
    1. Using column Z (Additional Text) in the Reporting Tree
    2. Working with Excel or Microsoft( Office Word( and Microsoft FRx
    3. Defining International Formats
    4. Lab: Additional Descriptive Text
17. Consolidations
    1. Overview of multiple company consolidations in Microsoft FRx
    2. How to format amounts
    3. Assigning an international format to a report
    4. When is a Reporting Tree required
    5. Side-by-side (consolidating) Column Layout design
    6. Linking to external worksheet data
    7. Lab: GL Eliminations
    8. Lab: External Eliminations
18. OLAP Output
    1. Microsoft FRx and OLAP
    2. Microsoft Local Cubes
    3. Microsoft Server Cubes
    4. Excel Pivot Chart and Excel Pivot Table output options
    5. Terminology in OLAP and Microsoft FRx
    6. Lab: Working with OLAP Cubes in Excel
19. XBRL
    1. XBRL Overview
    2. Adding an XBRL link and related taxonomy file
    3. Assigning XBRL tags
    4. The XBRL Instance Document output option
    5. Lab: Create an XBRL Document in Microsoft FRx
20. Currency Translation
    1. Using an external worksheet link to pull in translation rates
    2. Adding CTA (cumulative translation adjustment) to the Row Format
    3. Using column restrictions in the Column Layout to define formatting
    4. Defining the DAX rates path
    5. Activating DAX in the Catalog and Column Layout
    6. Assigning currency conversion format codes and related rate IDs
    7. Lab: Translated Balance Sheet
    8. Lab: Translated Balance Sheet using DAX
    9. Lab: Translated Income Statement using DAX

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:

FRx 6.7 Report Design Essentials I

Courses that can help you meet these prerequisites:

• MOC 8399 - FRx 6.7 Report Design Essentials I

Technical Requirements

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

• Instructor-led Online course technical requirements and setup instructions.
• WebEx system requirements for Instructor-led Online delivery option.
• Onsite course technical requirements and setup instructions.
• Hosted eLearning course technical requirements and setup instructions.
• Hosted eLearning course frequently asked questions.