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:


Could Rogue Software Engineers Be Behind VW Emissions Cheating?
Horn, testifying before the House subcommittee investigating Volkswagen's rigged software that enabled its four-cylinder diesel engines to cheat on emissions testing, said the so-called "defeat device" was the work of "a couple of software engineers ...
VW faces second probe over cheat
Older VW diesels will need software and hardware fixes, Horn tells lawmakersAutomotive News
Volkswagen America's CEO blames software engineers for emissions cheating scandalThe Verge
Sydney Morning Herald -Irish Times -Tech Times
all 5,422 news articles »

Discovery News

Got Distracted? Software Steers You Back On Course
Discovery News
Have you ever started a task, got interrupted and then completely forgot what you were doing? New software that can identify what action you were carrying out and then steer you back on track could come to your rescue. Bioengineers at the University of ...

Huffington Post

Regulators Open Second Investigation Into VW Emissions Software
Huffington Post
Regulators Open Second Investigation Into VW Emissions Software. The New York Times. Posted: 10/09/2015 04:59 PM EDT. WASHINGTON — Federal and California regulators have begun an investigation into a second computer program in Volkswagen's ...

Why Tableau Software Shares Sank 4% Yesterday
Motley Fool
In addition, learning entirely new software is always a switching cost, and Tableau has a very intuitive interface. I even helped pilot a program for The Fool's editorial department so that we could analyze our data in a more efficient way, and I was ...
Tableau Software (DATA) is Initiated by Drexel Hamilton to BuyMoney Flow Index
Drexel Hamilton Initiates Coverage on Tableau Software (DATA)Dakota Financial News
Drexel Hamilton Initiates Coverage on Tableau Software (DATA) to Buy with ...News Watch International
MarketBeat -Securities and Exchange Commission
all 18 news articles »

The Next Web

Pinterest engineer launches non-profit to boost employment for Black software ...
The Next Web
Pinterest engineer Makinde Adeagbo wants that to change, and has focused his efforts on Black software engineers with the launch of /dev/color, an independent nonprofit that seeks to boost the number of Black engineers throughout the industry.

and more »

Police News

NetMotion's new software improves connectivity, security in extreme environments
Police News
NetMotion Wireless and Panasonic are extending the availability of the NetMotion Mobility and Diagnostics software bundle for Panasonic Toughbook and Toughpad devices, according to a press release. The software bundle was launched in Europe earlier ...

and more »


LogMeIn Acquires Password Management Software LastPass For $110 Million
With an increasing number of data breaches putting users' personal information at risk, a company that helps online users better manage their account information with various websites and services, as well as help customers run security checks on their ...
LastPass bought by LogMeIn for $110 millionZDNet

all 88 news articles »

Google Service Interrupted for Some Cloud Software Products
Four of Google Inc.'s main cloud software services were unavailable for some users on Friday because of technological issues. Interruptions for Google Docs, Slides, Drive and Sheets products were first acknowledged at 11:55 a.m. by the Mountain View, ...

and more »


CrowdStrike's security software targets bad guys, not their malware
CrowdStrike as a Service, the company's signature offering, is a subscription-based Software as a Service platform designed to fulfill the company's mission: "To Keep the Bad Guys Out of Your Network." The two major components of CrowdStrike as a ... Brooklyn

How a piece of software helped double the size of this Wilmington law firm Brooklyn
Part of the representation of those clients is through the use of the software,” said Wayne Marvel. BlueVault is how Marvel and crew successfully coordinated cases in conjunction with Tardy's firm. “[It] allows us to not only share the documents and ...

Google News

home | site map
© 2006