8816 Inventory Control in Microsoft Dynamics GP 10.0

Displaying courses for United States [Change]


This course builds on basic report design skills. Using Microsoft FRx you learn advanced report design including linking to external worksheet data, linking row formats, multi company consolidations, currency translation reporting and cash flow.


After completing this course, students will be able to:
  • Have a renewed understanding of basic Microsoft FRx report design concepts
  • Explore ways to efficiently create and distribute many financial report designs including:
    • Trial balances
    • Reports linking to external worksheet data
    • Statements of Cash Flow
    • Reports using full accounts or multiple GL segments
    • 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


Intermediate Microsoft FRx usersExperienced Microsoft FRx users who would like to build upon their skills and master product proficiencyFRx Software Corporation product resellers and consultants


Relational Reporting

  • Defining the CBR or Base Row(s)
  • Defining Column Layout calculations that work with CBR in the Row Format
  • Using Reporting Unit restrictions in the Row Format vs. full account codes to restrict the data being reported on
  • Using Reporting Unit restrictions in the Column Layout vs. Account Filters to restrict the data being reported on

Effective Dates

  • Using save as to create multiple Column Layouts with simple updates to each
  • Defining effective dates in the catalog

What is Wrong?

  • IF/THEN/ELSE calculations in the Row Format
  • IF/THEN/ELSE calculations related to Reporting Tree Units
  • IF ABS (absolute value) calculations in the Column Layout

Additional Formatting Concepts

  • Using column Z (Additional Text) in the Reporting Tree
  • Working with Excel or Microsoft( Office Word( and Microsoft FRx
  • Defining International Formats


  • Overview of multiple company consolidations in Microsoft FRx
  • How to format amounts
  • Assigning an international format to a report
  • When is a Reporting Tree required
  • Side-by-side (consolidating) Column Layout design
  • Linking to external worksheet data

OLAP Output

  • Microsoft FRx and OLAP
  • Microsoft Local Cubes
  • Microsoft Server Cubes
  • Excel Pivot Chart and Excel Pivot Table output options
  • Terminology in OLAP and Microsoft FRx


  • XBRL Overview
  • Adding an XBRL link and related taxonomy file
  • Assigning XBRL tags
  • The XBRL Instance Document output option

Currency Translation

  • Using an external worksheet link to pull in translation rates
  • Adding CTA (cumulative translation adjustment) to the Row Format
  • Using column restrictions in the Column Layout to define formatting
  • Defining the DAX rates path
  • Activating DAX in the Catalog and Column Layout
  • Assigning currency conversion format codes and related rate IDs

Training provider

Teaching mode: Classroom - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft Dynamics GP
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Microsoft Office
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Windows Server
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Online analytical processing
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.