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
Culver prom limo ..What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More
(1) Avoid using the same variable again and again for... Read More
In the early days of the personal computer, we're talking... Read More
Midsize business or non-profit organization should decide if one-vendor solution... Read More
Let us give you - developer some hints in the... Read More
Looking at all the ads which promise to get rid... Read More
What is Snort?Snort is an open source network intrusion detection... Read More
Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More
Following tips help you to learn a software in lesser... Read More
Microsoft Great Plains serves majority of US based horizontal and... Read More
#5 All your hardware components like Printers, PCs etc come... Read More
In linux, one of great commands for finding out information... Read More
Microsoft Business Solutions Great Plains has many years of successful... Read More
Microsoft Great Plains has substantial mid-market share in the USA... Read More
It's no secret that software companies operate in a very... Read More
Bar charts, bar graphs, and any other chart or graph... Read More
Microsoft Business Solutions Great Plains serves to the wide spectrum... Read More
We will base our prognosis on our Microsoft Business Solutions... Read More
Microsoft SQL Server is the leader for inexpensive and middle... Read More
Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics/eEnterprise... Read More
C++ Function templates are those functions which can handle different... Read More
Whether you have used Microsoft Word for years, have just... Read More
Microsoft CRM is winning market share step-by-step from such the... Read More
If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More
One day, you suddenly realize that your computer started to... Read More
Wood Dale limo ..The software giants don't do everything and don't always produce... Read More
With so many Microsoft Windows related viruses, errors, and other... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
When my daughter was getting into AOL instant messaging (AIM)... Read More
Introduction to C++Why Learn C++?C++ may at first seem like... Read More
This is the tutorial where we really get into programming.... Read More
What is Software?Software is a set of instruction written to... Read More
If you feel intimidated when someone tries to teach you... Read More
In this small article we will show you the possible... Read More
Microsoft Great Plains is main mid-market application from Microsoft Business... Read More
Configuring PPP PAP AuthenticationNow we know how the ISDN link... Read More
The most important benefit of XML is its simplicity. Though... Read More
I have yet to see a business that, sometimes in... Read More
If you've been using MySQL database to store your important... Read More
Microsoft Business Solutions Great Plains has several options to enable... Read More
Program Flow is what you think it is. How the... Read More
Programming Help for BeginnersWe write programs to instruct computers. When... Read More
Microsoft Great Plains is one of three Microsoft Business Solutions... Read More
Looks like Microsoft Great Plains becomes more and more popular,... Read More
Although we don't know whether Microsoft ever envisioned such a... Read More
Great Plains Accounting, accounting package for mid-size and small companies... Read More
Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More
There is many things more frustrating than surfing a website... Read More
Microsoft bought Navision, Denmark based software development company, along with... Read More
Viruses and spyware usually show up on your computer one... Read More
Software |