Replace CHAR Data Type with VARCHAR
Dynamics GP stores text fields using the CHAR data type. This pads the value with spaces. CHAR wastes space and introduces problems with custom reporting. We have to add RTRIM to custom queries to get rid of the extra spaces. Please consider converting to using VARCHAR for text fields.
DATETIME > DATE, TIME, DATETIME2
The DATETIME SQL data type is deprecated. Please look into replacing use of DATETIME with DATE, TIME or DATETIME2, as applicable.
Replace checklinks with SQL Foreign Keys
Checklinks is a symptom of a problem that need not exist, and likely a holdover from the application's past. Now that only Microsoft SQL Server is supported as a database backend, there are powerful features available that weren't when multiple database backends were supported. Please define ...
Native PDF Support
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....
Fix PM Historical Aged Trial Balance (HATB) Performance
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 lat...
Remove NOLOCK Nolock From Report Code
A user brought a situation to my attention. The Payables Historical Aged Trial Balance he ran at 12:09.05 PM was off by $6,000. When he ran the report again at 1:08 PM it was correct. It looks like an invoice from Feb 2019, an invoice that is in history, was left off the report. With the in...
Deletes a User's SmartList Favorites When Access to a Company is Removed
I recently received a report from a user that his SmartList favorites were missing. Online searching led to a possible explanation from 2015 about Dynamics GP 2013 R2. "Did you remove a user's access to a particular company in GP? If so, this process removes their Smartlist favorites across all...
SmartList Increase Performance
SmartList is a great tool, but really slow to load results. The rows seem to load one by one and users slowly watch the row count increase until the row limit is released. SQL can return thousands of rows in a second, and it is possible to load a Window grid control just as quickly. Dynamic...
SmartList Designer GoTos
Please add the ability to create GoTos in SmartList Designer. This was a very nice feature in the old SmartList Builder that allowed designers to create convenient and relevant links from the SmartList
Improve Login Speed by Improving Efficiency of "Updating Menus"
After a user signs in to GP, it appears the application is ready, but it is really not. If the user changes to a module page, he or she will see many items on the page that are not applicable and not really available. If the user tries to switch companies, a message will be displayed that it...