Microsoft Dynamics GP and Excel Reporting Features

Visit Website View Our Posts

One of the best reporting features of Microsoft Dynamics GP is the out of the box  Excel Reports which provide a refreshable data connection to your Dynamics GP data directly from Excel.  A lot of Microsoft Dynamics GP users don’t even know about these reports and they already own them!  Microsoft Dynamics GP users and non-GP users can see information such as open sales orders, master record lists (e.g. Vendors, Customers, Inventory Items), financial information in detail or summary, etc.  These reports are easy to install and can be deployed to a shared network location or to SharePoint. 

Microsoft Dynamics GP users are familiar with using Smartlists with Microsoft Dynamics GP and use the Smartlist reports extensively for exporting data to Excel.  But if users would like to view the spreadsheet at a later time, they need to export the Smartlist favorite to Excel again and again.  With the Microsoft Dynamics GP Excel Reports, a user can open an already existing Excel report, select refresh, and view up to the minute data without having to login to GP. 

Just think about how efficient your team will be when they can access these spreadsheets with Microsoft Dynamics GP data, anytime and without having to purchase another GP license.

If your organization is located in the Arizona or New Mexico area, contact Sherwood Systems for assistance in determining if a technology solution can help your organization better serve your business needs. (877) 943-9696

By Sherwood Systems – Arizona Microsoft Dynamics GP Partner

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons