Microsoft FRx in Microsoft Dynamics GP

Gain control of your financial reporting process with Microsoft FRx in Microsoft Dynamics GP. Advanced performance capabilities give you comprehensive, highly customisable financial
and management reports that are easy to create, distribute, and use.

Microsoft FRx Factsheet

Accounting intelligence
Get your people and your business working more effectively. Microsoft FRx helps users understand fiscal periods, chart of accounts structures, transaction details, and various types of balances. A built-in link to the general ledger helps your staff run reports based on predefined accounting information. In addition, accounting features and intelligence simplify processes by recognising concepts such as current and year-to-date amounts, debit versus credit balances, and posted or unposted transactions. This helps ensure that every report is complete and accurate.

Flexibility trio: Provide better management information. Microsoft FRx offers a powerful and flexible system of three building blocks: Row Format, Column Layout, and Reporting Trees. Once created, these building blocks can be saved and mixed and matched in other reports.

• Row Format: Specify the data source and what you want to do within each row of a report. By using a link to the general ledger, your staff can select individual or a range of accounts or a list of discontinuous accounts to be included in a report.

• Column Layout: Specify the data source and select the column type. Combined with Row Format, Column Layout makes it easy for users to include period actuals, budget data, statistical amounts, and other types of data in a report, either from the general ledger or from other data sources such as a spreadsheet. Users also can apply calculations across columns, making it easy to include variances, projections, and percentages in reports.

• Reporting Trees: Create a hierarchical picture of your organisation. A powerful auto-build function constructs Reporting Trees in seconds - directly from your chart of accounts. Easy drag-and-drop functionality enables users to create alternative structures and multiple rollups of various accounts without having to make modifications to the general ledger or chart of accounts.

Customisable reports: Use out-of-the-box customisable report templates or start from scratch using the building-block approach and auto-build functionality. Customised fonts, formatting, and formulas stay with the report when it is exported from Microsoft FRx to other formats (such as Excel), so the report doesn’t lose its presentation quality and functionality.

FRx Report Designer: Create, generate, view, distribute, and manage financial reports from your desktop without additional help from your information technology (IT) department. FRx Report Designer gives your staff simple point-and-click capabilities that improve report analysis and access. Export your reports into popular formats, such as Excel, a Microsoft OLAP (online analytical processing) cube, HTML, or an ASCII text file. You can also publish reports created in Microsoft FRx as an Extensible Business Reporting Language (XBRL) instance document without having to understand XBRL or Extensible Markup Language (XML) technology.

FRx Report Launcher: Give your people access to the right information at the right time. Select pre-designed reports, specify the output option, and generate needed reports on demand. FRx Report Launcher helps financial professionals and executives generate, view, and drill down to transaction details while maintaining the integrity of the original report design.

FRx DrillDown Viewer: Receive attractive, easy-to-understand reports that make it simple to analyse performance by company, individual departments, or divisions, or against goals and budgets. With FRx DrillDown Viewer, your staff can immediately answer their own questions by “drilling down” to underlying detail.

Importing and exporting data: Combine spreadsheet contents with general ledger data in a single report. With Microsoft FRx, you can automatically export financial data from a finished FRx DrillDown Viewer report into a spreadsheet for additional what-if analysis while keeping formulas and underlying detail intact.

XBRL: Microsoft FRx remains at the forefront of XBRL technology advances with support of the version 2.0 specification. Users can transfer complex, highly confidential corporate financial information to regulators, banks, investors, and boards of directors, using a trusted standard of financial communication.

Features

Custom Report Design - Employ a building-block approach to design reports. Define the rows and columns that will appear in each report and reporting tree to establish the relationship between reporting units.

Familiar Spreadsheet Interface - Create financial statements easily by leveraging a familiar spreadsheet interface and tight integration with the Microsoft Dynamics GP General Ledger and database structure.

Top-Level Report Analysis - Achieve superior report analysis by consolidating information from multiple companies and data sources, including unposted transactions or base-period referencing, or by creating custom report relationships.

Sophisticated Calculations - Implement mathematics and if/then logic to incorporate reusable complex calculations into your reports.

Report Relationship Customisation - Create new reporting relationships by changing the reporting tree structure, without affecting data entry processes or rearranging account segments in the General Ledger.

Currency Translation Support - Smoothly translate currency across multiple accounting systems, including functionality for calculating monthly and annual average and historical rates and quickly set up currency exchange rate tables with information pulled from General Ledger.

Bottom-Level Report Analysis - Analyse information from summary all the way down to transaction details with Microsoft FRx DrillDown Viewer.

Multiple Report Formats - View reports on the screen and drill down to underlying data. Print reports for presentations, e-mail them for easy distribution, or export
them to spreadsheets for additional analysis.

Web-Based Reports - Publish, store, and manage reports through your intranet while maintaining full drill-down and printing functionality.

Comprehensive Report Books - Organise multiple document types in a single file, including Microsoft FRx reports, Microsoft Office documents, and Microsoft SQL Server Reporting Services reports.

Custom Security Settings - Set security by reporting tree level to ensure that information is accessed only by users that have the right permission settings.

Automated Report Delivery and Production - Use Microsoft FRx Report Server to automate the production and distribution of reports in a scalable, high-speed reporting environment.

XBRL Support - Create and publish reports that meet the business and financial data communication standards of extensible business reporting language (XBRL).

Benefits

Build custom reports
Generate reports using a building-block approach that facilitates easy design and maintenance and helps ensure that each report communicates the right information.

Improve information analysis
Export Microsoft FRx reports to Microsoft Office Excel PivotTable and PivotChart formats to analyse information more effectively.

Simplify the report building process
Benefit from the familiar spreadsheet look and feel and allow anyone with the appropriate privileges to create customised reports quickly.

Maintain reports smoothly
Eliminate time-consuming processes for updating and maintaining reports through tight integration with Microsoft Dynamics GP.

Enhance corporate communications and collaboration
Use multiple report formats and distribution techniques to help ensure that the right financial information is being delivered to the right people.

Access reports securely
Establish custom security settings to help ensure that information is accessed only by users with secured rights.