Analytics and reporting resources for Microsoft Dynamics GP

**
**

This page includes links to the analytics and reporting documentation resources for Microsoft Dynamics GP. You can right-click the document links and choose Save Target As to save the documents to your computer.

On This Page
Administrator and user guides for Microsoft Dynamics GPAdministrator and user guides for Microsoft Dynamics GP
Administrator and user guides for Business PortalAdministrator and user guides for Business Portal
Related articlesRelated articles

Administrator and user guides for Microsoft Dynamics GP

Name and descriptionDownloadsLast updated

Advanced Financial Analysis
Explains how to create, modify, and format financial statements and reports. You can use Advanced Financial Analysis to modify the Balance Sheet, Profit and Loss Statement, Statement of Retained Earnings, and Statement of Cash Flows, and create custom reports. (82 pp.)

Advanced Financial Analysis (AdvancedFinancialAnalysis.pdf)Download as PDF
1,007 KB

Advanced Financial Analysis (AdvancedFinancialAnalysis.xps)Download as XPS
1,479 KB

January 7, 2007

Analysis Cubes (Microsoft SQL Server 2005)
Explains how to install, set up, and use Analysis Cubes, which you can view and customize to analyze your Microsoft Dynamics GP data. Also describes the dimensions, attributes, and measures of the cubes, and explains how to create Excel worksheets with PivotTable reports using the cubes. (48 pp.)

Analysis Cubes (AnalysisCubes.pdf)Download as PDF
1,070 KB

Analysis Cubes (AnalysisCubes.xps)Download as XPS
1,773 KB

April 17, 2007

Analysis Cubes for Excel (Microsoft SQL Server 2000)
Explains how to install, set up, and use Analysis Cubes for Microsoft Excel, which you can use to generate OLAP cubes to analyze your Microsoft Dynamics GP data. Also includes descriptions of the tables and reference information about the cubes. (88 pp.)

Analysis Cubes for Excel (AnalysisCubesForExcel.pdf)Download as PDF
1,393 KB

Analysis Cubes for Excel (AnalysisCubesForExcel.xps)Download as XPS
2,007 KB

April 24, 2007

Analytical Accounting
Explains how to set up Analytical Accounting, which you can use to create, interpret, and analyze reports based on your company's chart of accounts. Also explains how to enter and use analysis information for transactions. (220 pp.)

Analytical Accounting (AnalyticalAccounting.pdf)Download as PDF
3,486 KB

Analytical Accounting (AnalyticalAccounting.xps)Download as XPS
5,115 KB

April 25, 2007

Enhanced Intrastat
Explains how to set up your system to collect statistics on the trade of goods between countries of the European Union, and to generate Intrastat returns specific to various countries. (48 pp.)

Enhanced Intrastat (EnhancedIntrastat.pdf)Download as PDF
982 KB

Enhanced Intrastat (EnhancedIntrastat.xps)Download as XPS
1,762 KB

April 25, 2007

Report Scheduler
Explains how to set up and use the Report Scheduler to schedule and publish Report Writer reports. Also includes Report Catalog maintenance information. (22 pp.)

Report Scheduler (ReportScheduler.pdf)Download as PDF
523 KB

Report Scheduler (ReportScheduler.xps)Download as XPS
1,115 KB

March 13, 2007

Report Writer User's Guide
Introduces the functions of Report Writer and explains how to complete tasks such as creating calculations and restrictions. Contains reference information, including mathematical functions and variables. (210 pp.)

Report Writer User's Guide (ReportWriter.pdf)Download as PDF
2,319 KB

Report Writer User's Guide (ReportWriter.xps)Download as XPS
2,787 KB

April 13, 2007

SmartList Builder User's Guide
Provides an in-depth understanding of how to create and maintain SmartLists, including security information. (48 pp.)

SmartList Builder User's Guide (SmartListBuilderUsersGuide.pdf)Download as PDF
1,091 KB

SmartList Builder User's Guide (SmartListBuilderUsersGuide.xps)Download as XPS
1,761 KB

April 5, 2007

SQL Server Reporting Services Administrator's Guide
Explains how to install and set up Microsoft SQL Server Reporting Services for use with Microsoft Dynamics GP reports. (37 pp.)

SQL Server Reporting Services Administrator's Guide (ReportingServicesAdminGuide.pdf)Download as PDF
629 KB

SQL Server Reporting Services Administrator's Guide (ReportingServicesAdminGuide.xps)Download as XPS
1,048 KB

March 25, 2008

VAT Daybook
Explains how to set up and use the Value-added Tax Daybook to create VAT reports based on the reporting requirements of the European Union customs agencies. Includes information about additional features for users in Spain, Belgium, and The Netherlands. (72 pp.)

VAT Daybook (VATDaybook.pdf)Download as PDF
1,269 KB

VAT Daybook (VATDaybook.xps)Download as XPS
5,562 KB

April 25, 2007

Working with Crystal Reports
Includes specific procedures for generating reports from Microsoft Dynamics GP using Crystal Reports. Also includes sample reports. (38 pp.)

Note

This guide is not a substitute for the Crystal Reports User's Guide.

Working with Crystal Reports (Crystal.pdf)Download as PDF
713 KB

Working with Crystal Reports (Crystal.xps)Download as XPS
1,398 KB

March 28, 2007

Administrator and user guides for Business Portal

Name and descriptionDownloadsLast updated

Common KPIs Guide
Explains how to create common KPIs, such as your current ratio and gross profit margin. (78 pp.)

Common KPIs Guide (CommonKPIsGuide.pdf)Download as PDF
831 KB

Common KPIs Guide (CommonKPIsGuide.xps)Download as XPS
1,384 KB

March 22, 2007

Key Performance Indicators
Explains how to set up the Key Performance Indicators application, including information about sample KPIs and the Executive Center site. Also describes how to create and administer KPIs and display them to Business Portal users. (130 pp.)

Key Performance Indicators (KeyPerformanceIndicators.pdf)Download as PDF
1,959 KB

Key Performance Indicators (KeyPerformanceIndicators.xps)Download as XPS
2,684 KB

April 3, 2007

Related articles

Name and description

Default SmartList favorites for Microsoft Dynamics GP
Describes the default SmartList favorites that are included in Microsoft Dynamics GP. The SmartList favorites help save you time by allowing you to view the search results or modify them to fit your needs.

Increase productivity with Microsoft Dynamics GP, Office SharePoint Server
Explains how you can use Microsoft Dynamics GP 10.0 with Office SharePoint Server 2007 to create flexible, easily implemented workflows, use advanced searching capabilities, and view collaborated business intelligence information.

Make better decisions: Business intelligence (BI) in Microsoft Dynamics GP
Includes a summary of the business intelligence capabilities included in Microsoft Dynamics GP.

Overview of reporting in Microsoft Dynamics GP
Includes a brief overview of the Report Writer functionality within Microsoft Dynamics GP.



Was this information useful?