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 Alba Spectrum Technologies ? 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 (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, MS Access, Crystal Reports and Microsoft CRM SDK developer.
There are several kinds of software piracy. The bottom line... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
When you own a small business, time is money. And... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Spyware is like the new technological nuclear weapon on the... Read More
Microsoft Business Solutions Small Business Manager is scaled down Great... Read More
Microsoft Business Solutions is emerging as very attractive vendor for... Read More
Siebel is traditional CRM market leader, however and mostly due... Read More
I provide, here clear explanations and a count of function... Read More
All your software is stored on a hard-drive. But how... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains has substantial market share and... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
This article will not attempt to advocate the use of... Read More
One of the main reasons business owners and entrepreneurs use... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Navision Software was purchased by Microsoft and now it is... Read More
Case study: A secretary using Corel WordPerfect 7 is often... Read More
Microsoft Business Solutions Great Plains is mid and even corporate... Read More
In the previous ISDN article, we looked at how and... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
The major reason I recommend getting your hands on real... Read More
I like my software simple. If it's too complex or... Read More
Passwords protect your most sensitive personal, financial and business information.... Read More
Software development is a risky business.Many software developers are barely... Read More
Enabling Chinese input is quick and easy, there are only... Read More
1. What determines the software price? Is it Per Seat... Read More
Today's business world is fast-paced. No matter what it is... Read More
Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More
This article is the first of a series of articles... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
Crystal Reports is the most flexible tool on the market... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
XML parser is a software module to read documents and... Read More
Since Version 8.0 Microsoft Business Solutions Great Plains & Great... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
In the previous ISDN article, we looked at how and... Read More
Using professional icons in your application or website can bring... Read More
At the end of XX century, in the late 1990th... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
So, you've bought a new Macintosh, and now you may... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More
Microsoft Business Solutions CRM proved to be reliable solution in... Read More
Rapid Application Development (RAD) is a software development methodology. In... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Considering whether or not your software company should hire a... Read More
Anyone who has ever used Microsoft Word knows that it... Read More
This tutorial covers OLAP solutions used by Data warehouses and... Read More
Follow the steps below to quickly design, generate, and deploy... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Did you ever give a thought to the number of... Read More
The major reason I recommend getting your hands on real... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
In this short FAQ style article we would like to... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
In the real world a "fire wall" is a fireproof... Read More
So, why should you use any O/R mapping tool? I... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More
So let's begin crunching down these 300 images using Adobe... Read More
An operating system (abbreviated OS) is essentially the path through... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Software |