But, these days, the GP developers have created many more “user friendly” data views which link the information from several tables together, making it much easier to create reports without being a coding expert. You can find them by going to “Reporting Tools Setup” in GP Dynamics System Setup.
Depending on which version of GP you’re using, your window may look slightly different than mine shown below, but the result is the same. You can deploy the Excel reports from within Dynamics GP to a network path and these reports will have a “hot link” to your GP data. This means that each time you open or refresh a report, it looks at the data and retrieves the information via an “ODC”, or “Office Data Connection.” In other words, the Excel Report looks directly into the linked GP tables and retrieves results.
Here’s where you deploy the Excel reports in Dynamics GP (if you or your partner did not do this while installing or upgrading your system):
These Excel reports in Dynamics GP use your Windows credentials to retrieve data, so here are a few important things to remember:
- You must have the necessary security to run them, meaning you have permissions for the location on the network, as well as SQL permissions for the data.
- You will need to enable the external content from within Excel.
Once you’re setup, you will have a LARGE number of reports to check out. They are organized by GP company, then by module. Here’s an example of the deployed reports. Basically, the system deploys a report for each of the default SmartList favorites it creates upon installation:
Need help with this?
The Dynamics GP reporting experts at Intelligent Technologies, Inc. can help! Whether you need Excel report modifications, assistance with report deployment or setting permissions, we’ve got you covered!
Contact us to get started using Excel reports in Dynamics GP.
