Microsoft Business Solutions Small Business Manager is scaled down Great Plains Dexterity based version of Microsoft Great Plains or former Great Plains Dynamics/eEnterprise. Small Business Manager first release 7.0 and all the following version was available on MSDE (MS SQL Server 2000 with limited usage and database size ? 2GB maximum). It is nice situation on the market in eCommerce niche ? we see huge number of customers, who have purchased and implemented SBM for their small and mid-size businesses and then realized that customization options for Small Business Manager are very limited: in comparison to Great Plains SBM doesn't have VBA/Modifier, it has very restricted version of Integration Manager. These restrictions lead you, eCommerce developer to direct SQL programming. Again ? being scaled down version of Microsoft Great Plains ? Small Business Manager has a legacy of relatively complex tables structure. tom stored procedures way here:
1. Tables Structure. Small Business Manager has similar to Great Plains structure and similar System DYNAMICS database and the company. As you could see tables structure in Resource description in Great Plains ? so you do in SBM
2. Stored Procs. Yes ? we can go ahead and create stored proc in DYNAMICS and companies databases or Small Business Manager. Now ? there is one issue. Technically Small Business Manager comes with MSDE and MSDE doesn't have lovely tool SQL Server Enterprise Manager with Query Analyzer, etc. So somehow you should deal with this. If you have consulting programmer ? she or he can connect to your MSDE installation, using MS SQL Server Enterprise Manager, installed on consultant's laptop
3. Visual Studio.Net. This is the development tools to use ? because you will need a lot of web-debugging, considering complicated tables structure and records workflow. Some developers might suggest to use VS.Net data designer to link to Great Plains tables ? this idea is rather very difficult to realize, because of the simultaneous population of multiple tables, while creating internet orders: Order Header, Order Lines, Order Comments, Customer Master, Customer Address Master to name a few. So we would recommend sticking to stored proc.
4. SOP. Sales Order Processing. Usually eCommerce solution works around Sales Order Processing tables. The reason is ? it works with Inventoried items and typical eCommerce is ordering specific items off the internet. Look at SOP10100, SOP10200 and other tables with SOP prefix. Also you should know that SOP1XXX ? are so called working tables and you populate mostly these, when orders are transformed to invoices, order record goes to SOP3XXX tables ? these are called historical
5. RM. Receivables Management Module ? When Sales Order Processing Invoices are posted ? they create record in Accounts Receivables or Receivables Management Module. RM has RMXXXX tables and the ones you are interested to know are RM00101 ? customer master and RM00102 ? customer address master
6. Batch Processing. We recommend you consider just order creation via web interface. Then these orders should be processed by operator in Small Business Manager
Good luck with implementation, customization and integration 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-630-961-5918 or 1-866-528-0577! help@albaspectrum.com
Andrew is Great Plains specialist in Alba Spectrum Technologies (http://www.albaspectrum.com ) ? USA nationwide Great Plains, Microsoft CRM customization company, serving clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in multiple states and internationally
![]() |
|
![]() |
|
![]() |
|
![]() |
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
In part III of this ISDN primer, we learned that... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
With many manufacturing shops heading over seas in favor of... Read More
Great Plains Fixed Assets Management module is a robust tool... Read More
Now is the time to look at an alternative to... Read More
Looks like Microsoft Great Plains becomes more... Read More
Itâ??s easy to understand why you might be drawn to... Read More
While I was preparing some personal background information for a... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
If you are to buy a HelpDesk & Asset Management... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
When you need a phone number, you do a quick... Read More
It's not very often I get excited about a software... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
The software giants don't do everything and don't always produce... Read More
When you first think about multicurrency ? you probably have... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
I have yet to see a business that, sometimes in... Read More
Whether you need to close a sale, gather end-user feedback,... Read More
2005 ? Back to the Future.What does the future hold?... Read More
For a long time now Microsoft's Internet Explorer has ruled... Read More
In our opinion, traditional approach when you select ERP/MRP system... Read More
Blue Cross and Blue Shield of Hawaii (HMSA) found itself... Read More
SAP Inc., a global leader in client/server enterprise application software... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
Software Engineering is the Systematic Approach for analysis design implementation... Read More
Microsoft Business Solutions Great Plains is written in Great Plains... Read More
Using professional icons in your application or website can bring... Read More
If you have Microsoft Great Plains and support it for... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
When reading an article where some term is used often,... Read More
Microsoft Great Plains - Microsoft Business Solutions accounting and ERP... Read More
Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
A wiki is an editable text-based website. But you don't... Read More
Language development computer: Computer-based method for aiding language development seems... Read More
Microsoft Business Solutions CRM is now approaching the phase of... Read More
This article will not attempt to advocate the use of... Read More
And kill the best layout software in the process of... Read More
Microsoft-Outlook is a pretty amazing program. So much more than... Read More
People often ask me: What image file formats will Photoshop... Read More
Homeland security, airport security, Internet security â?" these days weâ??re... Read More
Customer Relationship Management or CRM is a combination of enterprise... Read More
Spyware and malware are large problems for Internet users today... Read More
What is IRC?IRC is Internet Relay Chat. It is a... Read More
Are you one of those people that keeps track of... Read More
I completed an experiment recently. I wanted to find out... Read More
For a windows user like me, just can watch with... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
DBxtra is a powerful query and reporting tool that hides... Read More
Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More
Microsoft CRM is new player on the CRM software... Read More
Since its release in 1987, QuarkXpress had made an immediate... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
I have yet to see a business that, sometimes in... Read More
No matter how much you enjoy your favorite screensavers, sometimes... Read More
You might think you don't need a firewall... Read More
Let's first look at your ERP system selection (without Retail... Read More
Software |