What Reporting tools run with Microsoft Dynamics GP?

---

Dynamics GP Standard Reports

As with many other ERP systems, GP comes with hundreds of standard reports. This will typically be your first place to look for typical business information. While many these reports may be useful for some purposes, others will not quite give you what you are looking for. The benefit Dynamics GP offers for those who need information above and beyond what the standard reports provide is where Dynamics GP really starts to shine.

Dynamics GP Inquiry Windows

Inquiry screens are often the first place to look for ‘ad hoc’ information. For example, you may want to examine in detail a specific transaction in the system, review its contents and trace its origin.

Inquiry windows are a great place to find this information within Microsoft Dynamics GP because it is ‘live’ and interactive. You can select the records you want to view and specify the order for displaying the records. You can scroll and drill down. For example, in the General Ledger Detail Inquiry window, you can see a range of General Ledger accounts and then select one to view information about it.

Microsoft Management Reporter (Replacing FRx in GP 2010)

Microsoft Management Reporter is the primary financial performance management tool for Microsoft Dynamics GP. It is used to manage and distribute financial reports. Reports built using Microsoft Management Reporter would include Balance Sheets, Income Statements, Statement of Cash Flows, budget versus actual reports, or any other financial report that includes dollar amounts and other values pulled from the General Ledger.

The key to flexibility in Microsoft MR is an easy-to-use system of three basic building blocks: row format, column layouts, and reporting trees. Users can define these building blocks to meet specific needs. Reporting trees are a hierarchical layout of your organization to build your organizational and reporting structures.

A powerful auto-build function constructs reporting trees directly from your chart of accounts. Drag-and-drop functionality makes it easy to create alternative structures and multiple rollups of various accounts to analyze your organization different ways.

In addition, the Microsoft DrillDown Viewer enables users to drill down into the different parts of the organization represented in the reporting tree; for example, you can drill down into unique account balances that make up the summary totals and into the detailed transactions and documents that provide all the necessary data.

Custom fonts, formatting, and formulas make generating professional, boardroom-quality appearance reports simple and consistent.