Software Information

Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators

How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:

  • Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'.
  • Pervasive SQL/Ctree - if you have more than one user registered you can delete the user from GP: System->User Activity->Delete User. If you like to work on the file level - ask all the users to log off. On the server, where you have your Great Plains files structure - DYNAMICS is the root, in SYSTEM folder delete ACTIVITY.* files

How to unlock the batch? This happens when user posts the batch and has her computer crashed (via surfing the internet - smile - or things like this)

  • General tip - Great Plains recommends to logoff and then login back with the same user id. Then Great Plains will prompt the user to recover posting batch. Unfortunately it doesn't work in 70% of the cases
  • MS SQL Server - the batch record is stored in Batch Header table: SY00500 in the company database. The fields to clear are: BCHSTTUS and MKDTOPST. In some cases you have to delete the record from SY00800 from DYNAMICS db.
  • Pervasive/ctree - you have to install ODBC driver for Pervasive or Ctree and hook the tables: SY00500, SY00800 with Microsoft Access - use linked tables technique

Now we would like to stress you the need to move away from Pervasive SQL 2000/Ctree platforms - you are in trouble - Microsoft Business Solutions cuts technical support for Microsoft Great Plains 7.5 and prior on these platforms. This means not only the support, but also tax updates (especially Payroll and Federal Magnetic Media).

What is migration from Ctree/Pervasive.SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to install Great Plains on SQL Server with exactly the same account/segments structure and then install migration tool (it is Dexterity chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to target SQL-based Great Plains Company, select all system and company tables, click the button and it will move all your tables one-by-one. In the case when your Great Plains ctree/Pervasive has third parties - you need to check if the vendor has migration tool - otherwise you have to do manual move, use SQL Linked server to your legacy data

Do I need consultant? It is probably good idea to have consultant to do the upgrade. We strongly recommend you to use consultant in the following cases

  • You have Dexterity customization
  • You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
  • You have a lot or ReportWriter Modified Great Plains Reports
  • You have old version of Great Plains: Dynamics or eEnteroprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
  • Your Great Plains has more than 20 users and you have to have upgrade done over the weekend - if it fails - you have business problems
  • You don't have support - in this case you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade

Good luck in fixing and if you have issues or concerns - we are here to help! If you want us to do the job - give us a call 1-866-528-0577!

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (, he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

You can contact Andrew:



Do You Know Where Your Software-Defined Everything Is?
Life inside the datacenter is increasingly dynamic. Now a microcosm of data life in its own right, the rise of software-defined everything (increasingly written as SDX) means we start using terms like 'server-side' more often. These are the mechanical ...

and more »


An International Arms Pact Could Criminalize Legit Software
The international arms pact known as the Wassenaar Arrangement was designed to control the spread of potentially dangerous hardware and tech to repressive regimes. But when it was amended in December 2013 to include surveillance software, security ...

and more »


Medfusion Lands $3M for Patient-Focused Software Push
There's a lot of talk in the health IT space about getting patients actively engaged in health care, and a lot of companies are trying to do it through mobile apps. Medfusion, a health software company that already has a nationwide customer base of ...

and more »

The Fiscal Times

New SAP software aims to help companies make sense of data deluge
The Fiscal Times
TUEBINGEN (Reuters) - SAP unveiled a new product on Tuesday that promises to help businesses make sense of a deluge of real-world data from retail transactions, transport systems and social media, hoping to persuade customers to switch from rival ...

and more »

Verona health care software company's annual gathering is epic
Milwaukee Journal Sentinel
The event drew almost 9,000 people this year, and the company's 11,400-seat auditorium was full on Tuesday morning for an overview on the company's software for electronic health records and what's ahead. The event, which requires busing in people from ...

and more »


​VMware wants to create the software-defined data center: Now
VMware would like to see traditional data centers replaced by software-defined data-centers. Don't start shorting your Intel, Cisco, and EMC stock quite yet. VMware knows darn well that hardware is still an essential part of the data center and the cloud.
VMware announces EVO SDDC software suite with SDDC Manager, Hardware ...VentureBeat
SDDC Market: 30.98% CAGR for Software Defined Data Center Market Forecast to 2019PR Newswire (press release)
VMware's got just one more thing you need to build a software-defined data centerThe Register
Top Tech News
all 46 news articles »

PetaPixel (blog)

RIP VSCO Keys: The Keyboard Shortcut Software Has Been Discontinued
PetaPixel (blog)
Back in 2012, VSCO branched out its software offerings by announcing VSCO Keys, a keyboard shortcut software that helps photographers speed up their Lightroom workflow. If you're a fan and user of Keys, there's some bad news for you: it is now ...

and more »

IT Business Edge

The Evolution of Business Software: Focus on the Consumer
IT Business Edge
In the past decade, business software usage has evolved in a number of ways to meet the changing needs of organizations in the digital age. From how software is delivered to how it is installed and used, the concept of business software is being ...

RCR Wireless News

Ericsson software unlocks indoor performance for the mobile era
Ericsson Networks Software 16A includes two uplink enhancements that will enable mobile operators to utilize 64 Quadrature Amplitude Modulation (QAM) on uplink to provide 50-percent better peak speeds of 75 Mbps. In addition, it enables uplink carrier ...
Ericsson's new network software update to pave the road for LTE-U deploymentsFierceWireless
Ericsson To Introduce Software Upgrades To Accelerate Uptake Of IoT ApplicationsNasdaq
Ericsson releases IoT Networks Software upgradeTelecompaper (subscription)

all 38 news articles »

Naples Daily News

Naples-based ASG Software Solutions taps new CEO
Naples Daily News
His previous jobs include working as a chief financial officer at Vignette Corp., a publicly-traded provider of enterprise content management software, and as a principal in the investment banking group at Morgan Stanley, specializing in the software, ...
ASG Software Solutions Announces New President and CEOBusiness Wire (press release)

all 3 news articles »

Google News

home | site map
© 2006