Issues & Fixes
In are recent post at ERPSoftwareBlog, Micro Force addressed the pending 1099 reporting requirement nightmare that exists in the recently approved health care legislation. In the event the new congress does not take issue with this disaster in the making, small and medium business owners will find the perfect cure to this insomnia-inducing legislation with a Microsoft Dynamics GP solution with some fantastic GP-related ISV products.
While working on a recent new install of GP 10 I came across a quirk when attempting to export a budget sheet to Excel. Initially it looked like the export was not working but what was really happening was that the ‘Save As’ window was behind the GP windows on the PC desktop. Although this was submitted as a bug to Microsoft Dynamics Support it was rejected as the work around was simple. And it was! To get around this little quirk:
- Use Alt+Tab until you find MS Excel with Save As title
- Use Windows key + D
- Right-click on task bar>>Show Desktop
Pretty easy. A further check with support to see if a correction was planned for a future service pack as a correction was not in the recently released Service Pack 5. We were informed that as the quirk is still not recognized as a bug by Microsoft so it would not be addressed with a fix in any future service packs. On the upside, it looks like the issue has been resolved for GP2010.
When Microsoft acquired Great Plains in the early part of this decade, they made the move to replace the commonly used database, Pervasive SQL, to the MSDE platform. At the time, the MSDE database made sense and allowed Microsoft to easily phase out the Pervasive SQL platform. Now, for users who are still on the MSDE platform, what was once free and easy is now a ticking time bomb that needs to be defused.
As a platform, the MSDE or Microsoft SQL Desktop Engine, had restrictions on it that will cause issues for any company that has grown since it first installed the Great Plains/MSDE solution. These limitations are:
- Support of up to 2GB of RAM
- 2GB database size limit
- 5 concurrent users or less
- Support for up to 2 CPU on a Windows NT or Windows 2000 server
- No publishing for transaction replication
- No Database Server Failover Support
- No full-text search
- No GUI interface
- No OLAP
- No English Query
- No SQL books online
Additionally, this version has been discontinued and will soon be no longer supported. As SQL is a backend server, those customers that purchased this licensing probably do not realize the serious issues that could affect their ERP application. The bottom line is that if your Dynamics GP solution is using this database you should make all necessary arrangements to upgrade and move off of this platform.
Whether you are a current customer of Micro Force or not, we are available to check your system to see if you are on the MSDE platform and if so we can migrate you to a more stable platform.