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:


Software that helps power Siri is named after Iron Man's AI, JARVIS
The Verge
The open source software, first developed out of UC Berkeley, is designed to make massive data centers more efficient and easier to manage. Among other duties, Mesos determines the best way to complete tasks with all of the resources in a data center.

Overcome Agile hangovers with a 'software craftsman' approach
Agile software methodologies are all well and good, but many companies may be experiencing "Agile hangover." This is something that happens as a result of going into Agile with high expectations, but not seeing overnight success with software finely ...


NetSuite Builds Its Digital Commerce Offering-Acquires Bronto Software
NetSuite, probably the best-known mid-market cloud-based ERP vendor, has long talked about becoming the pre-eminent omnichannel offering. What that means in plain English, is that NetSuite NetSuite wants to offer the very best combined offering for ...
NetSuite in $200 Million Deal for Bronto SoftwareRe/code
NetSuite buys Bronto Software for $200 millionZDNet
NetSuite Expands Omnichannel Commerce Platform With Bronto Software ...Marketing Land
News & Observer -Industrial Distribution -Silicon Valley Business Journal
all 70 news articles »

The Register

Oracle's Hurd says 95% of its software will be cloud services this year
The Register
Oracle co-CEO Mark Hurd has said the database giant plans to make substantially all of its software products available as cloud services, and that it will be ready to start signing up subscriptions come this October. Hurd made his comments in an ...
Oracle CEO Hurd Plans to Lift Almost All Products Into CloudBloomberg

all 6 news articles »


Satoshi Broke Software Barriers, 'Now Everyone Is Doing It'
Essentially, Atlassian makes software for technical teams and Mountford has been involved in the development of many of these tools. Some of the more popular ones include Bitbucket, Jira, Hipchat and Confluence. Atlassian has over 22,000 customers ...

and more »

Seeing Buildings Shake With Software
Motion and color magnification using software is something that has been going on for a while. It first came to public attention back in 2005 at Siggraph. This made use of direct tracking of changes in pixels and then applied the detected movement to ...

Stars and Stripes

Software database links bomb fragments to bomb-makers
Stars and Stripes
Bomb-makers utilize whatever they can find to create a detonation. This 500-pound bomb, rigged up as an IED, was found in an old IED crater by sappers performing route clearance near Bagdhad early in the Iraq War. Dfuze software in the U.S. and more ...


Apple Q2 FY2015 Preview: iPhone Momentum Expected; Focus On Software ...
Seeking Alpha
To offset the hardware risk, AAPL has been taking steps to improve on both the hardware and software front. While these changes will take time to translate into revenue, the App Store remains a key revenue driver and accretive to AAPL's long-term margins.
Apple Watch release underwhelms critics, shows early signs of

all 123 news articles »

Tech Times

Samsung Galaxy Note Edge Android 5.0 Lollipop Software Update Imminent For ...
Tech Times
Samsung has been very busy lately, developing and releasing OS software updates for its wide range of smartphones. The company began with the release of Android 5.0 Lollipop for its most recent releases and flagship smartphones and tablets, which ...
HTC One M9 camera update for AT&T, T-Mobile leads this week's Android upate ...Greenbot

all 397 news articles »

Lock-down your Windows system with Simple Software-restriction Policy
Ghacks Technology News
Simple Software-restriction Policy allows you to harden Windows machines by adding Linux-like execute permissions to them. Windows by default does not prevent software from being run from any location on the computer which malware and unwanted ...

Google News

home | site map
© 2006