Posts Tagged ‘Dynamics GP’

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: , ,
28th October
written by Delfina C.

As more companies expand beyond the US market they learn that little things are important.  But sometimes those little things can grow into big headaches.  Take date formats.  In the US the common format is MM/DD/YYYY but in many other countries the standard is DD/MM/YYYY.  So having employees at subsidiaries in multiple countries accessing the same Dynamics GP system (and who may prefer working with a regionally-specific date formats) and you may have to do some juggling.  Here is how to strike the balance in Dynamics GP.

Let’s say you have 10 US-based subsidiary companies in GP and just added an additional 6 UK-based subsidiary companies to the GP system.  The users at each all log into Dynamics GP through terminal server.  The people in the UK want to see the date in the following format DD/MM/YYYY.  To accomplish this you would have each Non-US user log into Dynamics GP and go to Start > Control Panel > Regional and Language Options.  On the Regional Options tab select the regionally applicable format.  Now, when the UK-based subsidiaries log into GP the date will be displayed in the selected format and for the people in the US-based subsidiaries it will display as MM/DD/YYYY and any reports generated will reflect the date based on the selected format of the person generating the reports.

Comments Off
29th July
written by Karen C

In July the New York State Legislature voted to increase the NYC Local Sales and Use Tax Rate to 4.5% (click on link at the end of this post for the Official PDF).  This rate change will be effective August 1, 2009.

To change the sales tax percentage in your Dynamics GP applicaton, you will need to make the change to the Tax Detail record that is used in the Tax Schedule ID assigned to NYC customers.

Tools >> Setup >> Company >> Tax Details

NYC Tax Fix Scr Shot

Once this is done, any new orders/invoices will use the new rate.

Keep in mind that any existing orders or backorders will not recalculate when you transfer those to invoices. You will need to recalculate those manually.

n09_12 NYC Sales tax 080109