About Microsoft Dynamics GP Analytics

You have a lot of valuable data within your business systems. But how do you get it into the hands of the right people to make the best decisions for your company? The greatest value your business solution can provide is the easy transformation of your data into meaningful, valuable information. Microsoft Dynamics GP (formerly Microsoft Great Plains) provides a broad range of flexible, customisable analytics, reporting, and budgeting options to meet your company's needs. From advanced consolidation analysis to the simplest reporting requests. Our applications tap into the most powerful reporting, analysis and budgeting tools available.

Analysis Cubes for Excel

Improve your ability to analyse and report financial data, and share information across your organisation.

Microsoft Dynamics GP Analysis Cubes for Excel include Financial Series cubes such as General Ledger, Accounts Receivables, Accounts Payable, Receivables Ageing, and Bank Reconciliation, so you can begin analysing information immediately.  Receive quick answers to common business concerns such as:

• Sales analysis based on customers, sales territory, salesperson, or General Ledger account
• Total purchases by vendor or account code
• Financial Statements and reports such as profit and loss statements

Using the Excel Pivot Table Generator you can define how to “slice and dice” information from Microsoft Dynamics GP, and the information will be instantly created in Excel for analysis.

Microsoft Dynamics GP Analysis Cubes Library contains Distribution Series cubes for Sale Order Processing, Purchase Order Processing and Inventory and it’s available as an additional module with Microsoft Dynamics GP Professional.  The information you analyse will help you answer questions important to your business success, such as: 

• Which vendors are providing the best prices on a particular item?
• What is our margin percentage by item, by customer, or by salesperson?
• What customers are buying more from us this year more from us this year than last? Which ones are buying less?
• What was our review for the week? Who was the top salesperson? Customer? Product?
  
  

FRx Professional

Microsoft Dynamics FRx Professional View and manage financial information from all angles to gain a complete, detailed understanding of any business situation. Powerful analysis capabilities include the ability to:

• Consolidate information from multiple companies and data sources
• Create reports that compare periods and then set the current base month, quarter, or other financial period at the time you run the report
• Create reporting relationships that need not exist in your chart of accounts, allowing you to change reporting structures without affecting data entry processes
• Seamlessly 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 the general ledger

• A graphical user interface that helps you determine the description and source of data, as well as any calculations and totals in your report
• Tight integration across Microsoft Dynamics GP to facilitate updates and maintenance and reduce the chance of errors
• Customisable and automated process that lets you select when and how each report should be generated and distributed
• The FRx Report Server, which automates the production and distribution of reports in a scalable, high-speed reporting environment

FRx Report Manager

Microsoft Dynamics GP FRx Report Manager allows you to:

• Create personalised report books that organise multiple document types in a single file – including Microsoft FRx reports, Microsoft Office documents, Crystal Reports, and links to sites and other documentation
• Consolidate critical business information into a single file for quick, easy distribution to executives and managers

• Select from multiple delivery methods to share report books, including e-mail print or online posting