Microsoft Dynamics vendors provide comparisons and opinions to professionals in the ERP/Accounting software selection process

 
 

December 31, 2009 by

Comments Off on How To Give Auditors Access To Your Dynamics GP ERP System Without Buying An Extra License

This star rating of the post below was determined by two factors: how many times the post was read, and by how engaging the post was as measured 'by time on page' metrics from Google Analytics.

Anya Ciecierski, CAL Business Solutions

How To Give Auditors Access To Your Dynamics GP ERP System Without Buying An Extra License


Email | Print

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

I often talk to clients who are a frazzled mess because “the auditors are here.”   So I think that any tip that can help you make the auditor's life easier will also make your life easier.  Thanks Frank!  Excel Reports are a great reason to consider using Microsoft Dynamics GP.  The integration between Microsoft Dynamics GP and Microsoft Office is excellent and continues to improve with each release. (Microsoft Dynamics GP version 11 highlights).  To learn more check out this white paper: Microsoft Dynamics GP & Microsoft Office 2007: Built to Work Together.

By CAL Business Solutions, Connecticut Microsoft Dynamics GP Partner

December 31, 2009 by

Email | Print
Anya Ciecierski, CAL Business Solutions

Ask The Author

Tags: , , ,
Posted in About Microsoft Dynamics GP, Finance Department Tips & Tricks | Comments Off on How To Give Auditors Access To Your Dynamics GP ERP System Without Buying An Extra License

More Posts By Anya Ciecierski, CAL Business Solutions

  1. A Brief History of ERP Software Including Dynamics GP and Acumatica
  2. How One Distribution Company Grew Without Adding Staff Thanks to Microsoft Dynamics GP with SalesPad
  3. 3 Options For Remote Access to Microsoft Dynamics GP During COVID19
  4. Can Choosing the Right Partner for Your Financial Management System Really Make a Difference?
  5. Could Microsoft Dynamics GP Help YOUR Company Eliminate Data Entry and Overpayments?

Related Posts

  1. 1 Million Transactions in Microsoft Dynamics GP? No Problem!
  2. Why Some Companies Don’t Like Using Microsoft Dynamics GP
  3. Dynamics GP Makes Reports “Excel lent”
  4. Microsoft Distribution Expert Offers Advice On Effective ERP for Distributors
  5. What is Microsoft SQL Server Reporting Services (SSRS) and What Can It Do For You?

Comments are closed.