Software Information |
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
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Microsoft Great Plains Implementation: Verticals - Wholesale Order Entry center - overview Microsoft Business Solutions Great Plains has substantial market share and strong support by Microsoft on the US market. Currently we see the trend in the vertical markets when companies with custom-built accounting application, usually written on legacy platform are switching to standard and proven ERP solution and customize or tailor it to fit their vertical market requirements. FreeDOS Before September 1995, Microsoft Windows was an MS-DOS program. DOS was an easy to use command line operating system that provided you with complete ability to control and troubleshoot your computer. Great Plains Dynamics/eEnterprise Upgrade - Things to Consider and FAQ If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier) and support it for your company then you need to know some technical details about Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customization, additional complexity comes with migration from ctree/Pervasive to MS SQL/MSDE. Adware, What Is It? Adware is a type of Spyware program that displays some kind of banner advertising as you're surfing the Internet. Most of the time, you will pick these programs up if you download other programs such as freeware, shareware, and file-sharing programs. Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More Microsoft Great Plains is main Microsoft Business Solutions accounting package for the US market. You should probably expect some issues when you have software development company to be bought by big player - in this case Great Plains Software was bought by Microsoft (Bill Gates was a friend to Doug Burgum - owner and leader of Great Plains Software - Great Plains Dynamics/eEnterprise). Microsoft CRM in Latin America: Implementation, Customization, Support - Overview for Consultant Microsoft Business Solutions CRM is present several years on the US software market plus it makes advances in Europe. We expect substantial number growth of Microsoft CRM implementations across South and Central America and the need for Microsoft CRM implementation, support, tuning, reporting, training services, especially in such countries as Mexico, Columbia, Venezuela, Argentina, Peru, Uruguay, Chili, Costa Rica. 7 Things to Consider Before Buying Small Business Accounting Software The world of small business accounting software can be a minefield for any business owner. However choosing the right package is one of the most critical business decisions you will make. CRM 101: Customer Relationship Management for Beginners Customer Relationship Management, abbreviated "CRM," is the term for a business strategy that is designed to improve customer service. CRM is also designed to increase customer satisfaction and gain new customers, thus increasing a business' revenue. Internet Faxing Service Review The Internet is reshaping every form of communications medium, and faxing is no exception. The latest twist: Internet faxing services that let you send messages to any fax machine from any Web browser or email, and others that give you a "personal fax phone number," then forward any documents sent there to your e-mail inbox. Falling in Love With More Than One Screensaver: The Fun Part Having from five to ten and more favorite screensavers is cool. But how do you enjoy them all in a straightforward and convenient way? Draw the power you need from the little yet useful tools discussed in this article!As you remember, earlier in my article What to Do if You Fall in Love With More Than One Screensaver we discussed the standard way of switching between multiple screensavers. Microsoft Great Plains SOP: Sales Order Processing Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized).Great Plains Sales Order Processing (SOP) module forms a third of the core Inventory and Order Processing part of Great Plains. Document Templates Give You The Perfect Framework For Your Documents When it comes to running an office, the SOHO entrepreneur has enough on his or her plate as it is. So if you find yourself in the unenviable position of regularly having to set aside your core competencies to handle tedious, repetitive administrative duties such as creating your business documents from scratch, then you need to consider the potential benefits offered by document templates. Microsoft CRM for Corporate Business - Working Offline If your company has regional and worldwide operations, you might already realized that it is very hard to get decent internet connection in your remote locations. In this small article we will try to give you highlights on how to implement Microsoft Business Solutions CRM for worldwide operations with restricted internet connection. Upgrading Great Plains Dexterity Customization - switching to new technologies: SQL, Crystal, eConne 1. Replace Dexterity cursor with SQL Stored ProcedureDexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Spyware Statistics -- Whats New in May 2005? Although statistics often is blamed for various deadly sins -- from being biased to being inaccurate -- there is nothing left to those who are anyhow connected with IT but to keep up with fresh data. Since spyware is literally ubiquitous, nobody who owns or uses a PC can say that it is none of his business. Microsoft Great Plains - Microsoft RMS Integration - overview Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are originally developed by different software vendors, who had no idea that in the remote future (now) these two applications will be owned by Microsoft and will need to be tightly integrated. Current integration between the two is not an easy thing. My Experience - Making a Vision into Reality Disclaimer: All the thoughts expressed are my views only! Your perception might differ.. How to Upgrade Dexterity Customization - Tips for IT Manager If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity - you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE.Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. MSN Messenger Is A Sweet Way To Communicate MSN messenger is a pretty cool invention. I mean I'm not really into serious discussions on the email, answers to questions can often take a few days to arrive because people are so busy these days. Linux - Keyboard Or Mouse Just stress testing one of the latest Linux distributions. Been testing it for about two months. |
home | site map | contact us |