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:

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

---

Linux for Home Users

Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

Windows Screensavers Explained

In this article you will find some background information about... Read More

History of Java

The java programming language is becoming more and more popular... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

Seven Reasons Why a Hosted Inventory Management Solution Might Be Right For Your Organization

Upgrading. Downtime. Maintenance. Hardware obsolescence. Implementation issues. The litany of... Read More

Make 2005 the Year You Save Time!

Today's business world is fast-paced. No matter what it is... Read More

Microsoft Great Plains SOP: Sales Order Processing

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

10 Programming Tips

(1) Avoid using the same variable again and again for... Read More

Microsoft Great Plains Food Processing ? Implementation & Customization Highlights

Microsoft Great Plains might be considered as ERP platform to... Read More

Getting Patched with Windows Service Pack

Are you one of those people that keeps track of... Read More

Microsoft Great Plains: Interest Calculation Example ? Stored Procedure for Crystal Report

This is intermediate level SQL scripting article for DB Administrator,... Read More

40/sec to 500/sec

IntroductionSurprised, by the title? well, this is a tour of... Read More

Is Software Tester a Most Infamous Person in a Software Project Team?

The fact that a software tester is a most infamous... Read More

A Case Study on Selecting Contract Management Software

Professional services firm cuts costs and improves productivity with integrated... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Unofficial Windows 98 SE Service Pack 2.0 RC2

Microsoft has never released a service pack for Windows98 SE,... Read More

Microsoft CRM Data Conversion FAQ

Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or... Read More

5 Easy File Management Tips in Microsoft Word

How many steps does it take you to locate and... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Microsoft Business Solutions Products Selection: ERP, CRM, Retail Management

Let's first look at your ERP system selection (without Retail... Read More

Accounts Payable: A Powerful Document Management and Workflow Solution

Accounts payable is just one area of office management where... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

The Tools and Features of Adobe Photoshop

Adobe Photoshop is one of the world's leading graphics editing... Read More

Adware and Spyware

What is 'adware'?Adware is basically software or scripts that are... Read More

Basic Tips and tricks for Windows XP

Running Applications in Compatibility Mode With Windows XP, you can... Read More

A Simple Guide To Wikis

A wiki is an editable text-based website. But you don't... Read More

How To Avoid Getting Hooked By Pfishing

"Pfishing", sometimes spelled "Phishing", is a word that's used to... Read More

Huddle Up; Groupware on Three

It could just be me, but my experiences with document... Read More

Does Microsoft have any real competition?

Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

Scrap Booking Online: Word Perfect or Corel Graphics Suite?

Scrapbooks are very popular these days. I think that almost... Read More