Microsoft Dynamics GP 9.0 LATAM support, customization, upgrade, implementation - overview for consultant
With the recent move to new naming – Microsoft Dynamics GP, former Microsoft Great Plains / Great Plains Software Dynamics & eEnterprise 4.0, 5.0, 5.5, 6.0, 7.0, 7.5, 8.0 and now Dynamics GP 9.0 is the product with multiple series and interfaces: Great Plains Dexterity “fat” client, MS Business Portal, FRx, Crystal Reports & now MS SQL Server Reporting Services. For the majority of the existing clients spread over the whole LATAM: Latin America continent: from Mexico & Caribbean to Argentina & Chile, Microsoft Great Plains is associated with the standard client interface: Dex.exe working with DYNAMICS.DIC dictionary – this is where Financial: GL, AR, AP, Payroll, Distributions: SOP, IV, POP modules are coded. Very often we see the case when customer is still on version 6.0 or 7.5 on Pervasive SQL or Ctree database platforms, not supported (effective 2004) by Microsoft Business Solutions technical support any more. In this small article we are trying to orient IT managers of Latin American companies with Microsoft Dynamics GP migration path, upgrade, data conversion, integration, custom development.
Microsoft Dexterity. Great Plains Software Dexterity, now it should be considered as the legacy IDE/programming language was architectured by Great Plains Software as pioneered Graphical and Database platform independent C-shell in earlier 1990th. If you remember those nice and optimistic days – nobody could predict which graphical platform will win: Microsoft Windows, Macintosh MAC OS, Sun Solaris or something else. GPS designed graphical shell to be kind of platform independent (better say – be able to switch from one platform to another with relatively low level of redevelopment). The second principle was Database platform independence – Oracle, Sybase, Ingress, Microsoft SQL Server, IBM DB 2, potentially Lotus Notes Domino – Dexterity was first designed for Pervasive SQL and Ctree/Faircomm, then MS SQL Server 6.5 – Microsoft Dynamics C/S+. Now, when Microsoft purchased GPS – the actuality of being Graphics and DB independent vanished and Microsoft Dynamics GP is available for on Windows only and for MS SQL Server 2000/2005.
Technical FAQ. The most popular question was and still is – how to delete user who is hung up in Great Plains. Here is the answer: delete activity where userid=’jorge’ – run this statement against DYNAMICS DB and replace Jorge with actual user id in Great Plains. Second question by popularity is how to unlock hanging batch: update SY00500 set … then before you design it – look at the other “good” batches and check which is their batch status field – change batch status field to zero for the problem batch – SY00500 is in the Company database. If the crash was to severe – you need to clear SY00800 table as well – this one sits in DYNAMICS database.
Customizations. Even if you as the developer have now more options: eConnect, advanced tools in Integrations Manager, Visual Studio.Net with eConnect extensions and web services exposed eConnect methods – we still expect high demand for Microsoft Dexterity customizations and Dexterity development. Dexterity development is usually done over DYNAMICS.DIC and often requires access to Dexterity source code (DYNAMICS.DIC with sanscripts codes in it). Besides Dexterity, due to the high popularity of eConnect we expect high demand on SQL Stored procs programming – especially posting extensions for eConnect, all the kinds of SOP processing stored procedures for eCommerce web development, such as integrations with Microsoft RMS, credit card processing modules connection, etc.
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Germany, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Web Development Projects - Developers Tools Tips
Open source usually refers to software that is released with source code under a license that ensur - A Guide to Cnc Kits
Building a CNC machine means that you would require a lot of tools, parts or different components. - Xlphoto Printing, the Best Choice for Banner Printing and Poster Printing
Suppose, you have visited a tourist spot or a hill station; over there, you have witnessed some of - Reliable Software Programming
Software reliability is an important facet of software quality. It is defined as "the probability - Designing an Ecommerce Site
In a recent article I talked about Google AdSense placement based on eye-tracking research. Howeve - Asp.net Development Benefits
Rightway solution has been keenly looking out for. Microsoft ASP.NET is a free technology that allo - Choosing Offshore Software Development Company
To turn into successful and gain the full benefits of software outsourcing, you require preferring - E-commerce and Web Portal Development in Vietnam
VIETNAM, owing to its superior intellectual capital has emerged as the ultimate destination for - Types of Softwares
Computer software is a general term used to describe a collection of computer programs, procedur - Offshore it Out Sourcing Consultancy in Vietnam
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing
Most viewed articles in this category:
- Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
Oracle recommends every company that installs Oracle Applications to avoid any customization, but I - Offshore Outsourcing: An All Win Premise
The awareness that outsourcing can boost productivity sans forfeit of class has impelled MNC’s - Oracle E-Business Suite vs. Microsoft Dynamics AX - Axapta: LATAM and Brazil
In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider M - SAP Business One vs. Microsoft Dynamics GP - highlights for consultant
In this small article we will not make side-by-side technical specs comparison. We would rathe - Microsoft Great Plains - licensing and product versions
Current Microsoft Business Solutions Great Plains has more that 10 years of history. Former Gr - OCR Software - Optical Character Recognition or Optical Crud Recognition?
Optical Character Recognition (OCR) refers to a software technology and processes that involve the t - Microsoft Dynamics AX - Axapta - technical notes plus customization
Axapta or current name Microsoft Dynamics AX has one of the newest ERP design and architecture among - Microsoft Dynamics AX-GP-NAV-CRM: trends and international recommendations
Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics - Microsoft Moves to Small Business Accounting/Retail Market - stakes and thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Serve - Microsoft Axapta - Dynamics AX: Brazilian Portuguese version - consultant highlights
Axapta/Microsoft Dynamics AX short overview. Navision Axapta was designed by Navision Software