| |
| |
|
softwarecatch.com
|
|
|
|
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:
Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains: Interest Calculation Example - Stored Procedure for Crystal Report This is intermediate level SQL scripting article for DB Administrator, Programmer, IT SpecialistOur and Microsoft Business Solutions goal here is to educate database administrator, programmer, software developer to enable them support Microsoft Great Plains for their companies. In our opinion self support is the goal of Microsoft to facilitate implementation of its products: Great Plains, Navision, Solomon, Microsoft CRM. Microsoft CRM Customization - Programming Closed Email Activity Microsoft CRM is CRM answer from Microsoft and attempt to get market share from Siebel, Oracle and others traditional Client Relationship Management System vendors. Microsoft CRM uses all the spectrum of Microsoft recent technologies: . Why Stick With Email Clients Like Outlook? Trying to figure out a stream in banning one email client or another is no easy job. As soon as somebody rises up saying Outlook is bad, somebody else comes saying it's good and the other one is bad. Microsoft CRM Integration with Microsoft Retail Management System (RMS) - Overview Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS. So, RMS design fundamentals were minted a long time before Microsoft CRM. Review of TikiWiki Content Management System TikiWiki is open source software - it is written in PHP, uses phpAdmin for mySQL database administration, and uses the Smarty Template Engine.Installation - Since our host installed the TikiWiki, I cannot comment on ease of installation. XML Parser and Their Types XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser. How To Develop Software For Your Business Software development is a risky business.Many software developers are barely skilled at their trade, much less at business. Microsoft Great Plains FA: Fixed Assets - Overview For Consultant Great Plains Fixed Assets Management module is a robust tool that can help you manage your assets effectively. It integrates perfectly with other Great Plains modules like General Ledger, Purchase Order Processing, and Payables Management ensuring accuracy while reducing redundant data entry. Do You Know These Facts About Spyware ? Imagine something that follows you home and sets itself up in your house. It eats your food, enjoys your drinks, reads everything you bring home or purchase. Microsoft Great Plains: If You are Orphan Client - What to Do and FAQ Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise, Dynamics and Dynamics C/S+ is very popular ERP and since 1994 has been successfully implemented for mid-size and mid-size to large companies in the USA, Canada, UK, Australia, New Zealand, South Africa and Middle East. During the economic recession time 2001-2004 the majority of businesses cut to virtually zero their IT/computer support expenses and stayed with hardware and software. Microsoft CRM Integration & Customization: SharePoint Document Gateway MS CRM is very close to document workflow automation, including Microsoft Office documents: Words, Excel, etc. The document workflow was perfectly automated about 10 years ago in Lotus Notes Domino. Microsoft Great Plains in Construction & Building - Implementation & Customization Highlights Microsoft Great Plains could be tuned and setup to fit most of horizontal markets. You can deploy third party modules or build your own custom logic in Great Plains Dexterity. How to Make Own CMS Every day millions of new web documents emerge on the Internet, and the amount of web management tools is growing simultaneously. These tools are usually referred to as Content Management Systems, CMS for short. Microsoft Great Plains customization - Freight Forwarding/Transportation industry example Microsoft Business Solutions Great Plains version 8.5, 8. Unofficial Windows 98 SE Service Pack 2.0 RC2 Microsoft has never released a service pack for Windows98 SE, but I made a Service Pack for Windows98 SE users.It contains all Windows98 SE updates from Windows Update site and more. A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications Icons are used everywhere; right from software applications, to internet browsers, to operating systems to websites and even in print media. But businesses have to waste a good deal of money and time in manufacturing icons on their own. ERP Remote Support: Microsoft Great Plains Analysis - Pluses & Minuses Former Great Plains Software Dynamics/eEnterprise and currently Microsoft Business Solutions Great Plains serves midsize and corporate clients as ERP system in the following countries and regions: USA, Canada, Mexico and Latin America, Brazil (where MBS actually promotes Navision and has GP for multinational corporations), Saudi Arabia, OAE, Egypt and the rest of Middle East, South Africa, Nigeria and the whole African continent, U.K. Microsoft Great Plains Installation - Overview for IT Director/Controller Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. How To Choose A Fire Wall Software Program In the real world a "fire wall" is a fireproof wall that is built to stop the spread of fire from one part of a building to others. In the Internet world a firewall has a similar purpose in that it stops the spread of harmful viruses and attacks from entering your home or office network. Groupware: Avoid the Ad Hoc Shuffle GroupwareEfforts are continually made to manage the unavoidable ad hoc business process, but ad hoc processes do not necessarily mean a pile of messy, shuffled documents, at least not anymore. Groupware is software which tracks and manages the ad hoc business collaboration.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
