Microsoft Business Solutions Customization Options - Overview for Programmer

Several years ago Microsoft purchased Great Plains Software, then Navision (Denmark based software development company). At this time Great Plains Software already was active ERP applications consolidation player - it already acquired Solomon Software couple of years prior. Then in 2002 Microsoft released Microsoft CRM (Client Relation Management system). Also Microsoft decided to attack retail marked and acquired QuickSell (now Microsoft Retail Management System/ Microsoft RMS).

At this time Microsoft had robust package to automate business processes for small, midsize and large company and it formed so-called Microsoft Business Solutions (at the earlier stage the official name was Microsoft Great Plains Business Solutions - later Great Plains words were dropped)

We would like to make brief review of customization options for such products as Microsoft Great Plains, Microsoft CRM and Microsoft RMS

Technology overview. Microsoft Great Plains, Microsoft CRM and Microsoft RMS have similar database platform - Microsoft SQL Server. There are differences in the tables design between three - due to the fact that they were originally developed by three different companies. Great Plains has Great Plains Dexterity core (this is Great Plains Software proprietary c-language based technology and development environment), and as it was primarily targeted to be platform independence - Great Plains has old-fashioned UNIX style of tables names: RM00101 stays for customer master file, GL00100 - account master file, etc. At the same time Microsoft RMS and Microsoft CRM have more natural language based names: Microsoft CRM: Account, Activity, Contact, Lead; Microsoft RMS: Customer, Transaction, Tender, Register - we believe that these structures are self explanatory.

Now to the Customization Options:

Great Plains Dexterity - please install Dexterity from CD #2 and take a look at its manuals - this is again legacy and proprietary Great Plains technology. We have described it in this article: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/DexterityCustomizationOptions.htm
Microsoft CRM Customization - this is the whole topic - we would like to reference you to our posting: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/MSCRMCustomizationOptions.htm
Microsoft RMS. Please review this article: http://www.albaspectrum.com/Customizations_Whitepapers/Dexterity_SQL_VBA_Crystal/GPRMSIntegrationOptions.htm

Happy customizing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Colorado, DC, New Jersey, Washington, Texas, Arizona, Florida, Georgia, New York and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM; akarasev@albaspectrum.com

MORE RESOURCES:

Elliott Terminates Tender Offer to Acquire Epicor Software Corporation - MarketWatch

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/0i-0fd=Rurl=http://www.businesswire.com/news/google/20081121005614/encid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFlqBpPhoj7TIcI_0vg4V9vA-QVvgimg src=http://news.google.com/news?imgefp=OYfvcWR7KYEJimgurl=mms.businesswire.com/bwapps/mediaserver/ViewMedia%3Fmgid%3D104664%26vid%3D2 width=80 height=80 alt= border=1brfont size=-2Business Wire (press release)/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/0-0fd=Rurl=http://www.marketwatch.com/news/story/Elliott-Terminates-Tender-Offer-Acquire/story.aspx%3Fguid%3D%257B715050E5-AD0A-4808-A8D6-38ED8DF5BC63%257Dcid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNEtmF-svXBTaify5Khqa-tqbIcwfgElliott Terminates Tender Offer to Acquire Epicor bSoftware/b Corporation/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr16 hours ago/nobr/fontbrfont size=-1b.../b LP and Elliott International, LP (collectively, quot;Elliottquot; or quot;wequot;), a major shareholder of Epicor bSoftware/b Corporation (the quot;Companyquot; or quot;Epicorquot;), b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-1fd=Rurl=http://www.forbes.com/feeds/ap/2008/11/21/ap5729568.htmlcid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFTyq0S3Gcj3QcmUajb72cJTTXWQQEpicor drops after hedge fund ends hostile bid/a font size=-1 color=#6f6f6fnobrForbes/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-2fd=Rurl=http://www.ocbj.com/industry_article.asp%3FaID%3D75658381.8793711.1711307.8237208.5233255.264%26aID2%3D131630cid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNHL8xz3LwiLPglhAdJMtgOi-ZuYoQHedge Fund Elliott Associates Withdraws Offer for Epicor bSoftware/b/a font size=-1 color=#6f6f6fnobrOrange County Business Journal/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/0-3fd=Rurl=http://www.reuters.com/article/mergersNews/idUSBNG18344320081121cid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFysrjQFkvM180CRluLy_L_CL4igAUPDATE 1-Hedge Fund ends offer for Epicor/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/0-4fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782142%26SMap%3D1cid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNHoS7P4xTtKhxztSc-rnwgZU8LM8gnobrRTT News/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/0-5fd=Rurl=http://blogs.barrons.com/techtraderdaily/2008/11/21/epicor-elliott-associates-drops-bid-stock-tumbles/cid=1272902427ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNG4qtD3lU4s8KgAZRlSgTBS_UJGPgnobrBarron's Blogs/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272902427hl=ennobrall 44 news articles/nobr/a/font/div/font/td/tr/table

The best thing about the 2.2 iPhone software update - CNET News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/1i-0fd=Rurl=http://gadgetwise.blogs.nytimes.com/2008/11/21/picture-google-street-view-on-the-iphone/cid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNHgDMyelXwcD-6m57ogqnPQt6zs1wimg src=http://news.google.com/news?imgefp=DbM9qO9EamEJimgurl=graphics8.nytimes.com/images/2008/11/21/technology/personaltech/iphonemap2.480.jpg width=80 height=32 alt= border=1brfont size=-2New York Times/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/1-0fd=Rurl=http://news.cnet.com/8301-17938_105-10105305-1.htmlcid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNEuLz6qDAREJFdwj79sMXoMUJ6UwAThe best thing about the 2.2 iPhone bsoftware/b update/abrfont size=-1font color=#6f6f6fCNET News,nbsp;CAnbsp;-/font nobr10 hours ago/nobr/fontbrfont size=-1When it some to iPhone bsoftware/b updates, I#39;m all about the basics. Apple could enable the iPhone to cook my dinner every night, but if it added multimedia b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-1fd=Rurl=http://www.crn.com/networking/212101415cid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNH4fX_LL0ZYWvMz90uzHGTTJXT7LgFirst Look: Apple#39;s iPhone 2.2 bSoftware/b Hits The Street (And b.../b/a font size=-1 color=#6f6f6fnobrCRN/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-2fd=Rurl=http://arstechnica.com/news.ars/post/20081121-lots-to-like-about-new-iphone-2-2-software-update.htmlcid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNH_RTFfrUIXY-RvBynslNWMYghwYgLots to like about new iPhone 2.2 bsoftware/b update/a font size=-1 color=#6f6f6fnobrArs Technica/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/1-3fd=Rurl=http://www.appleinsider.com/articles/08/11/21/apple_releases_iphone_software_v2_2.htmlcid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNF8yN5Ehog4dRQwKG4w9QkV37G1uwApple releases iPhone bSoftware/b v2.2/a font size=-1 color=#6f6f6fnobrApple Insider/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/1-4fd=Rurl=http://www.g4tv.com/thefeed/blog/post/691179/iPhone_Software_Update_22_Out_NOW.htmlcid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNGr8qVHyPG2nmU2zdCtiLt5lbvTCwnobrG4 TV/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/1-5fd=Rurl=http://www.infosyncworld.com/news/n/9932.htmlcid=1272850889ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNEFd6pvhmVybSLVz3n_0EOrtI5YuQnobrinfoSync World/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272850889hl=ennobrall 120 news articles/nobr/a/font/div/font/td/tr/table

Microsoft to offer free security software to attract beginners - eTaiwan News

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd width=80 align=center valign=topfont style=font-size:85%;font-family:arial,sans-serifa href=http://news.google.com/news/url?sa=Tct=us/2i-0fd=Rurl=http://www.canada.com/topics/technology/news/gizmos/story.html%3Fid%3Dacb3b045-9d46-4f3b-aa25-5447dd34d5b6cid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNE6JxjYr6V_3e-_mE42DkhpfbzqcAimg src=http://news.google.com/news?imgefp=2UkyZbz6Tp0Jimgurl=a123.g.akamai.net/f/123/12465/1d/media.canada.com/reuters/olustech_iptc/2008-10-28t011803z_01_btre49r03ot00_rtroptp_2_tech-us-china-microsoft.jpg%3Fsize%3Dl width=80 height=80 alt= border=1brfont size=-2Canada.com/font/a/font/tdtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/2-0fd=Rurl=http://www.etaiwannews.com/etn/news_content.php%3Fid%3D794127%26lang%3Deng_newscid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFTWG8XrQ4lCioYYkMpzZbcDjDzugMicrosoft to offer free security bsoftware/b to attract beginners/abrfont size=-1font color=#6f6f6feTaiwan News,nbsp;Taiwannbsp;-/font nobr19 hours ago/nobr/fontbrfont size=-119 to stop selling personal computer security bsoftware/b and to use free personal anti-virus bsoftware/b instead. The new bsoftware/b called Morro can support seven b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-1fd=Rurl=http://voices.washingtonpost.com/securityfix/2008/11/spamhaus_microsoft_now_5th_mos.html%3Fnav%3Drss_blogcid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNEOoTlhlTuASMxWW_GsZaObNUx-eASpamhaus: Microsoft Now 5th Most Spam Friendly ISP/a font size=-1 color=#6f6f6fnobrWashington Post/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-2fd=Rurl=http://www.reuters.com/article/technologyNews/idUSTRE4AI7T420081119cid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNEdbijYSjV5v7UgVfptkAJkooaRtgMicrosoft: New bsoftware/b not Symantec, McAfee rival/a font size=-1 color=#6f6f6fnobrReuters/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/2-3fd=Rurl=http://www.networkworld.com/news/2008/111808-microsoft-drops-onecare-antivirus.html%3Ft51hbcid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNGBlHMuQT4bbR3tvBLc8etV8AW0eQMicrosoft to offer free security bsoftware/b/a font size=-1 color=#6f6f6fnobrNetworkWorld.com/nobr/font/fontbrfont size=-1 class=pa href=http://news.google.com/news/url?sa=Tct=us/2-4fd=Rurl=http://www.allheadlinenews.com/articles/7013120895cid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFXdOgAx13aYQGwfG8ukihR4E6QSAnobrAHN/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/2-5fd=Rurl=http://online.wsj.com/article/SB122706587967940197.html%3Fmod%3Dgooglenews_wsjcid=1272030386ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNGXxEUW6RQH8QIRki8iasfV8vYYIwnobrWall Street Journal/nobr/a/fontbr/font class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272030386hl=ennobrall 304 news articles/nobr/a/font/div/font/td/tr/table

Traction Software Introduces Live Blog Micro-Messaging and End-of ... - MarketWatch

Hann’s On Software bouht by Mediware - Bizjournals.com

table border=0 width= valign=top cellpadding=2 cellspacing=7trtd valign=top class=jfont style=font-size:85%;font-family:arial,sans-serifbrdiv style=padding-top:0.8em;img alt= height=1 width=1/divdiv class=lha href=http://news.google.com/news/url?sa=Tct=us/4-0fd=Rurl=http://www.bizjournals.com/sanfrancisco/stories/2008/11/17/daily94.htmlcid=1272927325ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNGtzGhBSed7VMcq6rlumWswmEHeowHann’s On bSoftware/b bouht by Mediware/abrfont size=-1font color=#6f6f6fBizjournals.com,nbsp;NCnbsp;-/font nobr12 hours ago/nobr/fontbrfont size=-1Mediware Information Systems Inc. has bought the assets of Hann’s On bSoftware/b, a pharmacy-management bsoftware/b provider based in Santa Rosa, for $3.5 million b.../b/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-1fd=Rurl=http://www.marketwatch.com/news/story/Mediware-Acquisition-Adds-320-Pharmacy/story.aspx%3Fguid%3D%257BD97D6EA2-0A06-49FD-BE33-0A9811CA460D%257Dcid=1272927325ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFuTXQNPGin7hGBn0Lry5psPlaL_QMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrMarketWatch/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-2fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782712%26SMap%3D1cid=1272927325ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNHmi5YbO-9tCWNWJosVquYnoaaflgMediware Information buys assets of Hann#39;s On bSoftware/b - Quick Facts/a font size=-1 color=#6f6f6fnobrRTT News/nobr/font/fontbrfont size=-1a href=http://news.google.com/news/url?sa=Tct=us/4-3fd=Rurl=http://www.ibtimes.com/prnews/20081121/pharmacy-software.htmcid=1272927325ei=ZpYnSeA2lY71BN-0pRcusg=AFQjCNFIo9N8z3uLvVPW6RZyADIsB1gItgMediware Acquisition Adds 320 Pharmacy Facilities/a font size=-1 color=#6f6f6fnobrInternational Business Times/nobr/font/fontbrfont class=p size=-1a class=p href=http://news.google.com/news?sourceid=navclientie=ISO-8859-1rls=GGLG,GGLG:2005-22,GGLG:enncl=1272927325hl=ennobrall 19 news articles/nobr/a/font/div/font/td/tr/table

Vertical Releases Feature-Rich Software Update for Wave - MarketWatch

PAR Technology Corporation Releases Next Version of SpaSoft(R) Spa ... - MarketWatch

Progress Software and QAD Propose A Formula for The Perfect Lean ... - MarketWatch

DR Systems to Feature Software-Only, Enterprise Web-PACS for ... - MarketWatch

Check Point Software Announces Participation in Fourth Quarter ... - MarketWatch

Software - Google News

RELATED ARTICLES

Microsoft Great Plains Partner Selection: Overview
Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business Solutions ERP applications, serving to the whole spectrum of vertical and horizontal markets. Assuming that you already have one of these systems installed and implemented we would like to give you - IT director, Database Administrator, Programmer, Software Developer, Controller your options in supporting/upgrading Microsoft Great Plains for your companyIt is always good idea to install everything on your own - however Great Plains requires combination of computer networking, some programming, good accounting/distribution/logistics/reporting background - so it is not a surprise that Microsoft Business Solutions requires their customers to have specially assigner Microsoft Great Plains Partner/VAR/Reseller to serve the account.

My Experience - Making a Vision into Reality
Disclaimer: All the thoughts expressed are my views only! Your perception might differ..

Microsoft CRM Implementation & Remote Support
We would like to give you pluses and minuses of Microsoft CRM.Web and MS Outlook based client - this means that you don't need additional installations or training - everyone is using Outlook if you are on Windows XP/2000/2003SQL Server database - just to mentionIntegration with Microsoft Exchange 2003/2000 - this means that replies to CRM originated emails will be captured and store in CRM as activities for the Contact, Account or Lead.

Microsoft Great Plains Jewelry - Implementation & Customization Overview
Each Industry and market niche has business specific and unique requirements to ERP/Accounting System. Microsoft Business Solutions Great Plains is ERP platform, ready for third party modules additions and customizations, plus being SQL Server-based system it opens you wide spectrum of integration options and tools.

Adware and Spyware Blockers
The most important things you can do for your computer right now is to install adware and spyware blockers. Everyone is aware of computer viruses and run an anti-virus program to guard your computer against them.

Blind CC (Bcc): Master Its Use When E-Mailing
If you use Microsoft Outlook (or similar applications) for e-mailing, then you are familiar with the fields at the top of a new mail message, right? Of course, in the "To..

ERP System of the Future: Database, Business Logic and Interface
We will base our prognosis on our Microsoft Business Solutions ERP consulting practice: Microsoft Great Plains, Navision, Axapta, MS CRM. Also we've analyzed Oracle products: Oracle Financials, JD Edwards, PeopleSoft, and IBM Lotus Notes Domino.

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.

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.

Constructionalist Parsing - Deciphering Natural Language
The research in the field of Natural Language Processing usually assumes the existence of a syntactic "Generative Engine" that combines words and word-like elements into syntactic structures, and then sometimes displaces them by "syntactic movement". A Linguistic Parser must "undo" all the effects of syntactic movement, which results in a structure where the relations between the words are represented more directly.

It's Back!! WordPerfect's Amazing Comeback
Have you noticed WordPerfect is gearing up for a comeback in a big way? And fortunately, they are succeeding. If you're like me, an ole' diehard WordPerfect 5 user, this is music to my ears.

Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing
Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features: Lockbox Processing for Accounts Receivables, Customer/Vendor Consolidation, Multicurrency etc. We'll try to cover these features in the series of small articles to help decision maker and end user understand the feature and how does it work to make a decision to purchase additional nice modules.

A Symons Mark II Function Point Counting Example
I provide, here clear explanations and a count of function points, using the Symons Mark II method.We start by identifying the subprocesses (entry, exit, read, write) for each functional process; The size of a functional process is the sum of its data movements (entry, exit, read, write) and the size of a piece of software is the sum of the sizes of all of its functional processes.

Linux vs Windows Operating Systems
With so many Microsoft Windows related viruses, errors, and other software problems, many average computer users are looking at alternative operating system platforms, such as Linux. It is important that users, frustrated with Windows, don't simply install a version of Llinux without knowing what they are in for.

Microsoft CRM Integration with IBM Lotus Notes Domino - Machinery Dealership Example
IBM Lotus Notes with Domino email server is traditional document workflow management solution for large corporate business, where you need audit trail on approval cycle and decision making. Microsoft Business Solutions CRM is very cost efficient solution to automate sales process.

Unwanted Files
A LOT OF UNWANTED FILES.When you uninstall an item of software, there are generally a number of redundant files left behind to clutter up your hard drive.

Microsoft Navision Integration with Microsoft RMS - Overview for IT Specialist
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment).

Protect Your Computer...and Your Business!
We all take the computer for granted. I mean, all we have to do is switch it on and it's ready to go.

10 Steps To Secure And Manage Your Passwords
Passwords protect your most sensitive personal, financial and business information. They are the key to accessing membership, financial, and other web sites that you are a member of.

Great Plains Dexterity Programming - Overview For Developer
Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele.