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
|
|
|
These Items Are A Must Before Making The Decision To Purchase Any Off-the-shelf Software
1. What determines the software price? Is it Per Seat or Per User or Per Processor?The cost of software is determined in many ways. The two most popular ways are Per Seat or Per Concurrent User. Per Seat is determined by how many seats in your business will be using the softw...(related: Software)
Spybot - Search And Destroy Versus Microsoft Antispyware (beta).... My Personal Experiences...
Ok... Where to start?Well, I guess I will start at the beginning.....Like many surfers and especially webmasters and webmarketers, I spend quite a bit of time running around the net, researching this, investigating that and so on.So of course I come across any number of questionable websites with even more doubtful softw...(related: Software)
Most Common Ways To Accumulate Spyware (where It Is Downloaded To Your Pc)
It is possible that if one avoided all sources of spyware, ad-ware and virus infection that infection would be at minimal levels. Although I don't recommend using only this method as a form of fighting spyware, it can be a potentially effective mean. Used in conjunction with a virus scanning program (I recommend Avast), abstaining from visiting these web sites or using these programs will help your PC to fight off infections, infestations and slower speeds due to unneeded running processes.The most common places where your PC will pick up spyware, ad-ware and viruses will be adult websites or websites related to security. By security, I mean websites related to computer hacking and the like. If you partake in software piracy, you will notice that many of these websites that are piracy download zones have javascripts and cookies ...(related: Software)
Hubris - Definition: Microsofts Passport
Before September of 1995, Microsoft ignored the Internet because their 16-bit Windows 3.1 operating system couldn't handle the 32-bit Internet world. With the introduction of Windows 95, ...(related: Software)
Great Plains Dexterity Development: Faq
Microsoft Business Solutions Great Plains is Dexterity-written application and currently we see increased interest for Great Plains customers to do in-house Dexterity development and customization. Dexterity itself is written on C programming language and its initial architecture was based on the Graphical and Database platform independence, which C programming language was believed to provide. Initially back in 1994 Great Plains Software Dynamics and Dynamics C/S+ were realized for Macintosh and Windows and pretty similar Dexterity DYNAMICS.DIC dictionary worked for Ctree/Faircomm and Microsoft SQL Server 6.5. In our days Microsoft Great Plains is available for Windows and MS SQL Server only (since version 8.0). In this small article we would like to give you highlights on the most typical entry level Dexterity development question...(related: Software)
Microsoft Great Plains Fa: Fixed Assets ? Overview For Consultant
Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry.As with other Great Plains modules, save time and money by utilizing classes or groups to make mass changes. This is useful for depreciating, retiring, or simply changing the information for a set of assets with a single click. Great Plains' intuitive graphical user interface makes it easy to access supporting data on assets, books, etc. The latest versions of Great Plains Fixed Asset also comes with a total of 16 ...(related: Software)
Is Your Computer Sick?
Viruses and spyware usually show up on your computer one of two ways.Either they invade your system with a frontal assault like the Huns attacking the Romans, or they sneak in a back door like a cat burglar.Either way, once a virus or piece of spyware gets on your system, getting it off can rate harder than curing a severe case of trench foot!Viruses, malicious programs designed to disrupt normal computing, and spyware, programs intended to literally "spy" on your activities, can enter your computer a number of ways.Most commonly they enter your system through an email attachment, by sharing files with an infected computer by disk, as a "ride along" with a 3rd party program...(related: Software)
You Can Write Microsoft Office Program In About 60 Minutes
Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. It also can customize Excel, Word and other Office procedures for your own needs. From Office version 2000, all the Office programs are equipped with VBA.Hand-On experience is the key to be a good programmer. Programming tutorials are the easier way to learn any computer programs including VBA. For example, a tutorial can show people how to use VBA to automate (make automatic) an Excel routine like updating the fonts and sizes for a range of cells, or automatically pops up a calendar for selecting a date. VBA can also be used as a tool to auto...(related: Software)
How To Get The Best Accounting Software For Your Small Business
Buying accounting software is a major investment. It's an important decision and you need to be sure of all the facts before you buy.You certainly wouldn't want to get accounting software and then find a few months later that the software can't handle your growing business.You also don't want to be fooled into buying low priced software and then finding out that you have to make multiple upgrades to get it to the level you need to effectively run your business.And worst of all you don't want to get software with little or no support.Our research lead us to a website that has compared some of the most popular small business accountin...(related: Software)
Selecting Corporate Erp: Microsoft Business Solutions Great Plains ? Estimation Parameters
As we could imagine, if you are reading this article ? you are in the decision making mode, probably replacing legacy system with the new one or abandoning either Unix/Mainframe or Apple direction for your corporation. In any case, nobody should make an outside influence on your decision ? you should be maximally objective. Let us give you our estimates and the parameters to check on the pool of the poss...(related: Software)
Defining Olap Solutions And Data Warehouse Design
This tutorial covers OLAP solutions used by Data warehouses and understanding Data Warehouse design. The enterprise needs to ask itself certain fundamental questions before actually launching on the process of designing the data warehouse. It must begin with a conviction that a data warehouse would really help its business and the return on investment will make it worth it.Defining OLAP SolutionsThe data warehouse offloads data from a multitude of sources. The cleaned, validated and loaded data is voluminous and daunting. This data needs to be organized, categorized and arranged in meaningful order for analytical ...(related: Software)
site-map - Copyright © 2008 | Contact Webmaster | All Rights Reserved. | Software