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
Our company, Novaprof Inc., developed unique software - DB Integration.... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More
The Windows Indexing Service provides you with the ability to... Read More
Microsoft Great Plains as ERP and Microsoft CRM as... Read More
And kill the best layout software in the process of... Read More
Microsoft Word is one of the most popular office applications... Read More
So, why should you use any O/R mapping tool? I... Read More
A few months back I really got sick of my... Read More
If you copy something from a Web site or elsewhere...... Read More
Think of this, first we had the HAM Radio, then... Read More
Simply put, fleet maintenance allows companies to monitor and maintain... Read More
Considering whether or not your software company should hire a... Read More
Microsoft Great Plains may be recommended for international freight forwarding... Read More
For those who still don't know, Microsoft Publisher helps computer... Read More
Currently Microsoft Business Solutions is on the way of creating... Read More
We've all seen the ads on TV for Netzero 3G.... Read More
While I was preparing some personal background information for a... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Great Plains Purchase Order Processing (POP) module makes up one-third... Read More
Does Microsoft care for WebmastersIt's always been a problem with... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
Mike Dunville* had a decision to make. As the new... Read More
Manufacturing in the USA is far away down from mid... Read More
This article is for advanced Microsoft CRM SDK C# developers.... Read More
The COSMIC FP (function point) software quality metric, is no... Read More
In the Clinton era the status quo was simple: you... Read More
Microsoft CRM is now on the scene and it is... Read More
When Great Plains Software was designing and developing Great Plains... Read More
Microsoft Business Solutions CRM and IBM Lotus Notes Domino, being... Read More
Not all of us have the luxury of working both... Read More
What is Interactive Mapping?Interactive mapping is a visual display medium... Read More
It could just be me, but my experiences with document... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
Scrapbooks are very popular these days. I think that almost... Read More
Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More
Pirated software is on the increase and now accounts for... Read More
This article is the first of a series of articles... Read More
Not every software testing project can or should be automated.... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
Now is the time to look at an alternative to... Read More
The first thing that you will notice about Linux Red... Read More
What is 'adware'?Adware is basically software or scripts that are... Read More
To all web designers out there, this article is for... Read More
Formatting and reinstalling windows 98 is very easy if you... Read More
Mapping Software Improves Data VisualizationFrom the outset, it is important... Read More
Music downloads are off the charts! We're listening to digital... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
If you're online using a dialup Internet connection, you'll probably... Read More
Vince Lombardi once said that, "The achievements of an organization... Read More
We would like to give you several situations, when you... Read More
Cyberspace has opened up a new frontier with exciting possibilities... Read More
Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More
Microsoft Business Solutions ? Great Plains is designed to meet... Read More
Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More
And kill the best layout software in the process of... Read More
When Great Plains Software introduced the first graphical accounting application... Read More
ERP Consulting industry is on the way to serve clients... Read More
You have gotten those E_Mails buy software at deep discounts.... Read More
While Ukraine is becoming a new popular IT outsourcing destination,... Read More
MSN messenger is a pretty cool invention. I mean I'm... Read More
The purpose of Project Management Software is to provide an... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
We would like to give you pluses and minuses of... Read More
Microsoft CRM customization techniques are very diversified and based on... Read More
Once a business idea is selected, it is highly recommended... Read More
Software |