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.
Chicago limo Skokie ..Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
If you've been using MySQL database to store your important... Read More
An integral part of any quality CRM system is lead... Read More
Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More
With many manufacturing shops heading over seas in favor of... Read More
The most important benefit of XML is its simplicity. Though... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
In this short FAQ style article we would like to... Read More
IBM Lotus Notes with Domino email server is traditional document... Read More
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More
Google Inc. has launched a new software package that allows... Read More
Looks like Microsoft Great Plains becomes more and more... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Just when you thought you were Web savvy, one more... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Best Software Act! is very popular CRM for small and... Read More
Enabling Chinese input is quick and easy, there are only... Read More
Microsoft CRM is CRM answer from Microsoft Business Solutions. If... Read More
Several software companies design programs for preventive maintenance. Most of... Read More
During the years of our consulting practice, which comes back... Read More
In a previous article, I wrote about OpenOffice... Read More
This short paper will expand on two key reasons to... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
Microsoft CRM is relatively new player on the now becoming... Read More
limo O'Hare Bonfield ..1. What determines the software price? Is it Per Seat... Read More
1. With mapping software you can create a report that... Read More
The Windows Indexing Service provides you with the ability to... Read More
In this short FAQ style article we would like to... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
In the real world a "fire wall" is a fireproof... Read More
In 2004 Oracle, Inc. made its new step toward J2EE... Read More
Three highly respected names in Human Resources have joined forces... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
When you need a phone number, you do a quick... Read More
How many steps does it take you to locate and... Read More
Preventive Maintenance (PM) is defined as scheduled work done on... Read More
Sticky Noteshttp://www.deprice.com/stickynote.htmWith StickyNote 9.0, you can create beautiful 3D notes... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
If you have Microsoft Great Plains and support it for... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
MSN messenger is a pretty cool invention. I mean I'm... 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
Microsoft Great Plains is main accounting / ERP application... Read More
Software development is a risky business.Many software developers are barely... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Which Type of Shop Can Rely On A Home Built... Read More
Microsoft Retail Management System serves retail single store as well... Read More
Some companies that are in need of fleet management may... Read More
Software |