Archive for January, 2010

25th January
written by Jim M.

So you have purchased and implemented a Dynamics GP ERP solution and it is delivering to you the efficiency and reliability that you had hoped for.  But what about taking your GP solution a step farther?  There are a myriad of technologies and products that when paired with Dynamics GP can provide your company with functionalities that will help you to increase efficiency and cost-savings across the enterprise. 

At Micro Force our entire professional service team’s efforts are devoted to servicing Dynamics GP (formerly Great Plains) users in the New York Metro region.   Each of our team members average over seven years of GP service experience, over 20 years of business experience and has passed Microsoft’s GP certification requirement each year.  But beyond this GP expertise, each member of our team has also become experts in technologies that can enhance your experience with GP. 

Products and technologies such as FRx, Crystal Reports, eConnect automated integration, SQL database administrative services, VBA and GP Dexterity development services and Analysis Cubes reporting for Excel for GP users to name a few.  If you are interested to learn more about these products to see if they can help you achieve your goals now and in the future, Micro Force will be offering a series of Lunch N Learn sessions highlighting a different team members to help you better understand the product they specialize and how it has helped other customers achieve their goals. For the month of February, BI Reporting using Analysis Cubes will be in the spotlight and you can click here to learn more and to register.  In the coming weeks we will be adding additional Lunch N Learns to our schedule and you are encouraged to check back to the Events Page on the Micro Force website for upcoming offerings.

14th January
written by Ed N.

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.

Tags: , ,
13th January
written by Rob C

Recently one of the Micro Force staff was attempting to do a VLookUp using an Excel 2007 file and a file created in an earlier version of Excel.  The VLookUp would not work and we were at a loss as to why.  We soon realized it was a compatibility issue between the Excel 2007 and the older spreadsheet.  Problem solved and steps were taken to complete the VLookUp but I was not done looking into this.

So I checked the Microsoft Office Online site and what I found out was interesting.  As we learned, there is a backwards compatibility issue between Excel 2007 and older versions.  What I also learned is that when opening an excel file from an older version in 2007, you are not alerted by the program that there will be limitations to using the older file as it is automatically opened in ‘Compatibility Mode’.  The only indication that something is different is in that the words Compatibility Mode will appear in brackets after the file name.

Compatibility Mode, as described on the Microsoft Office Online Site, is turned on automatically and unlike other Office programs you cannot turn compatibility mode off or on manually.  Additionally, if you do a help search for ‘Compatibility Mode’ in Excel you will get a laundry list of issues and functionalities that are not available in Compatibility Mode.  The one I could not find was VLookUp, which obviously is also unavailable.  So, if the next time you are working with older excel files in Excel 2007 and something doesn’t work you are working in Compatibility Mode and you have to re-save the old file in 2007 format to complete your task.

Comments Off