Analytics And Reporting Resources For Microsoft Dynamics GP

Right-click the links and select Save Target As to save any documents you choose.

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.)

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 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.)

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, including non-monetary information. (234 pp.)

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/regions. (52 pp.)

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 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.)

SmartList Builder User's Guide With Excel Report Builder

Provides an in-depth understanding of how to create and maintain SmartLists and use Excel Report Builder, including security information. (79 pp.)

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.)

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. (80 pp.)

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.

Administrator and User Guides for Business Portal

Common KPIs Guide

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

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.)