Microsoft Dynamics GP is a powerful accounting system with enhanced report design capabilities that will certainly improve your decision making processes. Microsoft Office and Microsoft Dynamics GP offer what is known as Office Data Connection (ODC), a method to integrate both systems and allow users to view Dynamics GP data in an Excel worksheet. This means, you can view your Microsoft Dynamics GP data in your MS Excel and have it refreshable at any time.

Not only are there more than 200 out of the box Excel reports included in the core system but also users can design and customize Excel reports to meet the individual needs of their businesses. These reports retrieve data from the Dynamics GP SQL database, thus offering real time reporting.

Furthermore, you do not have to be a user in Microsoft Dynamics GP to have the ability to view the Excel reports that come with the system. By using Windows Authentication and setting appropriate permissions for security, anyone in your company will be able to see these reports.

Finally, the default Excel Reports in Dynamics GP are created from the existing SmartList favourites. They are basically Excel files that can be tailored to the user’s needs and provide you with the familiar look and environment of Microsoft Office Excel. In addition, if you need extra customized Excel reports for your business, you can use the Excel Report Builder that comes with the SmartList Builder, though you will have to get a separate license for it.

If you want to learn more about Excel Reporting in Dynamics GP, join our free webinar on February 19, at 11 am EST and find out how to create powerful and easy to read reports.

Doriana Kote, Web Marketing Coordinator, WebSan Solutions Inc., a Channel Elite Awards Winner for 2013

February 12, 2014 by Andrew King, WebSan Solutions, Inc.

Email | Print

Ask The Author

Tags: custom excel reports, dynamicg gp online trainin, excel report builder in gp, Excel reporting, Microsoft Dynamics ERP Training, ms excel
Posted in About Microsoft Dynamics GP | No Comments »

More Posts By Andrew King, WebSan Solutions, Inc.

1. How to Utilize Jet Reports & Jet Hub for Dynamics 365 Business Central
2. Business Central VS. NetSuite: Which Software is Right for Your Business?
3. Can You Implement Dynamics 365 Business Central On Your Own (Customer’s POV)
4. Dynamics GP Migration to Business Central – is now the time?​
5. Support for SQL Server 2008 Is Ending… What Should I Do?

Related Posts

1. Working Smart- Stay Ahead Of The Game With Microsoft Dynamics GP Training
2. Getting The Help You Need: Options for Microsoft Dynamics GP Support And Training
3. Connecticut Companies Invited to Evaluate Microsoft Dynamics GP with 100 Customer References
4. Favorite New Features in Microsoft Dynamics GP 2013 – Short Training Videos Too!
5. A Free Tool for Dynamics GP That Microsoft Excel Users Will Love