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
shuttle from O'Hare Brocton .. Lockport Chicago limo O’HareLooks like Microsoft Great Plains becomes more and more popular,... Read More
As Mozilla Firefox nears 10% market share, with well over... Read More
Before September of 1995, Microsoft ignored the Internet because their... Read More
Costs of fleet maintenance software can vary widely. It is... Read More
Microsoft Business Solutions CRM is present several years on the... Read More
Beginning with Domino version R4 it has integration with the... Read More
Now there are Three Steps To Heaven Just listen and... Read More
Microsoft Business Solutions Great Plains serves multiple industries in the... Read More
Microsoft CRM was designed to be easily customizable. Microsoft CRM... Read More
CD and DVD replication is a process that works by... Read More
C++ Function templates are those functions which can handle different... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More
Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More
Pirated software is on the increase and now accounts for... Read More
Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... Read More
Sales are all about leverage, because there is only so... Read More
The cornerstone of successful automated office systems is the ability... Read More
Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More
Microsoft released Service Pack 2 (SP2) for the Windows XP... Read More
This article will not attempt to advocate the use of... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Customer Relationship Management, abbreviated "CRM," is the term for a... Read More
Anti-virus software is used to find, remove or fix files... Read More
Remember old good days when your company probably had Great... Read More
Chicago charter limousine service Hickory Hills ..Looking at all the ads which promise to get rid... Read More
The Microsoft system preparation utility for Windows 2000 is a... Read More
In the early days of the personal computer, we're talking... Read More
It's all about turn times in the eMedia industry! The... Read More
Music downloads are off the charts! We're listening to digital... Read More
Are you lost in the mess of documents that get... Read More
The first thing that you will notice about Linux Red... Read More
According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More
Every organization which creates collaborative documents, whether they are budgets,... Read More
1. Replace Dexterity cursor with SQL Stored Procedure Dexterity... Read More
We are in a transition phase in the Managerial Administration... Read More
If you feel intimidated when someone tries to teach you... Read More
While several preventive maintenance software manufacturers offer free trials for... Read More
It's no secret that software companies operate in a very... Read More
Microsoft Business Solutions CRM is web-based CRM application, deploying all... Read More
If you have Microsoft Great Plains and support it for... Read More
When you need a phone number, you do a quick... Read More
After almost two decades of existence, Quark has become the... Read More
If you look back to the history, you will see... Read More
There are certain pluses and minuses in both cases and... Read More
Several years ago Microsoft purchased Great Plains Software, then Navision... Read More
Microsoft Office program is a programming tool called Visual Basic... Read More
Adware is a type of Spyware program that displays some... Read More
The various resume software offered, particularly on the internet, can... Read More
It's not very often I get excited about a software... Read More
Software |