• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

Software Development Courses   Business Solutions Training Courses

M8400: FRx 6.7 Report Design Essentials II

View course dates

Course Duration: 2 days

Course Code: M8400

Course Description:

The two-day Report Design Essentials II course builds on the basic report design skills learned in Report Design Essentials I. Using Microsoft® Business Solutions for Analytics-FRx® you learn advanced report design including linking to external worksheet data, linking row formats, multi company consolidations, currency translation reporting and cash flow. A combination of instructor guided exercises and practice tutorials allow students to master their report design skills.

 

A thorough understanding of these topics allows you to master the advanced report design techniques necessary to create a more comprehensive suite of financial and management reports. You learn how to use links to extract data from a variety of sources including non-financial metrics maintained outside the general ledger. This course also teaches you how to move into cutting edge technology, using OLAP and XRBL output options. 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 will help you to enable internal and external stakeholders to make well informed decisions to positively impact your organization as a whole.

 

This class is ideal for:

• Intermediate FRx users

• Experienced FRx users who would like to build upon their skills and master product proficiency

• FRx Software product resellers

Prerequisites:

Before attending this course, students must have:

- General knowledge of Microsoft® Windows®
- Basic knowledge of accounting principles
- FRx Report Design Essentials I is strongly encouraged

Prerequisite courses:

M8399: FRx 6.7 Report Design Essentials I

Relevant Certifications:

Microsoft Certified Business Management Solutions Specialist: For Dynamics GP

Microsoft Certified Business Management Solutions Professional: For Dynamics GP

This course includes the following modules:

Overview

• About FRx Software products
• Terminology
• Demo company account structure
• Sample report demonstration

Concept Overview

• Basic Row Format review
• Working with TOTs and CALs in the Row Format
• How C's affect TOT and CAL rows and why to use them
• Defining a sort in the Row Format
• Relating rows to other rows
• Basic Column Layout review
• Defining a favorable/(unfavorable) variance Column Layout
• Working with BASE periods and years in the Column Layout
• Using "Add Reporting Units from Chart of Accounts" to build a Reporting Tree
• Using the split function to isolate a single account mask character
• Creating a new Reporting Catalog
• Defining report headers and footers
• Working with sub-totals in the DrillDown Viewer

Linking to External Worksheets

• Referencing external worksheet data
• Optional row modifiers
• Determining the period of data to be reported on
• Using the combined GL+Worksheet link in the Row Format
• Calculation priority with working with intersecting row and column calculations
• Adding an external worksheet link to the Row Format
• Proper syntax in combined vs. separate linking
• Using the optional row modifiers /CPO and /RPO when referencing worksheet data
• Designing Column Layouts that report on either/or data (i.e. either Actual or Budget) depending on the report date

Gross Profit per Unit - Practice

• Defining the GL+Worksheet link
• Working with the /CPO and /RPO row modifiers
• Using account and book code modifiers
• Advanced calculations and non-printing rows

Full Account Code & Multiple Segments

• Defining a fully qualified account in the Row Format
• How a full account in the Row Format affects units in a Reporting Tree
• Defining a range of periods in the Column Layout
• Using conditional dates in the Column Layout
• Using a range in a calculated column in the Column Layout

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course