Making Excel Work for You in Dynamics GP v.10

Dynamics Great Plains v.10 came out with a brand new reporting tool called Excel Refreshable Reports. The new refresh feature in these Excel Reports uses what is known as a data connection to fetch a specific set of data from Microsoft SQL Server. With a click of a button, Dynamics GP data is easily accessible from within Excel, giving real-time access to data. The pre-built data connection is configured to refresh Excel data each time the Excel Report is opened.

You can configure the Excel Report to automatically refresh data from GP each time it is opened by clicking Refresh All -> Connection Properties. The Connection Properties window will open. Select “Refresh data when opening file”. This will automatically refresh external data when the Excel workbook is opened.

Refresh your data on demand

Properties of a Data Connection

There are about 200 pre-built Excel Reports classified into different Series (Financial, Sales, Purchasing, etc. – screenshot below shows a list of pre-defined modules).

Folders of Excel Reports in Dynamics GP

Tags: Dynamics GP Data Connections, Dynamics GP Excel Reports, Microsoft Dynamics GP

View Posts by Tag

Annual convention business portal Buy Dynamics Buy Dynamics GP Buy Great Plains Cash For QuickBooks discount on dynamics gp Dynamics GP Dynamics GP 2010 Dynamics GP Partner Dynamics GP Pricing Dynamics GP Project dynamics gp training Dynamics NAV ERP Financial Management Goodwill of Orange County gp 2010 Great Plains Great Plains Consulting Great Plains Training Microsofdt Dynamics Gold Competency microsoft Microsoft Dynamics Microsoft Dynamics GP Microsoft Dynamics GP Distribution Microsoft Dynamics GP Financials Microsoft Dynamics GP in Los Angeles Microsoft Dynamics NAV Microsoft Great Plains NAV NetSuite NetSuite partner QuickBooks vs Dynamics GP QuickBooks vs Dynamics GP Features San Francisco smartlist Technology Management Concepts TMC TMC Blog TMC News user conference volunteer volunteer event volunteering