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:


Heartbleed Software Snafu: The Good, the Bad and the Ugly
Scientific American
Nine days after the announcement of the Heartbleed vulnerability in OpenSSL, software widely used to secure Internet traffic, we have a much better understanding of the extent of the damage. (Thanks to the invaluable xkcd Web comic, we also have a ...
Android phones have “Heartbleed” software bugColumbus Dispatch
NSC Backs Disclosing Software VulnerabilitiesSci-Tech Today

all 1,463 news articles »

When iPhoto isn't enough: Four reasons to upgrade your software
Adobe's Lightroom and Apple's Aperture provide better management and image tools, while Photoshop and Photoshop Elements can augment iPhoto's basic editing software with more powerful options. If you're starting to feel like your library is getting out ...

and more »

Act-On Software lands whopping $42 million VC round, among Silicon Forest's ...
The Oregonian
raghu_raghavan_act-on_randy.JPG. Act-On Software CEO Raghu Raghavan came to Oregon to work for Mentor Graphics Corp. and was later co-founder and chief technology officer of online marketing company Responsys. (Randy L. Rasmussen/The ...
Act-On Software lands $42MPortland Business Journal (blog)
Marketing Automation Provider Act-On Software Raises $42M, Eyes IPOXconomy

all 10 news articles »

Software engineers think they're amazingly great, study says
If this research is to be believed (and I see no reason that it should be any more or less believable than any other research), the average software engineer plans to stay at his or her company for nine years. It surely can't take that long for options ...

and more »

University researchers develop software increasing cloud computing efficiency
The Stanford Daily
Researchers at Stanford have developed software that could increase the efficiency of cloud computing by eliciting more work from the available infrastructure at large-scale data centers. The tool, named Quasar, uses techniques similar to Amazon and ...

Siemens USA announces $660M in-kind software grants for Mass. schools
Boston Business Journal (blog)
A student at Worcester Polytechnic Institute uses Siemens USA's manufacturing software. Thirteen educational institutions in Massachusetts will benefit from $660 million worth of in-kind software grants beginning this year from Siemens USA.
Siemens helps narrow the skills gapBoston Globe
Siemens to donate $660 million in software to 13 Massachusetts
Siemens to donate millions in computer software to WPI, QCC, Worcester Tech ...Worcester Telegram
MCADCafe (press release)
all 9 news articles »

Austin software maker on path to hire more tech workers
Austin Business Journal (blog)
Motive officials told Austin Business Journal they plan to hire more than 100 software developers in the coming months with 30-40 of the workers to be added at Motive's local office. The hiring spree comes amid steady growth for the company that now ...

and more »

Aging Software Shows What Your Five-Year-Old Will Look Like At 80
... which pieces of family genetics will shine through. Computer scientists at the University of Washington have designed a novel piece of software that has the capability of showing how a child's face will age throughout their lifetime and into their ...


Atlassian's Geeky Software Carves Out A Big Home With Developers
While enterprise software companies struggle to make their wares more consumer-friendly, Atlassian builds software that only a developer could love: It's geeky, not super intuitive and frankly somewhat unpleasant to use for a business user like myself.

Software That Helps Small Businesses Ship Like Amazon
New York Times (blog)
In his spare time two years ago, Jarrett Streebin operated a gift-card reselling business that required his customers to send their gift cards to him. He wanted to give them preprinted, prepaid shipping labels to make the process easy, but it proved ...

and more »

Google News

home | site map
© 2006