Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology ? Great Plains Dexterity dictionary DYNAMICS.DIC and runtime DYNAMICS.EXE), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.
If you are database administrator who is supporting the version on Pervasive SQL.2000/Ctree ? read this and you will have the clues on where to look further.
1. Microsoft Great Plains Tables Structure ? Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers ? it should be RM00101 ? customer master file, account master file - GL00101, Sales Header Work file - SOP10200 - and you got the idea.
2. Use Microsoft Access. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. This will allow you to do data modification/repair. Some people are trying to use Pervasive control center - we do not recommend this - MS Access does job better.
3. Locked batch repair ? unlocking the batch, which was interrupted in posting. The tables: SYoo500 - batch header - you need to change Batch Status or Marked for Posting field
4. Activity table - If you have user locked in Great Plains - just ask all the other users exit and delete ACTIVITY.BTR (Pervasive) or ACTIVITY.DAT (Ctree)
5. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. This will allow you to deploy ODBC connection to Great Plains database
6. Sometimes you have to rescue to Great Plains Dexterity- when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy. This is proprietary Great Plains Software tool and development environment and you need some time invested, before you can do programming.
7. Complex Data Migration - use MS SQL Linked Server - you can create linked server to Pervasive/ctree and then you can create the cursor, coming through all the tables in your migration set - we usually recommend reading tables schema in MS SQL Server (it is the same to Pervasive) and pull the data from Pervasive database using EXEC statement in Transact SQL.
Happy data repairing! 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 help@albaspectrum.com ? USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, San Francisco, Los Angeles, San Diego, New York, Boston, Atlanta, Houston, Austin, Dallas, Miami, Atlanta, Denver, Phoenix, Minneapolis, Canada, UK, Australia, Europe, Moscow and having locations in multiple US states (help@albaspectrum.com), he is Dexterity, SQL, C#.Net, MS Access, Crystal Reports and Microsoft CRM SDK developer.
Mercedes Benz s500 rentals Salem ..C++ Function templates are those functions which can handle different... Read More
Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
It won't matter how effective your WinRunner Team is if... Read More
This article is the third of a series of articles... Read More
Domino server is a buffer between the operation system and... Read More
It is really interesting that a bug can create problem... Read More
The Windows registry is a huge database that ensures normal... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Great Plains Integration Manager scripting and translation - overview for... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
1. What determines the software price? Is it Per Seat... Read More
Whether you are a small consultancy firm, a medium sized... Read More
Have you noticed WordPerfect is gearing up for a comeback... Read More
In order to meet regulatory and corporate compliance requirements reporting... Read More
User interfaces and accessibility are some of the most important... Read More
We don't think about mainframe software pricing anymore, we just... Read More
Microsoft CRM is now on the scene and it is... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
Microsoft Great Plains is now targeting large and midsize businesses... Read More
If someone entered your home, uninvited and installed numerous cameras... Read More
Google Inc. has launched a new software package that allows... Read More
Every day millions of new web documents emerge on the... Read More
How would you like to prevent spyware and adware from... Read More
Dowagiac cheap limo service ..With the advent of 'Service Pack 2' for Windows XP... Read More
Healthcare facilities such as clinics, hospitals, and biomedical laboratories can... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
When you think... Read More
Adware is a type of Spyware program that displays some... Read More
As we could imagine, if you are reading this article... Read More
Manufacturing in the USA is far away down from mid... Read More
All of us know that Microsoft bought former Great Plains... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More
Using professional icons in your application or website can bring... Read More
It is a well known fact that Java as a... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
After seeing many people complain about their weak Internet security... Read More
Spyware, what it is and what it does. Basically, spyware... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
In today's business world it's all but impossible to escape... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
With this small article we are continuing Microsoft Business Solutions... Read More
I have yet to see a business that, sometimes in... Read More
.NET platform does not support multiple inheritance. Do not confuse... Read More
There are several kinds of software piracy. The bottom line... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Software |