Dynamics GP

Why oh WHY do I have to resize the print preview window every time I run a report to the screen?  This seems like a simple fix and would save 1000's of click and drags... maybe even every day! :)

Both reference and distribution reference fields in GP's GL can only handle a maximum of 30 characters. I understand why these fields were kept relatively small when the product was developed in the early 90's, but 25 years later my customers expect a little more space to write descriptive information. I suggest 50-100 characters would be more appropriate and certainly more useful.

NOTE: I have the same suggestion for the "Description" field on the Payables Transaction Entry window (also 30 char max), and probably many other fields in GP, but the GL ones seem to be the biggest problem for my customers.

Have both clients work with 64-bit Outlook instead of having to depend on the wonky and completly inadequate GP mail client.  A lot of email capabilities related to the contacts and formatting is lost.  

May I suggest making GP a 64-bit program if it will help.  If a solution is not doable please stop promising that GP is compatible with 64-bit Office.

Issue: Check links and reconcile takes far too long to run

If the business logic were pulled out of dexterity and these were re-implemented in SQL using set based operations, this would transform a very painful aspect of running GP on large databases. 

Once in SQL it could be scheduled from SQL jobs and results emailed via SQL for those of us with those skills. This would address the issue of unattended scheduling of these tasks which is another suggestion. 

Even if just the key three pilars of SOP/POP/IV modules were addressed, I'm certain an operation that currenly takes more than a weekend duration to run (currently), would be reduced into minutes. 

In order to generate PDFs from Dynamics GP, Adobe Acrobat Pro must be installed. It's expensive, and an administrative hassle, to have to license this for users just to be able to print and email PDFs from Dynamics GP. Microsoft Word has had the ability to natively generate PDFs for years now. Additionally, Windows 10/Server 2016 comes with a Microsoft PDF printer out of the box. Please either implement native support for PDFs in the GP code or enable support for generating PDFs using the Windows 10 "Microsoft Print to PDF" printer so that the dependency on Adobe Acrobat can be eliminated.

The ability to get GP to run a check links and reconcile automatically via a schedule would transform the admin of larger sites. 

I would love to reconcile our SOP and POP each night and IV over weekends, automatically and have the resulting reports written to a directory for me to review. Even if it meant passing params to GP application via windows scheduler or having another application to run on the server. Alternatively hooks into these processes for GP Addin would help.

This is a hidden pain of GP admin currently. 

This also relates but not depends on another suggestion, of moving the reconcile and check links into SQL for easier management. 

When we implemented Dynamics GP, the accounting team selected the Payables Historical Aged Trial Balance (HATB) report as one to run at month end. They really like being able to run the report as of the last day of the prior month after all the payments have been recorded. 10 years of data later and the report is taking forever to run. When I tested recently, it took 9 minutes. If I run the "Steve Gray" version of PM HATB, it completes in 6 seconds. I looked into the stored procedures behind the report, pmHistoricalAgedTrialBalance and pmPrintHATBGetDocuments, and they use multiple nested loops and dynamic SQL, techniques known to be harmful to SQL performance. Please refactor how the report is calculated to use SQL coding best practices so that large data sets no longer decimate the performance..

Add the ability to use the web client in more than one tab in the browser, at the same time.