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 fromMicrosoft 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

Create sophisticated reports easily and intuitively and define distribution methods for reports to efficiently and effectively address your organisation’s business needs. Microsoft Dynamics FRx Professional functionality includes:

  • 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

We understand your organisation is unique. Your technology should match your business processes - your unique way of doing things. We help your organisation perform better by designing and developing the solutions that work for you - all delivered on time, within budget and with faster time to benefit. With offices in Sydney, Melbourne, Brisbane, Perth and with over 50 Awards received from Microsoft, SAP, Sage and Accellos, MicroChannel has outstanding credentials as one of the most respected solution providers in Australia.

Superior Solutions | Dependable Service | Measurable Value | Committed People