Home            Links 



 


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.  Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.

However Great Plains 7.5 and even 8.0 is Dexterity based application, so you have to deal with it and it's customization.

 

Good news.  Prior to version 7.0 Great Plains had plans on expanding GP functionality and so was changing tables structure ? forcing Dexterity customization to be analyzed and partially rewritten with each upgrade.  Not any more ? GP structure stays the same ? Microsoft is doing new modules acquisition and unifying it's graphical interface to move all it's ERP packages: Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.

 

Still pain.  Dexterity has possibility to customize existing Great Plains screens, so called Alternative Great Plains forms.  This was upgrade problem in the past and it stays now ? there is no way to do it in house (until you are willing to pay for full-time internal developer ? who is usually in the learning curve).  You got to bring in consultant.

Recommended approach.  You should have the strategy to migrate Dexterity customization to SQL, Crystal Reports, custom web publishing ? Visual Studio.net and slowly abandon Dexterity customization

  • SQL Stored procedures - performance improvement.  Consider replacing dexterity data manipulation with SQL stored procedures.  Dexterity is cursor-driven language and it is not efficient when processing huge datasets.
  • Crystal Reports.  Take advantage of open and leading technology.  Crystal Reports will eliminate the need in the future for painstaking Dexterity reports upgrade.  Base you Crystal report on the SQL view or stored proc
  • Do direct web publishing off your GP database.  Use Visual Studio ? it is easy to find specialists and have them in staff.  We are in the World when web publishing is very easy.
  • Good luck 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-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, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.



    Advent Software to Host Analyst and Investor Day Event on Friday, May 11, 2012
    Reuters
    SAN FRANCISCO - February 6, 2012 - Advent Software, Inc. (NASDAQ: ADVS), will hold its Analyst and Investor Day in New York on Friday, May 11, 2012, beginning at 9:00 am (EST). The meeting will feature presentations by Advent's executive team covering ...
    Advent Software Achieves Record Quarterly Revenue of $86 Million and Record ...MarketWatch (press release)
    Advent Software's CEO Discusses Q4 2011 Results - Earnings Call TranscriptTheStreet.com
    Advent Software Q4 Profit Drops; Issues Q1, FY12 Revenue Outlook - Quick FactsNASDAQ

    all 13 news articles »


    Scorpion Software Announces AuthAnvil Single Sign On Support for Level ...
    San Francisco Chronicle (press release)
    Scorpion Software, an industry leader in strong authentication and password management solutions for IT Service Providers and IT departments is pleased to announce integrated support for AuthAnvil Password Solutions with Level Platforms, ...
    Scorpion Software Offers Support for Level Platforms Managed WorkplaceThe Complete Managed Services Resource

    all 2 news articles »


    Caduceus Software Plans to Integrate a Cloud Platform with its Software ...
    SmallCap Network
    By Ed Liston Caduceus Software Systems Corp. (OTC: CSOC), a software company specializing in the development of an all-in-one solution for private practitioners and doctors, today, said that it plans to integrate a cloud platform with software systems.
    Caduceus Software Systems Corp. Plans to Integrate a Cloud Platform with its ...MarketWatch (press release)
    QualityStocks News - Caduceus Software Systems Provides Update on Current ...PR Web (press release)

    all 14 news articles »


    Proposal Software Continues Strong SaaS Revenue Growth in 2011
    MarketWatch (press release)
    WESTPORT, Conn., Feb 06, 2012 (BUSINESS WIRE) -- Proposal Software, Inc. (PSI), The Leader In Proposal Productivity(TM), and makers of PMAPS(R) WebPro (Proposal Management and Production System) announced 2011 results that continue its systemic growth ...

    and more »


    Manhattan Software Announces Strategic Partnership With Indiabulls for ...
    MarketWatch (press release)
    6, 2012 /PRNewswire via COMTEX/ -- Manhattan Software, the global leader in enterprise real estate software and a leader in the 2011 Gartner Magic Quadrant for Integrated Workplace Management Systems, announced today a strategic partnership with ...

    and more »


    Mezeo Software Announces National Master Distributor for Japan
    MarketWatch (press release)
    HOUSTON, TX, Feb 06, 2012 (MARKETWIRE via COMTEX) -- Mezeo Software(R), a leading provider of cloud storage management solutions, today announced the appointment of a master distributor for Japan, AIR Company Limited, a Japanese company focused on ...

    and more »


    The Cloud Software Companies You Need to Know About
    Motley Fool
    But software as a service is easy enough to define. Whenever you have to access your application through a central location, and pay ongoing license fees to the developer, that's generally software as a service. Microsoft's Office suite is plain old ...

    and more »


    Is BMC Software Growing or Slowing?
    DailyFinance
    By Seth Jayson, The Motley Fool Posted 4:11PM 02/06/12 Investing There's no foolproof way to know the future for BMC Software (NAS: BMC) or any other company. However, certain clues may help you see potential stumbles before they happen -- and before ...

    and more »


    Oakland police get free forensic software to analyze Occupy videos
    San Francisco Chronicle (blog)
    A Pasadena forensic video enhancement software company has donated its technology to Oakland police to help in capturing the goings-on at Occupy Oakland demonstrations, the company announced in a statement. At the request of Oakland law enforcement, ...

    and more »


    Longwood Software Establishes Strategic Reseller Agreement with Canada's Interlinc
    MarketWatch (press release)
    MAYNARD, Mass., Feb 06, 2012 (BUSINESS WIRE) -- Longwood Software, Inc., the developers and marketers of the RevBase(R) software-as-a-service (SaaS) marketing asset management system ( www.revbase.com ), announced today a strategic reseller agreement ...

    and more »

    Google News

    Related Articles
    About Microsoft Sysprep (System Preparation) Utility (Windows 2000)
    The Microsoft system preparation utility for Windows 2000 is a very handy tool for network support shops that deploy PC images as a means of reformatting PC's with problems. Sysprep basically strips out all the hardware information and unique information from that specific PC, which allows you to deploy the image created from that PC on to many other PC's with different hardware configurations.
    Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight
    Microsoft Business Solutions Great Plains has many years of successful implementation in multiple horizontal markets. In today's small article we'll share our experience of implementing and customizing Microsoft Great Plains, formerly Great Plains eEnterprise/Dynamics in beverage production and distribution industries. These examples will cover two scenarios: US regional distribution and International fruit punch production and sales in US, Latin America and Europe. We'll try to be industry specific and at the same time technical ? using Microsoft Great Plains technical & customization terminology to address both ? decision makers and technical consultant / programmer.
    Performance Tuning of a Daffodil DB / One$DB -JDBC Application
    This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Choosing the right statement interfaces and right methods according to your SQL query plays a vital role in improving the performance of a JDBC Driver.
    You Can Write Microsoft Office Program in About 60 Minutes
    Microsoft Office program is a programming tool called Visual Basic for Applications (VBA) that comes with Microsoft Excel, Word, Outlook, Power Point, and Publisher. VBA can make your repeating jobs automatic. It also can customize Excel, Word and other Office procedures for your own needs. From Office version 2000, all the Office programs are equipped with VBA.
    Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer
    In 2004 Oracle, Inc. made its new step toward J2EE application development simplification, releasing new RAD Oracle JDeveloper 10G. First of all JDeveloper 10G is targeted to rapid web application building, utilizing all the achievements of J2EE World: web service, EJB, MVC frameworks, XML, etc. Oracle JDeveloper 10G allows you to conduct all full development cycle for complex system ? from UML diagram-based concept to debugging, profiling and deployment.
    Microsoft RMS ? Great Plains Integration ? Overview For IT Specialist
    Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS) are getting new market share due to the Microsoft strong marketing campaign. Both products: Microsoft Great Plains and Microsoft RMS are coming from the same Microsoft subdivision - Microsoft Business Solutions (MBS), however due to the fact that both products were bought by Microsoft from different vendors, the integration between the two is not an easy thing. At this time MBS has RMS integration on the General Ledger and Purchase Order level into Great Plains out of the box. This integration has some advancements in comparison to old product: QuickSell, but it is still GL and PO only. We do understand the need for midsize and large retail companies, structured as clubs and selling on account to their members to have more adequate integration when you can synchronize your Sales information and have robust Great Plains reporting. There is the product on the market, which is integration on the Receivables Management level from RMS to Great Plains, written by Daniel Sionov and Andrew Karasev and maintained by the alliance between LightEdge Solutions (www.lightedge.com) and Alba Spectrum Technologies (www.albaspectrum.com). In Alba Spectrum Technologies we actually do coding and product tuning for specific client needs.
    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. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0
    Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool
    DBxtra is a powerful query and reporting tool that hides many of the complexity and technical expertise required for creating connections to disperse data sources, building queries, designing reports, and delivery information throughout an enterprise or to your customer base.
    IBM Lotus Domino or Microsoft Exchange?
    IBM Lotus Domino or Microsoft Exchange?
    Microsoft Great Plains Nationwide Remote Support
    ERP Consulting industry is on the way to serve clients nationwide and even worldwide, when the client is multinational corporation. There are several reasons to specialize in remote support. In this small article we'll give you these reasons and the advantages of remote installation, customization, integration, programming, reporting.
    Microsoft CRM Integration With Microsoft Office Documents ? Overview For System Integrator
    Microsoft CRM is CRM application, maintained and supported by Microsoft Business Solutions. Microsoft CRM utilizes majority of the Microsoft technologies: Windows Active Directory, SQL Server, MS Exchange, BizTalk (integration with MS Great Plains, and soon with Navision), Message Queuing, .Net web services to name a few. There is market demand on the efficient integration of MS Office documents into Microsoft CRM. Let's take a look at the options:
    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. CRM is a term that can be applied to software and an entire business strategy.
    Microsoft C# vs. VB.Net
    Hi, Guys,
    Microsoft Blues
    With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum.
    5 Time-Saving Tips in Microsoft Word
    Whether you have used Microsoft Word for years, have just switched from WordPerfect or are new to word processing, try these easy steps to save time and simplify your work in Word:
    Microsoft RMS Customization ? PO Items Receiving in Great Plains
    Microsoft Retail Management (RMS) and Microsoft Great Plains are retail and accounting/ERP solutions coming from the same Microsoft subdivision ? Microsoft Business Solutions. There is often common need to do integration between the two. Despite the fact that both systems come from the same software development company ? the integration is not as simple as it probably should be.
    Dont Choose Adobe When Working With PDF
    While Adobe is the most known maker of PDF tools, your business will be much better off, if you select third party tools to work with PDF documents.
    Software Upgrades Arent Always the Best Move
    When my daughter was getting into AOL instant messaging (AIM) and using all the cool add-ons, I looked for more as it's a great way to learn about extending applications. While doing research, I learned that if you wanted to use AIM themes, you don't want to upgrade to AIM 5.9. A post at MyThemes suggests sticking with or downgrading to 5.5. MyTheme shows what steps to take, should you prefer to stick with 5.9. The post also shows where to download 5.5 and how to downgrade back to it. Furthermore, 5.9 was bloated. Think it took a while for AIM to completely load in 5.5? 5.9 is worse.
    Microsoft Great Plains Inventory Control ? Overview For Consultant
    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 Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features.
    Selecting Corporate ERP: Microsoft Business Solutions Great Plains ? Estimation Parameters
    As we could imagine, if you are reading this article ? you are in the decision making mode, probably replacing legacy system with the new one or abandoning either Unix/Mainframe or Apple direction for your corporation. In any case, nobody should make an outside influence on your decision ? you should be maximally objective. Let us give you our estimates and the parameters to check on the pool of the possible ERPs/MRPs.



    Common misspellings for words used in this page include abondon abondoning abreviated accoring acheivements acheivments achievments achivements acording actualy adbandon addres adecuate adn adres adress ahev ahve alsot amke amking anbd aplication aplied applicaiton aquisition artical artice articel aslo bakc baout basicaly basicly bcak betwen bewteen buisness busineses busness bussiness comany comapany comming comparision completelyl consept consulant controll coudl creaeted dael decison delevopment descision desgined desigining dessigned developement develpment devolopement diferent diferrent differnt diffrent distrubution doccuments doign donig eahc eearly effecient efficent eiter ened equiped experiance expierence eyars eyasr fidn focusses fomr formelly frome gerat gogin goign gonig graet grat haev howver htere htis hvae hvaing hvea hwihc hwile implamenting inbetween indepedence independance independece indipendence infomation informtion inot inproving intergration inudstry iwll iwth jstu jsut knwo konw kwno laguage larg leran levle liek liuke majoroty mantained marjority marketting messenging mkae mkaing mkea moreso mroe nkow nkwo nmae nowe nto oftenly oging omre otehr owrk owudl partialy pary performence possable possibile possibilty possiblility possiblilty possiblity poverful poweful powerfull prepartion preperation probablly probaly probelm proccessing propietary proprietory raelly realy realyl recquired relaly repid requred rewitten severeal shoudl shoudln slowy smae smoe soem sofware sould specfic specif startegy statment stlye stong stradegy stucture stuctured sturcture succesful successfull succsessfull sucesful sucessful sucessfull sytem sytle taht targetted tath teh tghe thast theese ther theri thgat thge thier thoughout thrid througout thsi thta thyat tiem tihs timne tiome tje tjhe tkae towrad twpo tyhat uise unsed usally useing usualy ususally vell verison vetween veyr vrey vyer vyre waht wass watn weas wehn whant whcih whic whihc whith whlch whn whta wich wiew wih wiht wille witht witn wiull wnat wnated wokr woudl writen wrok ws wtih wupport yeasr yeras yersa ytou yuo.