Great Plains Customization Upgrade- Overview For CIO/IT Director

Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. Al these suites will be integrated into web-based Microsoft Business Portal

This move, probably wise in the long run, exposed businesses with heavily customized MBS products to serious customization upgrade problems. We'll give you our recommendation, based on our practice. In this article we'll talk about Microsoft Great Plains.

Great Plains Dexterity Customizations - Microsoft announced that its products will be moved to .Net platform. This means that Dexterity will be phased out/discontinued. However, even now Microsoft Great Plains 8.0 is still Dexterity-based application. So, if you have Dexterity customization - our recommendation is to phase it out or consider replacing it with these: Crystal Reports, SQL Stored Procs and triggers, Web Publishing (Visual Studio.Net) from Great Plains database, eConnect (SDK created to eCommerce developers to deploy Great Plains as back end)

Pervasive SQL/Ctree migration to MS SQL - If you are still on these old platforms - then you are in trouble - you will be without Microsoft technical support by the end of 2004. When you do standard data migration via migration tool - Great Plains tables are migrated by the tool, however migration tooll has no info about your custom tables - these tables should be migrated manually. You can use MSSQL Server Linked Server construction to link to Pervasive/Ctree data. ODBC drivers can be installed from GP CDs.

VBA/Modifier/Continuum - all these are good candidates for replacement by newer technologies, because these will not have their place in .Net platform.

Additional notes: When Great Plains Software designed Dexterity as the replacement to its discontinued Great Plains Accounting - it proclaimed that Dexterity is DB independent - which is true to some extent. However there are specifics, and Dexterity customization should be analyzed and tuned to work with MS SQL Server, if it was originally designed for btrieve/ctree. We are talking about customization upgrade for Great Plains Dynamics/eEnterprise 5.0, 5.5, 6.0, 7.0 to Microsoft Great Plains 8.0 or 7.5.

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

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

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.earthtimes.org/articles/show/epicor-comments-on-the-termination-of-elliott-associatesrsquo-tender-offer,632860.shtmlcid=1272902427ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNHlYzc582QF1NVflj4O3bDwCQ3-pAimg src=http://news.google.com/news?imgefp=-zwqhIcofgUJimgurl=www.earthtimes.org/newsimage/Bus_20081121191102_35.jpg width=80 height=80 alt= border=1brfont size=-2Earthtimes (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=er4nSdfRCZWO9QTftKUXusg=AFQjCNHjaDX0UG5HWsAQfVh2OgHDACiTNQElliott Terminates Tender Offer to Acquire Epicor bSoftware/b Corporation/abrfont size=-1font color=#6f6f6fMarketWatchnbsp;-/font nobr19 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNHSf-NhK2fRWDx12tNbwqoyhG3RgAEpicor 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNE_Mo8Y8cTE9I5TXqBS0PKTcSkUSQHedge 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNHqTZ4jEQv6H3AnbyNstADC_KuIdgUPDATE 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFi48urWwgq-i8PWEWYxQwAvfEVDgnobrRTT 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNHGJxvKCA6oMaaVoCrU6a3scZySVAnobrBarron'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 45 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFSf7ttMDRyHwZrl4AiNn5fqOf2hAimg 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNEzOiJ6QB3Jr-fwE5HNh_aVzlDKggThe best thing about the 2.2 iPhone bsoftware/b update/abrfont size=-1font color=#6f6f6fCNET News,nbsp;CAnbsp;-/font nobr12 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFvGBswmdY0T54aT_8WJ_Sk6LOJkgFirst 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNHPVa49x4KIDaj48VLsigrJp0TuUALots 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFHMBaxetsIxjE5n7fiSGPQjV9SugApple 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNGrbHKir9Bh-9jKUad1kmYuDnHsnQnobrG4 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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFArOZPA-ANmg3QNVLPtTlQOBqC-AnobrinfoSync 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 124 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://news.bbc.co.uk/1/hi/technology/7737520.stmcid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNFID3q9d-12Nt6_YXsX9swdOEH1Ogimg src=http://news.google.com/news?imgefp=ZEi3QvPWjUEJimgurl=newsimg.bbc.co.uk/media/images/45151000/jpg/_45151313_windowsindex.jpg width=80 height=60 alt= border=1brfont size=-2BBC News/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=er4nSdfRCZWO9QTftKUXusg=AFQjCNFs_AxB80UQ7wMsM7GhocGxByYMwgMicrosoft to offer free security bsoftware/b to attract beginners/abrfont size=-1font color=#6f6f6feTaiwan News,nbsp;Taiwannbsp;-/font nobr21 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://www.reuters.com/article/technologyNews/idUSTRE4AI7T420081119cid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNEaRui1ZuXg_228kimk7_RXwPf7EAMicrosoft: 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-2fd=Rurl=http://voices.washingtonpost.com/securityfix/2008/11/spamhaus_microsoft_now_5th_mos.html%3Fnav%3Drss_blogcid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNENwVfEO5a3PlnYxG3L1gIiFjM8tgSpamhaus: 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-3fd=Rurl=http://www.networkworld.com/news/2008/111808-microsoft-drops-onecare-antivirus.html%3Ft51hbcid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNF5mKG4_3Kr5taYLOUazPl9SDUCpgMicrosoft 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://online.wsj.com/article/SB122706587967940197.html%3Fmod%3Dgooglenews_wsjcid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNFQ_pg-QtrtpnB_MyAlON_W3iMfIwnobrWall Street Journal/nobr/anbsp;- a href=http://news.google.com/news/url?sa=Tct=us/2-5fd=Rurl=http://www.allheadlinenews.com/articles/7013120895cid=1272030386ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNH_kAtjUbgbNsysCPDMDHSENqQf9AnobrAHN/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

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

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/9-0fd=Rurl=http://www.bizjournals.com/sanfrancisco/stories/2008/11/17/daily94.htmlcid=1272927325ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNGTwwn6uH2e3Stvu5D3B5n_buLlngHann’s On bSoftware/b bouht by Mediware/abrfont size=-1font color=#6f6f6fBizjournals.com,nbsp;NCnbsp;-/font nobr15 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/9-1fd=Rurl=http://www.marketwatch.com/news/story/Mediware-Acquisition-Adds-320-Pharmacy/story.aspx%3Fguid%3D%257BD97D6EA2-0A06-49FD-BE33-0A9811CA460D%257Dcid=1272927325ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNFgtvxis_qs1aDIHr59BmLJvCx0jAMediware 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/9-2fd=Rurl=http://www.rttnews.com/ArticleView.aspx%3FId%3D782712%26SMap%3D1cid=1272927325ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNFig_KZGzVH7T3rv3r5ExlnZ_Ro0AMediware 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/9-3fd=Rurl=http://www.ibtimes.com/prnews/20081121/pharmacy-software.htmcid=1272927325ei=er4nSdfRCZWO9QTftKUXusg=AFQjCNHFyf1SDOa2w5OWOJyqPajTpUGDzgMediware 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

Software - Google News

RELATED ARTICLES

OSI Layers Model
IntroductionDuring the early years of our modern computer era, very few standards and protocols existed between various manufacturers. However, as time went on and computer technology continued to improve and become more widespread, it became apparent that standards would be necessary to ensure compatibility.

Microsoft CRM - Consulting in the Post-Recession Time
New post-recession era has new features, which didn't exist in late 1990th during high-tech boom. This will be in our opinion on new directions for Microsoft Business Solutions products consulting, including Microsoft CRM.

Microsoft Great Plains POP: Purchase Order Processing - Overview For Consultants
Great Plains Purchase Order Processing (POP) module makes up one-third of the core Great Plains Inventory and Order Processing group (the other two being Inventory Management and Sales Order Processing). POP seamlessly integrates with other Great Plains modules (GL, PM, FA, SOP, etc.

Imagine if Everyone Working In Your Office Was In Synch?
Microsoft-Outlook is a pretty amazing program. So much more than simply an e-mail client, it provides a task list, a powerful calendar with recurring scheduling capabilities, wonderful electronic sticky notes, mail-merge capability with MS-Word support and so much more.

40/sec to 500/sec
IntroductionSurprised, by the title? well, this is a tour of how we cracked the scalability jinx from handling a meagre 40 records per second to 500 records per second. Beware, most of the problems we faced were straight forward, so experienced people might find this superfluous.

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.

How to Tell You Have Spyware, Ad-ware or Viruses
Usually, the easiest way to tell you have spyware is because your PC is running at a reduced speed. The other way to check is to hit CTRL+ALT+DELETE and hit task manager (if you have windows service pack 2.

Computer Based Language Development and Spell-checking
Language development computer:Computer-based method for aiding language development seems like an interesting idea, the trick with this would be in getting the computer to take on part of the role of the human in the checking process.In all computer aided learning applications aimed at the very young, there is a danger that the computer may be seen as a replacement for a human instructor, however computer are notorious for not volunteering information or inability to deal with erratic behaviour.

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example
Microsoft Great Plains fits to majority of horizontals and retail business is good fit as well. We'll consider the system, consisting from Microsoft Great Plains as Accounting, Inventory Pricing and Microsoft Retail Management System (RMS) Headquarters and Store Operations Manager.

Microsoft Great Plains Upgrade - Version 8.0 Overview for IT Director/Controller
If you have Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains version upgrade and what is going on behind the scenes, which options do you have in case of Dexterity, VBA, SQL customizations, ctree/Pervasive migration to MS SQL/MSDE.� As of right now it is reasonable to upgrade to Microsoft Great Plains 8.

How Do I Get Rid Of That Darn Spyware?
Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware.

Enterprise Resource Planning Overview
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP.What is ERP?Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions.

These Items Are A Must Before Making The Decision To Purchase Any Off-The-Shelf Software
1. What determines the software price? Is it Per Seat or Per User or Per Processor?The cost of software is determined in many ways.

Groupware: What Works the Way Businesses Do?
GroupwareThe internet is full of 1.5 million to 7 million indexed pages of groupware packages available on the market today.

Partitioning, Formatting and Reinstalling in Windows 98
Formatting and reinstalling windows 98 is very easy if you have the right know-how.This article will discuss how to format, partition and reinstall windows 98 on your PC.

Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators
How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'.

Microsoft CRM Development
Microsoft CRM is CRM answer from Microsoft Business Solutions.The whole conception behind CRM seems to be different.

Twelve Things You Should Know to Save on Computer Software
Do you want to get quality software at a reasonable price? Whether you work at home or just need good software for your personal computer, you are faced with an almost endless selection of computer software. Sorting through the options can sometimes be a major task.

Microsoft CRM Implementation & Customization: MS CRM Fax Gateway
With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion.Microsoft CRM at this moment doesn't have advanced fax automation - you can register the fact of fax receiving or sending, but it is not sufficient for your daily work with your clients.

Crystal Reports For Microsoft Navision - Overview For Programmer/IT Specialist
Let us give you - developer some hints in the report creation.C/SIDE database - use C/ODBC to create the connection for your Crystal Report.