8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated

8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course Description

Intended Audience for the 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course

• Novice FRx users
• Intermediate and experienced FRx users who would like to refresh their skills or develop broader product proficiency
• FRx Software product resellers
• Before attending this course, students must have general knowledge of Microsoft Windows and basic knowledge of accounting principles.

8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course Objectives

• Understand basic navigation and report creation in FRx
• Drill down, analyze, print and export from the FRx Drilldown Viewer
• Efficiently create and distribute many financial reports including:
• Trial balances
• Balance sheets.
• Transaction detail reporting
• Trended reports
• Side-by-side presentation
• Actual vs. Budget.
• Rolling quarters
• Know some tips and tricks for increasing speed and accuracy of month-end close
• Create presentation quality reports
• Understand security settings within FRx
• Understand many ways to improve your company's financial reporting package
• Have a renewed understanding of basic FRx report design concepts
• Explore ways to efficiently create and distribute many financial reports including:
• Linking to external worksheet data
• Statements of Cash Flow
• Using full accounts or multiple segments in reports
• Allocation reporting
• Linking Row Formats
• Relational reporting
• Multi company consolidations
• Currency Translation
• OLAP (Online Analytical Processing) output
• XBRL (eXtensible Business Reporting Language) output
• Advanced formatting tips and tricks

Recommended Prerequisites for the 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated course

• 8816+8822+8824: Inventory Control and Sales and Purchase Order Processing in Microsoft Dynamics GP 10.0 Accelerated

The 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course prepare students for the following Exams

• MB5-294 : FRx Reporting Design Exam

Recommended Next Steps after taking the 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course

• 8814: Installation and Configuration in Microsoft Dynamics GP 10.0 Accelerated

8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated Course Outline

1. Overview and Introduction
   1. About FRx Software 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 progress 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 the DrillDown Viewer
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
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
5. Review
   1. Review basic report design concepts
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 trees
   4. Adding custom units to a tree
   5. Generating specific tree units
   6. Using header and footer codes in the Catalog
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 Excel output option
   5. How report presentation varies between Excel and the DrillDown Viewer
8. What we Know
   1. Review basic report design concepts
9. Using the DrillDown Viewer
   1. Printing reports from the DrillDown Viewer
   2. Using the Send function
   3. Export options in the DrillDown Viewer
10. Working with Specification Sets
    1. Understand the specification set (.F32) in the Company Information settings
    2. Learn to "save as" between spec sets
    3. Learn to export and import between spec sets
11. Practice
    1. Practice the report design concepts learned thus far in class
12. 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 the Rounding Adjustments function
13. Income Statement Variations
    1. Trended Income Statement design
    2. Using conditional statements in the Column Layout
    3. Using Account Modifiers in the Row Format to override the Column Layout
    4. Variance reporting ( Over/(Under) and Favorable/(Unfavorable) methods
    5. Sort commands
14. Practice
    1. Practice the report design concepts learned so far in class
15. Side by Side Reporting
    1. Using Account Filters in the Column Layout
    2. Restricting columns to specific Tree Units in the Column Layout
16. Report Distribution
    1. Naming conventions
    2. Chain to Catalog ID functionality
    3. Report archive options
    4. E-mail distribution methods available in FRx
    5. WebPort distribution
    6. Report Manager Demonstration
17. What's Wrong?
    1. Importing a .tdb file
    2. Troubleshooting a report
18. Troubleshooting
    1. Rebuilding the GL Index (.G32 file)
    2. Compacting the FRx Databases
    3. Getting additional help
    4. Report Design Guidelines
19. Advanced Concepts
    1. Adding an FRx report to Microsoft Outlook
    2. Adding FRx report information to Excel and Microsoft Word documents
    3. Overview of the Report Design Essentials II training class
20. Overview
    1. About FRx Software products
    2. Terminology
    3. Demo company account structure
    4. Sample report demonstration
21. 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. Defining report headers and footers
22. 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
23. Gross Profit per Unit - Practice
    1. Defining the GL+Worksheet link
    2. Working with the /CPO and /RPO row modifiers
    3. Using account and book code modif
    4. Advanced calculations and non-printing rows
24. Full Account Code and 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
25. Defining Departments in the Row Format - Practice
    1. Defining the Row Format on the Department segment
    2. Defining a Reporting Tree that recognizes the Department in the Row Format
    3. Using Account Filters in the Column Layout
26. 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
27. FASB Style Statement of Cash Flow - Review
    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
28. 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
29. Modified Allocation of Corporate Expenses - Practice
    1. Modifying existing building blocks
    2. Working with the Combined GL+Worksheet link
    3. Using WKS type columns in the Column Layout
    4. Using non-printing rows and specific column placement calculations in the Row Format
    5. Proper catalog definition when linking to external worksheet data
30. 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
31. Row Linking Income Statement - 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
32. Review
    1. Concept Review
33. 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
34. Multiple Base Row Definitions and Using Statistical Information as a Base Row - Practice
    1. Defining the CBR or Base Row
    2. Using Reporting Unit restrictions in the Row Format vs. full account codes to restrict the data being reported on
    3. Using Reporting Unit restrictions in the Column Layout vs. Account Filters to restrict the data being reported on
35. Additional Formatting Concepts
    1. IF/THEN/ELSE calculations in the Row Format
    2. Defining effective dates in the catalog
    3. Using column Z (Additional Text) in the Reporting Tree
    4. Working with Microsoft Excel or Microsoft Word and FRx
    5. Defining International Formats
36. Consolidations
    1. Overview of multiple company consolidations in 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
37. OLAP Output
    1. 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 FRx
38. XBRL
    1. XBRL Overview
    2. Adding an XBRL link and related taxonomy file
    3. Assigning XBRL tags
    4. The XBRL Instance Document output option
39. 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

Benefits of taking the 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated course at NetCom

• Why choose Microsoft Dynamics Training at NetCom Learning?
  As a recognition for training excellence, NetCom Learning was chosen by Microsoft as the 2007 Worldwide Learning Solutions Partner of the year out of 1400 training companies.

  In addition, we have won numerous other training awards for quality and customer satisfaction by CompTIA, EC-Council and other vendors. We are simply passionate about learning and achieving the highest customer satisfaction in your learning experience!

  See the training value proposition below:

  Why Microsoft Dynamics Training at NetCom? NetCom Information Technology is a Microsoft Gold Certified Partner for Learning Solutions (CPLS). CPLS is the premier training channel and delivery mechanism for Microsoft Dynamics training content. On July 11, NetCom was honored by Microsoft as its Learning Solutions Partner of the Year. Selected as the Number One CPLS, from over 1400 worldwide CPLS's, Microsoft recognized our commitment and ability to deliver high-quality learning services using a consultative engagement model. We could not have achieved this coveted status without the help and support of our customers and well wishers - thank you!! Microsoft Certified Partner for Learning Solutions Value Proposition: Microsoft Certified Partner for Learning Solutions Non-authorized Training Center Only MCT (Microsoft Certified Trainers) are authorized to teach the class Non MCT can teach the course Taught using Microsoft Authorized Courseware (MOC), includes free evaluation software and online training Do not have access to official courseware Partners adhere to stringent Microsoft designated lab requirements Computer and lab equipment may not be up to requirements of course Successful candidates are awarded Certificate of Completion directly from Microsoft for most of the courses Not authorized to issue Certificate of Completion Overall, a better quality training experience Substandard training experience

• NetCom provides Authorized Training
  NetCom Learning is a Microsoft Gold Certified Partner for Learning Solutions (CPLS), Cisco Learning Partner, CompTIA Platinum Partner, EC-Council Accredited Training Center, Adobe Authorized Training Center, Autodesk Authorized Training Center and many others. We are proud to offer the highest quality, authorized training solutions from our many partners for our customers.

  See our comprehensive list of partner authorizations.

• Award winning, world-class Instructors

  Ginger M. - Bachelor's Degree in Accounting and a Masters of Business Administration from Rutgers University. - Over 9 years of experience as a Master Certified Trainer. Expert in MS Dynamics GP Financials, Installation, HR/Payroll, Project Accounting, Inventory and Integration Manager. - Project Manager to various MS Dynamics Great Plains implementations. Bio: Ginger holds a Bachelor's Degree in Accounting and a Masters of Business Administration from Rutgers University. Her career started as an Auditor for Deloitte & Touché and over the years she developed her passion for Microsoft Dynamics, implementing Dynamics GP and Project Cost in the Professional Services, Commercial Real Estate and Medical Facilities vertical markets. Ginger's experience with Microsoft Dynamics is unparalleled. As a Certified Master Dynamics trainer, she stays abreast of the latest Dynamics modules and shares experience with a very hands-on training technique at NetCom Learning.

  Ignacio J. - Designs and architects Microsoft IT solutions since the early 1990s. - Hands-on experience in multiple Microsoft Dynamics products including CRM, GP, SL, AX and NAV since 2004. - Taught over 250 courses at NetCom Learning. Bio: Ignacio is a Senior Solutions Architect, Civil Engineer and Certified Expert Trainer. He has been designing and architecting Microsoft IT solutions since the early 1990s, and has extensive experience developing scalable and high performance integration solutions. In 2004, Ignacio expanded into business management and accounting software as well, where he gained hands-on experience in many Microsoft Dynamics products including CRM, GP, SL, AX and NAV. Ignacio holds a library of industry-wide certifications from Microsoft and other leading IT vendors. He has taught over 250 courses at NetCom Learning and is revered by students for his wide-ranging IT expertise.

  Lynn D. - Over 25 years of experience working as Senior Financial Analyst and Senior Auditor. - Professor of Graduate Management and Business School at the University of Phoenix since 2007. - Microsoft Certifications in Financials, Trade & Logistics, Production and Human Resources Management as well as Microsoft Certified Trainer (MCT) since 2009. Bio: Lynn is a very accomplished Senior Financial Analyst and Senior Auditor with over 25 years of experience. She has been a Microsoft Certified Trainer since 2009 and a Professor of Graduate Management and Business School at University of Phoenix since 2007. In addition to several other Microsoft certifications, she is also a specialist in Microsoft Dynamics AX. Lynn has taught several Microsoft Dynamics AX courses at NetCom Learning and is described by her students as very knowledgeable, qualified, and patient with her approach. Her classes are very dynamic and energetic, just as the course per se.

  See more...  
• Actual Client Testimonials

  Nov 15 2011 The Instructor definitely Met the expectations. The Learning Experience was a good starting point. The accomodations were excellent and the Training will be a good starting point for future knowledge increase. -Riste. T Course(s) Taken Microsoft Dynamics CRM 2011 - Accelerated

  
  

  Sep 29 2011 The instructor was very knowledgeable covered the material very well. The accommodations are above and beyond what I expected. The learning experience was great. Everything ran smoothly and I'm learning more than I hoped. This class has already had an impact on my career, potential employers were impressed that I was taking both courses on my own(I took vacation and paid myself) I received and accepted the job offer last Monday. -Benjerman R. Course(s) Taken Microsoft Dynamics AX 2009 - Development (I, II, III & IV) - Accelerated

  
  

  Sep 06 2011 Stan was great, knowledgeable and willing to answer any questions with depth and accuracy. -Christopher W. Course(s) Taken Microsoft Dynamics AX 2009 - Development (I, II, III & IV) - Accelerated

  
  

  Sep 06 2011 Instructor had a great level of experience for the class. Good labs. Didn't really know how I would do on 10 hour days, but it was a good pace and didn't prove to be a problem. -Stan W. Course(s) Taken Microsoft Dynamics AX 2009 - Development (I, II, III & IV) - Accelerated

  
  

  Aug 23 2011 Overall the training facilities and instructor were great. -Kris S. Course(s) Taken Microsoft Dynamics GP - Other

  
  

  Aug 16 2011 Learned a lot of very useful information. Enjoyed the class and discussion. -Sandra W. Course(s) Taken Microsoft Dynamics NAV - Other

  
  

  Aug 02 2011 Classroom environment was good. Remote users delayed class due to connection issue. Highly recommend instructor begin 45min earlier than class time to confirm connections. Disappointed by some content being dropped from the training such as workflows, some more advanced out of the box options. Instructor had some real world examples which assisted with learning. Some questions that I felt were important to new CRM users and customizes could have been more patiently addressed. Labs and books were very detailed about the content covered. Need morning snacks. Afternoon snacks should be expanded Lunch was excellent. -Deborah B. Course(s) Taken Microsoft Dynamics CRM 2011 - Accelerated

  
  

  Feb 04 2011 Very Informative. -Jackie H. Course(s) Taken Microsoft Dynamics GP 10.0 - Financials

  
  
• Awards won by NetCom
  NetCom Learning is an award winning, customer focused company. We are simply Passionate About Learning!

  See our list of awards.

• Specialized Bootcamp Training
  This training is also available as a boot camp. NetCom is world famous for delivering specialized boot camp training to our clients.

  For answers to questions regarding our boot camp training delivery format, please refer to our Boot Camp FAQ section.

Enrollment Options for the 8399+8400: Microsoft FRx Report Design in Dynamics GP 10.0 Essentials I and II Accelerated course

• Contact us to customize this class with your own dates, times and location. You can also call 1-888-563-8266 or chat live with an Educational Consultant.

Training Delivery Methods

• Classroom Training
  NetCom’s classroom training ensures that you have state-of-the-art tools, techniques and practices you need to succeed on the job. Our instructors are active practitioners and true masters in their fields. With convenient classes at multiple learning centers across the US, you never have to go far to get ahead.

• Live Online Training (LOT)
  NetCom’s premium Live Online Training (we call it LOT) is the ultimate in convenience and cost-effectiveness. LOT combines interactive video instruction via the latest web conference technology, and post-class access to learning labs for a best-in-class learning experience.
  Learn more about LOT

• Boot Camp Training
  NetCom’s intensive boot camps are designed to advance your skills in the shortest possible amount of time and get you certified. Boot camps go at a faster pace and often run for longer days, so you must have some level of subject matter experience before enrolling. Boot camps have mandatory assessment tests to ensure no one will slow down the class for other students. Learn more about Boot Camps

• Private Onsite Training
  With NetCom’s private training programs, you decide where and when courses are held. Tailor the training to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique. Save money by doing bulk customized training.
  Learn more about Private Onsite Training

• Private 1-on-1 Training
  NetCom’s private 1-on-1 training focuses on the highest quality training possible. You get individualized, full attention from the instructor and you decide where and when courses are held. The training is custom tailored to reflect your industry, corporate culture, goals and schedule. You pick the course content, length of training and instructional technique.
  Learn more about Private 1-on-1 Training

Call us Toll-free at 1-888-563-8266 FREE Training Inquiry form Website Live Chat Contact us via Email: info@netcomlearning.com