“As long time users of Dynamics GP, we rely on the stability that GP provides for our accounting and payroll with our stores. As our Microsoft Partner, TMC has always responded quickly and professionally to any of our system problems or needs. With so many stores and employees we know we can rely on Microsoft Dynamics GP and Technology Management Concepts to keep us running smoothly.”

- Cheryl Henderson
Corporate Office Manager

Original Tommy’s Hamburgers
Monrovia, CA

see another client testimonial

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