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
![]() |
|
![]() |
|
![]() |
|
![]() |
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Microsoft Business Solutions Great Plains is Dexterity-written application and currently... Read More
I suggest that you do not spend a lot of... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
Microsoft CRM has built-in conversion tool, however you should probably... Read More
Find out why Spyware Removal from computers is important and... Read More
If you look back to the history, you will see... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
The Internet is reshaping every form of communications medium, and... Read More
Most computer users use spreadsheets software such as Microsoft Excel... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Features Additionally, Vista will include many other new features.Aero Vista... Read More
Running Applications in Compatibility Mode With Windows XP, you can... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Need help making sense of algebra? Have algebra lectures in... Read More
COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More
As seeing large number of implementations ? in our case... Read More
Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More
When it comes to screenplay software each screenwriter needs to... Read More
Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More
If there still are few unprotected computers left, I haven't... Read More
How to delete the user? This is the first problem... Read More
Our opinion is based on our Microsoft Business Solutions Great... Read More
Designing without tables by using CSS layouts is fast becoming... Read More
I provide, here clear explanations and a count of function... Read More
When you need a phone number, you do a quick... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
Did you ever want to erase everything on your computer?... Read More
In the new era of internet marketing the problem of... Read More
This is a short article, written in question/answer/FAQ style to... Read More
Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More
The purpose of one of our projects was MS Exchange... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
You would like to protect your documents, wouldn't you? Reasons... Read More
When you buy a computer, it most likely comes with... Read More
Microsoft Great Plains ? ERM from Microsoft Business Solutions and... Read More
What is a Web Database?A web database is a database... Read More
Current Microsoft Business Solutions Great Plains has more that 10... Read More
In today's business world it's all but impossible to escape... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
You might think you don't need a firewall... Read More
Need software to record your voice, streaming audio or musical... Read More
The adware and spyware definitions list is very long. But... Read More
Remember nice and prosperous Clinton era? When you implemented innovative... Read More
We were recently faced with a decision: either to let... Read More
This article is the third of a series of articles... Read More
Let's first look at your ERP system selection (without Retail... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Logistics automation is often considered as barcoding extension to Sales... Read More
Now there are Three Steps To Heaven Just listen and... Read More
In the new era of internet marketing the problem of... Read More
(1) Avoid using the same variable again and again for... Read More
The Windows registry is a huge database that ensures normal... Read More
When you visit department stores and see that majority of... Read More
Microsoft Business Solutions ? Navision is an integrated solution for... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Microsoft Business Solutions Great Plains as new ERP for multinational... Read More
A LOT OF UNWANTED FILES.When you uninstall an item of... Read More
It could just be me, but my experiences with document... Read More
What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More
How many steps does it take you to locate and... Read More
If you are to buy a HelpDesk & Asset Management... Read More
The intentions of this short tutorial are not to teach... Read More
This article is the fourth of a series of articles... Read More
There are certain pluses and minuses in both cases and... Read More
Software |