Microsoft Dynamics GP Capabilities Guide 2015.pdf

Microsoft Dynamics GP Business Intelligence Features

Role-tailored information:

  • Microsoft Dynamics GP features personalised dashboards and KPIs (including charts, graphs, and gauges) with full drill-down views to record source
  • Library of over 90 built-in Microsoft SQL Server Reporting Services and 220 Excel reports – helping users present information targeted at specific audiences
  • Integrated SharePoint technology – Access data residing in Dynamics GP through Microsoft SharePoint allowing non-core GP users to access and share key data and reports

Extended Information Access:

  • SQL Server Reporting Services Reports deployed to SharePoint Server makes for a centralised Web-based source for viewing consolidated resources
  • Easy to use Action Panes and List Pages – connect multiple data sources (e.g. from ISV applications or custom fields)
  • Enhanced Web Services enable tailored information access and delivery to meet specific user and business needs such as connecting to a website or other external systems
  • SQL Server Views – simplified data retrieval and report creation: easily create custom SQL Server views linking data from Microsoft Dynamics GP, ISV applications or other external systems.

Enquiries & Reporting with now even tighter integration to Excel

  • Business Alerts – automatic notifications about business (database level) changes via e-mail or via Dynamics GP. For example, change of supplier bank account details.
  • SmartLists - a simple but powerful reporting tool enabling users to instantly create sophisticated queries to report on data held throughout Dynamics GP including customers, suppliers, inventory items,employee records, general ledger accounts or transactional data.
  • SmartList Builder - build customised SmartLists that quickly link to Dynamics GP and other data sources.
  • SQL Server Report Builder - easily create new reports or modify the chart, key performance indicator, and report formats included in Dynamics GP, without the need for developer or I.T. resource assistance.
  • Excel Report Builder - create refreshable Excel reports from multiple sources of data, including ISV and custom applications, as well as data from multiple companies, with the ability to filter for selected companies.
  • Over 220 built-in Excel reports -refreshed with a single click and accessed via Dynamics GP, a network file share, or a SharePoint Server site.
  • PivotTable views and automatic report totals (generated with Excel Report Builder).
  • Drill Down Builder - quickly define drill-down location in Dynamics GP, and then embed the field into Word documents, Outlook e-mail messages, Excel and SQL Server Reporting Services reports, and SharePoint pages – makes it easier to retrieve and share data from any module, window, or ISV application.


Customer centre

"M4 has provided us with an excellent service from day one. The successful completion of a second, very high profile project has only increased their credibility within the business..."
Natasha Towns
Business Applications Manager,
Logicalis UK

News & events


Cloud & Online services

Spend less time managing systems and more time growing your business with a cloud solution.