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:



Cloud Software Begins to Lose Altitude
It's time to put up or shut up in cloud software. One of the hottest recent themes in technology has been the rise of young companies such as Workday and Zendesk that sell Web-friendly software to businesses for subscription fees. Those cloud software ...

and more »

Wall Street Journal

Microsoft to Make Virtual-Reality Software Available to Others
Wall Street Journal
Opening the software known as Windows Holographic is Microsoft's bid to maneuver itself to the center of the emerging market for virtual reality and related experiences, where its HoloLens headset—which delivers experiences known as augmented ...
Microsoft Delivers First Major HoloLens Software (blog)
Microsoft HoloLens Development Edition gets its first major software updateWindows Central
HoloLens software update brings multitasking, Bluetooth mouse support, and moreLiliputing

all 26 news articles »

Software for Stopping Freedom
New York Times
As Nicole Perlroth writes, software companies are selling with little restriction spying and hacking tools to governments interested in quashing human-rights workers, political dissidents and journalists. Though the target clients are often ...


Pre-Loaded Laptop Software Comes With Security Risks
Dark Reading
Pre-loaded software update tools installed on laptops from five major OEM PC vendors can lead to a full system compromise in less than 10 minutes, according to an investigation conducted by Duo Security. Acer, Asus, Dell, Hewlett-Packard, and Lenovo ...
OEM software update tools preloaded on PCs are a security messPCWorld
Security reseachers: update-software from Asus, Acer, Dell, Lenovo and HP contain many security
Report: Bloatware Security Flaws Affect Millions of PCsPCMag India
Engadget -WIRED
all 22 news articles »

Huffington Post

From Startup to Success in a Software-Fueled Venture
Huffington Post
It's a tiny voice in the hurricane of books, conferences and attention paid to Innovation. Anyone doing something new that somehow involves computers and software would benefit by paying attention to this book. It identifies success patterns that aren ...


Tesla Says Software Update Will Fix Model X Doors
ABC News
Tesla Motors said Tuesday that two upcoming software updates should fix persistent glitches with the futuristic rear doors on its Model X SUV. At Tesla's nearly four-hour shareholder meeting in Mountain View, California, Tesla CEO Elon Musk also hinted ...
Here's How Tesla Is Fixing Its Model X Door ProblemFortune
Tesla's latest software update adds new door and seat controls to Model XElectrek

all 99 news articles »

New York Times

Rise of Ad-Blocking Software Threatens Online Revenue
New York Times
The use of ad-blocking software has divided the online world. Supporters say it allows people to get better access to content without having to suffer through abrasive ads. Opponents, particularly companies that rely on advertising, say blocking ads ...
Ad-blocking software use for mobile surges: studyYahoo News

all 50 news articles »

Financial Times

Banks turn to software to ease stress as regulations tighten around the globe
Financial Times
“There are huge regulatory costs and overheads, which are something of an issue for banks,” says Cliff Moyce, global head of finance practice at technology consultancy DataArt. “Banks are using screening software, plugging in extra IT tools to core ...

and more »

Sony streamlines business; offloads creative software products
The German software and app provider provides designing, editing and presentation software for both private and business users, and says the acquisition of SCS products will improve the firm's position across other markets, including the United States.

and more »


Stop your bitching and stalling; just take the software upgrade already
Traditionally, when we think in terms of computer systems and software, at least prior to the last decade or so, computer software was very much a static thing. Software upgrades for operating systems and application packages happened at four year ...

and more »

Google News

home | site map
© 2006