Software informational articles

Microsoft great plains - archetypal tribulations and fixes ? overview for it administrators - software


How to obliterate the user? This is the first catch you come upon - when user shuts down the central processing unit - Great Plains doesn't have the authority to log off the user and when user tries to login the next day - she gets error letter that user is by now logged on. The fix:

  • Microsoft SQL Server - open SQL Query Analyzer, change to DYNAMICS list and run the next script: Obliterate Commotion WHERE USERID='KATHY'.
  • Pervasive SQL/Ctree - if you have more than one user registered you can cancel 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 arrangement - DYNAMICS is the root, in Coordination folder cancel ACTIVITY. * files

How to unlock the batch? This happens when user posts the batch and has her cpu given up the ghost (via surfing the internet - smile - or clothes like this)

  • General tip - Great Plains recommends to logoff and then login back with the same user id. Then Great Plains will bring about the user to get back redistribution batch. Sadly it doesn't work in 70% of the cases
  • MS SQL Server - the batch best is stored in Batch Description table: SY00500 in the circle database. The fields to clear are: BCHSTTUS and MKDTOPST. In some cases you have to cancel the background from SY00800 from DYNAMICS db.
  • Pervasive/ctree - you have to ensconce ODBC driver for Enveloping or Ctree and hook the tables: SY00500, SY00800 with Microsoft Approach - use coupled tables technique

Now we would like to stress you the need to move away from Invasive SQL 2000/Ctree platforms - you are in anxiety - Microsoft Affair Solutions cuts mechanical aid for Microsoft Great Plains 7. 5 and prior on these platforms. This means not only the support, but also tax updates (especially Payroll and National Captivating Media).

What is migration from Ctree/Pervasive. SQL 2000 to MS SQL/MSDE? MBS has migration tool. You need first to fit Great Plains on SQL Ma?tre d'h?tel with accurately the same account/segments arrangement and then fit migration tool (it is Agility chunk) on your ctree/Pervasive workstation - then, when you integrate the chunk - you will map it to affect SQL-based Great Plains Company, choose all coordination and ballet company tables, click the fasten 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 - or else you have to do guide move, use SQL Coupled head waiter to your birthright data

Do I need consultant? It is almost certainly good idea to have consultant to do the upgrade. We clearly commend you to use consultant in the subsequent cases

  • You have Adroitness customization
  • You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, exceptionally when you have third-parties lacking migration tools
  • You have a lot or ReportWriter Bespoke Great Plains Reports
  • You have old edition of Great Plains: Dynamics or eEnteroprise 6. 0 or prior - in this case you can not ask to Microsoft Mechanical Assistance - 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 big business problems
  • You don't have assist - in this case you have to cliquey your Microsoft Affair Solutions Partner and pay for the yearly support/enhancement plan - you will get new registration key and will be ready for the upgrade

Good luck in putting in place 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 Know-how Detective in Alba Spectrum Technologies - USA generally 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 many states and worldwide (www. albaspectrum. com), he is CMA, Great Plains Practiced Master, Dexterity, SQL, C#. Net, Rock Gossip and Microsoft CRM SDK developer.

You can call Andrew: andrewk@albaspectrum. com

Developed by:
home | site map © 2018