User Profile

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.

Read more...
2 Comments

Read more...
2 Comments

Category: System (90)

STATUS DETAILS
Declined

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.

Read more...
0 Comments

Read more...
0 Comments

Category: System (90)

STATUS DETAILS
Declined

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

Read more...
1 Comments

Read more...
1 Comments

Category: System (90)

STATUS DETAILS
Declined

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

Read more...
3 Comments

Read more...
3 Comments

Category: System (90)

STATUS DETAILS
Declined

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

Read more...
1 Comments

Read more...
1 Comments

Category: Financials - Accounts Payable (119)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Business Intelligence (12)

STATUS DETAILS
Under Review

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

Read more...
1 Comments

Read more...
1 Comments

Category: System (90)

STATUS DETAILS
Under Review

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

Read more...
0 Comments

Read more...
0 Comments

Category: Business Intelligence - SmartList (28)

STATUS DETAILS
Declined

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

Read more...
0 Comments

Read more...
0 Comments

Category: Business Intelligence - SmartList (28)

STATUS DETAILS
Needs Votes

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

Read more...
0 Comments

Read more...
0 Comments

Category: Platform - Performance (7)

STATUS DETAILS
Needs Votes