Microsoft Small Business Manager eCommerce – overview

Microsoft Small Business Manager eCommerce – overview

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:

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
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
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.
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
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
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

ABOUT THE AUTHOR
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

Andrew Karasev

More Articles

Getting Started in ECommerce - Part Two - Heidi Richards MS
In Part One we talked a little bit about what Ecommerce is, getting a domain name and setting up a merchant account. Ecommerce is more than that, much more. To have a really good online presence that gets people to stop and shop you need a strategy...

eCommerce Web Site Building: Where Do I Start? - Jacob Richards
Building a web site isn't something that is really cut and dry. There's a huge variety of products and services that can either help you get your web site where you want it or simply confuse you. It's also important that you make the right choices...

Choosing an Ecommerce Shopping Cart - Danna Henderson
Choosing an online shopping cart is a big decision. Unlike a traditional brick and mortar business, your website is your only chance to impress potential customers. It needs to project a professional image to capture the trust of your visitors....

Ecommerce - Making Your Bank Account Grow - Kimberly Valentine
Ecommerce has opened the door to many small businesses and individuals to compete on a global level with their products and services. Basically sellers look for buyers to purchase their goods online knowing that the choices and convenience it...

eCommerce and other strange animals - Michael Bloch
eCommerce, Ecommerce, e-commerce; however you spell it, the term is now firmly lodged in our language. So just what is it? At it's most simplistic level; eCommerce is simply the buying and selling of goods, services or information via the World...

Drop Shipping Is Ecommerce Snake Oil - Gary Granai
Drop shipping is not for everyone. Even though it is pitched as a cure for everything from starting up withoutmoney to being able to sell without investing in inventory, it does not cure the main problems that want to be drop shippers have. Want...

Internet Basics: eCommerce is Like Playing House - Grant Pasay
Ever play house as a kid? You don't even have to be in a house to play it. You just say, "The kitchen's over there, and this is the laundry, and here's the garage," and so on. You make it all up in your mind, but none of it's really there. ...

Why Ecommerce is Not Ready for My Daughter or Me - Kimberly Krause Berg
As the mother of a teenage clothing fanatic I'm often at my local mall. It occurred to me that the shopping experience for my daughter is attractive to her not because she wants to spend my money, but because the experience of buying itself is so...

Affordable Ecommerce Web Site Design - David G Petten
Going into business over the internet is not something to be taken lightly these days. In most cases the new internet businesses are failing for one reason: A poorly designed and non-functional web site that does not attract customers. That is a...

Ecommerce: Mashups And Future Site Function - Scott Lindsay
What comes to your mind when you hear the term ‘Mashups”? It is likely whatever comes to mind will not come close to the actual thought process behind the term unless, of course, you are already familiar with the concept. The term ‘mashups’ has...

Profiting From The Ecommerce Website: Tips For The Beginner - Robert Michael
The ecommerce website has taken the internet by storm. Consumers are buying billions of dollars in merchandise yearly, often even profiting more than offline stores. The internet has become one of the most prominent marketing...

Merchant services add ecommerce functionality to any business - Jack Chevalier
According to paymentonline.com, this includes credit cards processing systems with a Merchant Account to receive payment from the customers. Merchant Accounts are an important element in any ecommerce venture. Merchant services provide...