Thanks to www.msdynamicsworld.com I found a very helpful blog post by gp2themax about a great way to use Excel Reports in Microsoft Dynamics GP. He writes: "Did you know that, beginning with GP10, GP ships with approximately 200 pre-defined Excel Reports that can be accessed by GP users and non-GP users alike? The reports are basically the same as the canned SmartLists... However, the major differences between these reports and SmartLists is that Excel Reports open directly in Excel, without having to run a SmartList and then export it, and these reports can be run by anyone who has an ODC (Office Data Connection) which means that anyone who has MS Excel 2007 or newer on their computer, and the necessary SQL security rights, can run these reports without logging in to GP!” And here is my favorite part, “For instance, this is perfect for setting up auditors with access to GP transaction data without the need for using a GP login."
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.