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
Loan Tips:
GPS Tracking for the Small Business
GPS Tracking is a process which involves the Global Positioning System (GPS) to locate a given object or person. It works by sending and receiving signals to a GPS unit, which is affixed to the object prior to allow tracking. The signals are sent via one of the dozen satellites orbiting Earth for this purpose, which communicate with one another to allow them to pinpoint exactly the coordinates of the object you are tracking. This might all sound like technical stuff, and it is, but GPS can bring many benefits to the small business owner, and to our everyday lives. Consider, for example, a logistics company, or a local courier. With GPS tracking, they can tag the location of every vehicle in the fleet at any given time, which will enable...
Jump Starting A Small Business Presence Online
The traffic statistics page for Robert's new small business web site starts to load. He scrolls down the page, dismayed. Just one or two visitors daily. Robert sits back and sighs. Most were probably curious friends and family.
Windows Vista : Some Good Reasons For Deployment In Small Business
A new desktop operating system is now available for small business consumers: Windows Vista from Microsoft Until recently, this operating system was only available to large enterprise clients
The 5 Habits of Highly Successful Small-Business Owners
Have you ever wondered what the difference is between a business that consistently grows and another that struggles just to make ends meet? Or why a business that was started in a basement of a home can outperform some of the best-run "big" companies in sales and profits?Two businesses, operating in the same marketing arena and selling the same products or services, can have extraordinarily different results. How can one business continually grow and prosper, while the other struggles? How can one business owner run a highly successful business while still spending a good portion of his or her time away from the business on trips and vacations with the family, and another owner work day and night only to see his business fail?Such quest...
Search Engine Optimization For Small Business Websites
The term "search engine optimization" is one you will find time and again in the online venues that seek to help fledgling online marketers and business newbies to understand the finer points of the art of Internet marketing. As such the power of search engine optimization cannot be overstressed and while there are most certainly a lot of shady goings on in the world of ?Net marketing, the search engine rules and updated ? as well as tightened ? regulations have ensured that no unsavory webmasters are stealing codes from the top ranked business sites that have worked long and hard to garner their rightful status and then incorporating these codes into their own cheaply designed and run sites.
Small Business Loans Or Grants For Minority Women
Business Grant:Federal Grants Government Grant Business At True the federal government will not give you grants but it assists individuals wanting to start a small business. This is done through its support arm, the SBA (Small Business Administration). Through this, the US gives small businesses attractive loans and technical support. However, no grants are given to those who want to start a business or want to grow their existing businesses. The SBA was started in 1953 and has been responsible for helping so many thousands of Americans start up their own small business. SBA would like to reach the 25 million small businesses in the US today.. And also since the money is free there is a lot of competition for these grants. Small busine...
GotVMail Virtual Phone System for Small Business Named "Product to Watch" by Small Business Technology Magazine
GotVMail® Communications (http://www.gotvmail.com), the award-winning Virtual Phone System for Today's Small Business, today announced that Small Business Technology Magazine, the only print and digital publication in the U.S. focusing on the technology needs of small businesses, has selected GotVMail as a "Product to Watch" in its 2006 Product of the Year Awards.
Online Business Software: Small Business Solutions to Help You Succeed
Regardless of the type of small business you own, online business software can help you streamline your business, make it run more efficiently, and ultimately save you time and money. With so many different types of business software out there, you?re sure to find some that fit the needs of your business. Whether you want to speed up payroll or keep better track of your appointments, you?ll find software that will help you achieve your goals.
New Virtual Ad Agency Brings Top Talent To Small Business- VirtualAdAgency.com is Launched
A new virtual ad agency was launched today. VirtualAdAgency.com offers Madison Avenue talent to small business. With inexpensive package pricing and a client portal for collaboration.
Outskirts Press Announces New Business Beginners' Guide, the Latest Highly-Anticipated Business - Small Business Book from Hamilton, NJ, Author Lamin
Outskirts Press, Inc. has published New Business Beginners' Guide: Tools for a New Business by Lamin Tombekai Kamara, which is the author's most recent book to date. The 6.14 x 9.21 Paperback in the Business - Small Business category is available worldwide on book retailer websites such as Amazon and Barnes & Noble for a suggested retail price of $7.95. The webpage at www.outskirtspress.com/NewBusinessBeginnersGuide was launched simultaneously with the book's publication.
Small Business Technology Experts Ramon Ray and Brent Leary Join Speaker Lineup at Infusion CRM 2008 User Conference: Infusion Software Products Att
Infusion Software, the leading provider of CRM software for small businesses, today announced that small business technology guru Ramon Ray and small business CRM and marketing expert Brent Leary have been added to the speaker lineup for the Infusion Software 2008 User Conference being held March 5-7, 2008 in Scottsdale, Ariz.
Consumer Association's Web Site Serves Needs of the Self-Employed and Small Business Owners for Health Insurance and Other Benefits
The Federation of American Consumers and Travelers (FACT), a not-for-profit consumer organization, has introduced a special series of small-business benefits on its Web site (www.usafact.org).
Bottled Water and Government Small Business Set Asides:A Marketing Opportunity
The Federal Government and many State and Local Government agencies offer a valuable contract preference to bottled water companies who qualify as small businesses.
Guerrilla Marketing In Tough Times Shows Small Business Owners Recession-Proof Strategies
Beginning Tuesday, April 8, Jay Conrad Levinson, the Father of Guerrilla Marketing, and Mitch Meyerson, the Founder of Guerrilla Marketing Coaching, will host an intensive eight-week crash course for small business owners facing tough economic times. Guerrilla Marketing in Tough Times (http://www.easywebautomation.com/app/?af=751289) features eight one-hour, interactive teleclasses with Levinson and Meyerson and eight one-hour, interactive coaching sessions with Certified Guerrilla Marketing Coaches.
Hillary Clinton Jack-in-the-Box Toy Brings Hope of Huge Sales for Small Business Owner
Pop Art Creations will announce their new political toy one day before Super Tuesday: Hillary-in-the-Box, another Hillary-themed toy on the market this election season. We've all been inundated with Hillary toys of the not-so-flattering variety, since Clinton announced her candidacy for President. Hillary-in-the-box just may be the very first positive (or pro-Hillary) toy available this year.