Microsoft Business Solutions Small Business Manager is Great Plains Dexterity based application and successor and small business market niche version of Microsoft Great Plains. Microsoft Great Plains itself has variety of customization and integration tools: Integration Manager, VBA/Modifier, Great Plains Dexterity, SQL Server stored procedures to name a few. By one reason or another MBS decided to restrict Small Business Manager and do not provide VBA/Modifier, restricted Great Plains ReportWriter version and didn't include Great Plains Dexterity IDE installer on SBM CD.
Here we would like to give you your options and tools available in your disposition. If you are developer who is asked: how do we customize Microsoft Small Business Manager ? read this and you will have the clues on where to look further.
1. Great Plains Dexterity ? this is proprietary programming language and technology, designed back to earlier 1990th with the goal to build platform independent graphical accounting package ? Great Plains Dynamics. Dexterity itself is written in C (following popular those days hope ? that C will provide platform independence). You can install Dexterity from Great Plains 7.5 /8.0 CD #2. In case of Small Business Manager ? you need to call to MBS Partners, such as Alba Spectrum Technologies/ Obviously it requires a lot of learning / training, but it allows your custom piece be seamlessly integrated with Great Plains interface. Nowadays, however ? and this is a good thing ? most of Great Plains installations are moved to SQL Server ? so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures.
2. Crystal Reports. Great Plains has its own ReportWriter, but its functionality is limited ? you can't do cross modules reports (you can't link Sales and Purchasing tables in one report, for example). So ? you use Crystal. The GP tables structure is in Tools->Resource Description->Tables ? and you are in control. Feel free to create views and stored procs directly in the companies databases ? it doesn't hurt the Dexterity engine
3. Direct web publishing from Great Plains SQL databases, using Visual Studio.net and your language of choice (VB.Net, C#, J#, etc). Plus you probably want to have several SQL stored procs.
4. eConnect ? this tool is type of SDK with VB.net samples. It allows you to feed data into Great Plains and was primarily created for eCommerce developers.
5. SQL queries - as a developer you have unlimited potential in using SQL queries, because the database in MS SQL Server. Be careful, it is kind of surgery - you can easily delete all your customers, by executing: DELETE RM00101
Happy customizing! 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, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York and having locations in multiple states and internationally (http://www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
Elk Grove (east OF 53) Chicago limousine service .. Lockport Chicago limo O’HareAlthough we don't know whether Microsoft ever envisioned such a... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
People often ask me: What image file formats will Photoshop... Read More
Microsoft Great Plains fits to majority of horizontals and retail... Read More
While Adobe is the most known maker of PDF tools,... Read More
As you probably know, when Microsoft purchased Great Plains Software... Read More
There are two approaches for application integration:? Programmer's approach ?... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
Great Plains Inventory Management (IV) module gives your business a... Read More
Have you ever noticed that when you look at your... Read More
Background: For many organizations like ours, the interim target of... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
Looking at all the ads which promise to get rid... Read More
If you have Microsoft Great Plains as main accounting and... Read More
Beginning with Domino version R4 it has integration with the... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
We would like to give you several situations, when you... Read More
Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More
I started using PIP (Picture It Publishing) Platinum 2002 right... Read More
eStore Advantage allows front-office applications to communicate with back-office business... Read More
limousine airport Ackworth ..MS CRM is very close to document workflow automation, including... Read More
While I was in college, if you would have asked... Read More
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
XML parser is a software module to read documents and... Read More
Microsoft Business Solutions Great Plains is very good fit for... Read More
In a previous article, I wrote about OpenOffice... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Most people don't use Photoshop to its fullest capabilities. Here... Read More
2005 ? Back to the Future.What does the future hold?... Read More
The first thing that you will notice about Linux Red... Read More
Fortunately one of the most common reasons cited for the... Read More
TCO (Total Cost Ownership) is the buzzword in... Read More
ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Microsoft Great Plains is now standard mid-market ERP application, serving... Read More
If you copy something from a Web site or elsewhere...... Read More
Let's first look at your ERP system selection (without Retail... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Microsoft Business Solutions Great Plains has full-featured manufacturing set of... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
Software |