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:



Tech giants give millions to support free software in wake of Heartbleed
SAN FRANCISCO - A group of companies that reads like a who's who of technology are contributing $300,000 each to underwriting improvements to critical open source programs used by millions. It will be called The Core Infrastructure Initiative. The list ...
Cisco, Microsoft, VMware, and other tech giants unite behind critical open ...ZDNet
Heartbleed causes tech giants to unite over open-source software
Heartbleed response: Tech giants to fund OpenSSL, other projectsTechTarget
Telemanagement -Washington Post
all 143 news articles »

ShopKeep's Point Of Sale Software Rings Up $25 Million
With its latest $25 million financing, ShopKeep POS has come a long way from being the cobbled together point of sale software service for a single wine shop in Brooklyn's leafy Ft. Greene neighborhood. The company's history began six years ago with ...
ShopKeep's Point of Sale Software Raises $

all 18 news articles »

Washington Post (blog)

64000 software engineers have settled with tech companies over wage collusion
Washington Post (blog)
Tens of thousands of software engineers have reached a settlement with major tech companies including Apple, Google, Intel and Adobe in a high-profile class-action lawsuit over poaching and lost wages. The terms of the deal will remain confidential ...

and more »


Microsoft profit slips; software, Surface help sales
Microsoft Corp. said its fiscal third-quarter profit declined 6.5%, dragged down by slumping personal-computer sales and a sales-boosting adjustment a year earlier for software upgrades. The earnings scorecard is the first under Satya Nadella, the ...
Microsoft Earnings Preview: Software Giant Transitions From Value To GrowthSeeking Alpha
Microsoft profit drops but devices, consumer products help resultsIDG News Service

all 323 news articles »

Warburg Pincus Buys Compensation Software Service PayScale For Up To ...
Making its fourth acquisition of a technology company in fewer than three weeks, private equity investment firm Warburg Pincus is announcing that it has bought compensation software services vendor PayScale in a deal worth up to $100 million. In the 14 ...

and more »

HTC One (M8) gets treated to a minor software update
... based Android 4.4.2 with the home backed Sense 6.0 UI on top. The new firmware size is about 150 MB and is already rolling out. If you haven't received any notification, then you can check for the update manually by visiting Settings > About ...

and more »

Building A Software Toolkit For Financial Services Nets Tradier $3.1 Million
Tradier's chief executive Dan Raju has spent the past few years pursuing a singular vision — giving developers a toolkit to build trading platforms and financial services apps that easily integrate with brokerages and stock markets. Now, with $3.1 ...

and more »

Man allegedly pirated Kodak Prinergy Evo software
Rochester Democrat and Chronicle
An Iranian man has been charged with fraud after allegedly selling unauthorized, pirated copies of Kodak software. According to a criminal complaint, Navid Salehvaziri, 32, of Tehran, Iran, was arrested in Virginia, and appeared Thursday before a U.S. ...
Feds charge Iranian with pirating Kodak softwareWHAM
Police: Iranian man develops knock off website to sell pirated copies of Kodak ...News 10NBC

all 3 news articles »

Internap Rolls Out Network Optimization Software - Delivering All The Shortcuts
Infrastructure vendor Internap has gotten itself a patent for MIRO, routing software that optimizes network traffic such that bits take the shortest, quickest and most effective route between point A and point B. On top of the routing software ...
Internap Rebuilds Patented Routing Software and Content Delivery Network to ...Broadway World
Internap rebuilds patented routing software and content delivery networkCIOL

all 17 news articles »

Doran Jones could bring 150 new software, engineering jobs to the Bronx
News 12 Bronx (registration)
There could be 150 new software testing jobs by this fall. (4/24/14). THE BRONX - Software consulting company Doran Jones is building an office in an East 138th Street facility. The new office could bring up to 150 new software and engineering jobs to ...

Google News

home | site map
© 2006