Software informational articles

Microsoft small big business executive ecommerce ? overview - software


Microsoft Affair Solutions Small Big business Executive is scaled down Great Plains Agility based account of Microsoft Great Plains or earlier Great Plains Dynamics/eEnterprise. Small Affair Boss first announcement 7. 0 and all the next edition was obtainable on MSDE (MS SQL Ma?tre d' 2000 with imperfect usage and catalog size - 2GB maximum). It is nice location on the bazaar in eCommerce niche - we see huge amount of customers, who have purchased and implemented SBM for their small and mid-size businesses and then realized that customization options for Small Affair Executive are very limited: in association to Great Plains SBM doesn't have VBA/Modifier, it has very classified account of Integration Manager. These restrictions lead you, eCommerce developer to address SQL programming. Again - being scaled down description of Microsoft Great Plains - Small Affair Administrator has a bequest of more or less composite tables structure. tom stored procedures way here:

1. Tables Structure. Small Big business Executive has alike to Great Plains arrange and akin Classification DYNAMICS catalog and the company. As you could see tables arrange in Reserve depiction in Great Plains - so you do in SBM

2. Stored Procs. Yes - we can go ahead and conceive stored proc in DYNAMICS and companies databases or Small Affair Manager. Now - there is one issue. Technically Small Affair Administrator comes with MSDE and MSDE doesn't have lovely tool SQL Ma?tre d'h?tel Venture Administrator with Query Analyzer, etc. So in some way you be supposed to deal with this. If you have consulting programmer - she or he can associate to your MSDE installation, using MS SQL Ma?tre d'h?tel Activity Manager, installed on consultant's laptop

3. Visual Studio. Net. This is the change tools to use - since you will need a lot of web-debugging, in view of convoluted tables arrange and minutes workflow. Some developers might advise to use VS. Net data designer to link to Great Plains tables - this idea is instead very awkward to realize, for the reason that of the instantaneous residents of compound tables, while creating internet orders: Order Header, Order Lines, Order Comments, Buyer Master, Buyer Attend to Master to name a few. So we would commend sticking to stored proc.

4. SOP. Sales Order Processing. Customarily eCommerce clarification works about Sales Order Giving out tables. The analyze is - it works with Inventoried items and archetypal eCommerce is ordering certain items off the internet. Look at SOP10100, SOP10200 and other tables with SOP prefix. Also you must know that SOP1XXX - are so called operational tables and you populate as a rule these, when guidelines are transformed to invoices, order best ever goes to SOP3XXX tables - these are called historical

5. RM. Receivables Management Module - When Sales Order Giving out Invoices are posted - they coin best ever in Financial records Receivables or Receivables Management Module. RM has RMXXXX tables and the ones you are fascinated to know are RM00101 - patron master and RM00102 - client concentrate on master

6. Batch Processing. We commend you care about just order conception via web interface. Then these commands ought to be processed by operative in Small Affair 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 countrywide Great Plains, Microsoft CRM customization company, helping clients in Chicago, Houston, Atlanta, Phoenix, New York, Los Angeles, San Francisco, San Diego, Miami, New Orleans, Toronto, Montreal and having locations in many states and internationally

Developed by:
home | site map © 2018