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:


Ask Larry: ​​​When Social Security Software Is Essential
You definitely should run our software or some other very carefully constructed Social Security maximization software to see what's optimal in terms of lifetime benefits. You and your wife may both live to 100. That's a long time to be collecting ...

and more »

L.A. Weekly

Cannabis Software Companies Seek to Legitimize the Marijuana Industry and Cash In
L.A. Weekly
Within the industry, software is considered an ancillary business, meaning that it doesn't require companies to directly grow, process or sell marijuana. Offering an ancillary product or service is generally considered less legally risky than ...

and more »

Yahoo Finance

Eaton's New Circuit Design Software Studio Allows Customers to ...
Yahoo Finance
Power management company Eaton today announced the launch of its new Circuit Design Software Studio, an easy-to-use platform that streamlines the process ...

and more »


'Blockchain' May Fail Banks, But Open Software Won't - CoinDesk
Pavel Kravchenko is a decentralized systems expert, public speaker and the founder of Distributed Lab, a startup dedicated to bringing open-source blockchain ...

and more »


Shmoocon 2017: Software Defined Radio for Terahertz Frequencies ...
Before Bluetooth, before the Internet of Things, and before network-connected everything, infrared was king. In the 90s, personal organizers, keyboards, Furbys, ...

and more »


Progress Software reports 4Q loss
Yahoo Finance
(AP) _ Progress Software Corp. (PRGS) on Monday reported a loss of $73.8 million in its fiscal fourth quarter. The Bedford, Massachusetts-based company said it had a loss of $1.52 per share. Earnings, adjusted for one-time gains and costs, were 62 ...
Progress Software Corporation (PRGS) Stake Cut by Swiss National BankBBNS
Progress Software Corporation (PRGS) Moves Higher on Volume Spike for January
Progress Software Corp Earnings Climb 12% In Q4RTT News

all 7 news articles »


Move Over, Coders—Physicists Will Soon Rule Silicon Valley
If physics and software engineering were subatomic particles, Silicon Valley has turned into the place where the fields collide. Boykin works with three other physicists at Stripe. In December, when General Electric acquired the machine learning ...

Tech Times

Tesla Software Update Lifts Speed Limit Restriction For Autopilot On Undivided Roadways
Tech Times
Before the rollout of the new software, Tesla placed a cap on its cruise control limit. Prior to the cap, Tesla drivers were able to go up to 5 mph over the speed limit on undivided highways. But succeeding reports of misuse and abuse that became viral ...
Tesla Autopilot Mode Software Update, Autopilot HW2, Downloading To HW2 Vehicles; No Release Notes YetMobile & Apps

all 15 news articles »

Conference on free software technology
The Hindu
Free Software Movement of India is conducting its second national conference — 4CCon — in Chennai. The event will be held from January 26-29 at B.S. Abdur Rahman University (formerly B.S. Abdur Rahman Crescent Engineering College).

and more »


EPA Charges Against Fiat Chrysler Put Software In The Legal Spotlight
The Environmental Protection Agency's charges against Fiat Chrysler Automobile raise a question: Can code be illegal, or just the actions of the coders? In accusations that echo the ones that have cost Volkswagen more than $15 billion and led to the ...
EPA Accuses Fiat Chrysler Of Installing Emissions-Cheating SoftwareNPR
EPA: Fiat Chrysler software enabled emissions cheatingWashington Post
Fiat accused over emissions softwareBBC News
TechCrunch -ABA Journal -The Guardian -US Environmental Protection Agency
all 748 news articles »

Google News

home | site map
© 2006