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! help@albaspectrum.com

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 (www.albaspectrum.com), he is CMA, Great Plains Certified Master, Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

You can contact Andrew: andrewk@albaspectrum.com


MORE RESOURCES:

Unlocking the potential of simulation software
MIT News
“We're trying to unlock the value of simulation software, since for many engineers current simulation software is far too slow and labor-intensive, especially for large models,” Knezevic says. “High-fidelity simulation enables more cost-effective ...



Moving toward smart and secure continuous software delivery
CSO Online
This, in turn, has made it possible for software testing to move swifter. “In the last year or two, we're seeing a trend where quality assurance and quality engineering teams are being forced to provide faster feedback and more self-service to the ...



New York Times

A Leader Struggles to Sell Software Meant to Aid Sales
New York Times
YESWARE is a four-year-old company that designs and sells software intended to make it easier for sales teams to record and analyze essential data. Released in late 2012, Yesware's basic version, which can be downloaded free, quickly attracted more ...

and more »


How to marry malware to software downloads in an undetectable way (Hint ...
Register
Be thankful it's only a proof-of-concept of a hack: German researchers have shown that internet software distribution mechanisms can be turned into virus vectors, without modifying the original code. The Ruhr University boffins – Felix Gröbert, Ahmad ...



Avoid risk, hefty price tag by using free alternatives to popular software
WKMG Orlando
WITH FBI AND OTHER OFFICIALS INVESTIGATING BROWN'S DEATH. IF YOU DOWNLOADED COMPUTER SOFTWARE, YOU KNOW THINGS COULD GET PRICEY. WHAT IF YOU COULD GET THE BEST VERSION FOR FREE? MIKE HOLFELD BRINGS ...



Reuters

RBS settles copyright lawsuit after US judge blocks software's use
Reuters
In May, U.S. District Judge Katherine Forrest in Manhattan entered a permanent injunction requiring RBS's ABN Amro unit to stop using the BankTrade software within a year, and not to use it to process new trade finance transactions received 60 days ...

and more »


International Business Times

German Software Giant SAP To Invest $500M In Africa Through 2020, Train ...
International Business Times
SAP SE (NYSE:SAP) will invest $500 million in Africa through 2020 and train 10,000 IT consultants as the world's largest maker of business management software aims to make the region one of its top five growth markets. SAP is among a large number of ...
German software firm to invest $500m in African marketsChronicle

all 51 news articles »


BuildBox: The nearly $3K drag-and-drop app game-making software launches to ...
VentureBeat
That's why you won't find any affiliate links to his products in this article, but I've got to admit that viewing the video for his new BuildBox drag-and-drop software impressed me so much that I showed part of it to my 13-year-old son as I waxed ...



F-35 software testing slowed by restrictions after a fire
The Virginian-Pilot
Flight restrictions on Lockheed Martin's F-35 are hampering the Pentagon's ability to conduct the software tests the plane must pass before it can be declared combat-ready by next July, according to the Pentagon's weapons-testing office. The start of ...
Flight restrictions slow F-35 software testingFort Worth Star Telegram

all 4 news articles »


Inc. 500: Medical software firm, dog washing company rank among Tampa Bay's ...
Tampabay.com
The Tampa health care software company surged in revenue from $185,000 to $17 million between 2010 and 2013, a 9,109 percent growth rate. MedHOK, which stands for Medical House of Knowledge, provides a cloud-based service covering both ...

and more »

Google News

home | site map
© 2006