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

Read more...
1 Comments

Category: System (60)

STATUS DETAILS
Under Review

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 (60)

STATUS DETAILS
Under Review

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 (60)

STATUS DETAILS
Declined

Resume Active Development of Management Reporter


Once receiving cumulative updates on a quarterly basis, now the most recent update for Management Reporter is from Feb 2017 (over 1 year ago). The messaging on the status of Management Reporter has been confusing, but it does appear that development has mostly ceased. Please reverse course on ...

Read more...
5 Comments

Read more...
5 Comments

Category: Business Intelligence (12)

STATUS DETAILS
Under Review

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

Read more...
2 Comments

Category: System (60)

STATUS DETAILS
Under Review

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 (75)

STATUS DETAILS
Under Review

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

Fix Bug That 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...
0 Comments

Read more...
0 Comments

Category: System (60)

STATUS DETAILS
Under Review