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:


Vista Equity Partners to Pay $1.1 Billion for British Software Maker
New York Times
Advanced Computer Software provides patient management software to health care providers, back-office systems for businesses and outsourced information technology services. It posted revenue of £203.2 million in fiscal year 2014, which ended in ...
Vista Equity Partners snaps up Advanced Computer SoftwareFinancial Times
Advanced Computer Software agrees to £725m takeover by
Vista Equity Partners' Air Bidco To Buy Advanced Computer Software For 140p/shrRTT News

all 16 news articles »

Veedersburg considers mapping software for town
Danville Commercial News
VEEDERSBURG, Ind. — Town council members received a brief presentation Tuesday from Ken Denlow, the local representative of Beehive Industries of Lincoln, Neb.. Beehive software is based on mapping a town infrastructure including water lines, sewer ...

How Do You Make Money From Free Software?
Free software—truly free software—is undoubtedly a good thing. But given the rest of the world still uses that pesky stuff called money, how on Earth do you make a living from spending your time giving away software for nothing? In this video Matt ...

Software company execs charged with fraud, theft
Colorado Securities Commissioner Gerald Rome said Wednesday that Chisan Chong, of Aurora, and Steven Linnenkamp, of Castle Rock, promised that Direction Labs' "Second Sight" software takes "all the guesswork" out of making trades, was "bulletproof" ...
Men charged with securities fraud for marketing predictive softwareThe Denver Post

all 12 news articles »

Want to Create the Next Great Software Product? Don't Try to Innovate
Ben Galbraith, vice president of global products for Walmart, is surprised at how many people still believe that the best way to come up with new software is to “get a bunch of nerds and put them in a room until they produce a product.” In reality, he ...

Software industry is the largest creator of jobs: Narayana Murthy
Economic Times
"The software industry in India employs about 3.2 million professionals and adds about 2,00,000 jobs every year. Therefore this industry has replaced the public sector as the largest creator of jobs," Murthy said at the Commonwealth Science Conference ...


Software industry is the biggest job creator in India: Narayana Murthy
Bullish on growth of Indian software industry, technology czar N R Narayana Murthy today equated India's success in this space with China's emergence as 'the factory of the world'. He also said that software industry has overtaken PSUs as biggest job ...

and more »

What does 'software defined' actually mean?
Lately, that overused (and often misused) term is “software defined,” which VMware first unveiled to describe its vision for a data center in which resources are pooled and managed by software. In just the past few weeks I've seen network switches ...


Regin Spying Software Has Been Attacking Governments And Corporations ...
Symantec has found an unusual new threat called Regin aka Backdoor.Regin. The software, which is essentially a very powerful Trojan Horse, appears to have been circulating in the wild since 2008 and has been hitting governmental, industrial, and ...
People Are Flipping Out Over This Spy Software Created By An Unknown ...Business Insider
Unidentified country likely behind spying softwareYahoo News UK
Regin: Newly uncovered malicious software snooping since 2008 'was ...The Independent

all 599 news articles »

FDA Approves Software for Noninvasive Cardio Studies
The US Food and Drug Administration (FDA) today approved a software program that can noninvasively identify coronary artery blockages, avoiding the need to diagnose the problem via cardiac catheterization. The software is FFR-CT, from a company called ...

and more »

Google News

home | site map
© 2006