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
Strategic Acquisition Strategies for Small Businesses
Growth through acquisition should not be considered an option reserved solely for large or Public Companies. Small and mid-size businesses that opt to grow by acquiring other companies, rather than growing one new customer at a time, can gain benefits in addition to increased sales and profits.
Small Moisture Analyzer Company Grows with Big Technology
SpectraSensors uses NASA technology to change the world of natural gas analyzers and leapfrog into the world of big players.
Chicago Tribune Features Coupons By Phone Entrepreneur
The Chicago Tribune featured entrepreneur Ola Ayeni's mobile coupon company -Text2store , which serves up discounts and special offers on everything from latte's to furniture via coupons delivered directly to customer cell phones nationwide.
Network Solutions® Makes Running an Online Small Business Easier Thanks to the Complete Redesign of Account Manager
Network Solutions newly redesigned Account Manager provides customers with easy access to account information. Customers are now greeted with a more organized design and can get to the information they need faster and more conveniently.
Decorate With Southwestern Bath Accessories
The bathroom is one of the most important rooms in your home. It is a busy room and also one that provides a quiet get away. It is one of the few rooms where guests will have free access. So you want the room to be inviting and relaxing, yet have a charm of its own. One way to achieve this is to decorate with southwestern bath accessories.
Epiar Inc. Wins Coveted Small Business Owner of the Year Award
It's been a good year for Epiar, a search engine optimization (SEO) company in Edmonton (http://www.epiar.com).
Ordering Coupons Online Can Save You Money
One way of saving money with coupons is to pickup your local newspaper in order to get the weekly coupons insert. But there is another way, and that is ordering them online.
iYogi Launches 24/7 Computer Help Desk Support for Small and Medium Enterprises
Most cost effective, outsourced help-desk support, available at a flat monthly fee of $6.99 per-computer, per-month.
Unlimited access to the highest quality Microsoft Certified (MCDST) 'live' computer support on the phone, email or via remote access.
Highest published industry benchmark of 93% customer satisfaction for computer support and an overall resolution rate of 84%.
Discountbeautycenter.com Announces the Addition of 3 New Beauty Brands to Their Website
Discountbeautycenter.com, a web site offering the nation s largest selection of professional beauty products, cosmetics, and designer fragrances, announced that they have added 3 new brands to their online web store.
Shoes Can Make The Plus Size Evening Gowns
To set off a dress, there's nothing like a great pair of shoes. Take Cinderella's story, for example: without the right footwear, she never would have gotten her prince! When you've selected your evening gown, be sure to spend time finding the right pair of shoes to coordinate with it. If your gown has sparkles, find some diamond-embellished heels, or consider dying some slippers to match the color of your dress.