|
Microsoft Dynamics GP 9.0 LATAM support, customization, upgrade, implementation - overview
By Mauricio Rubaja
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.
Please do not hesitate
to call or email us
México DF:
52-55-535-04027,
help@albaspectrum.com About the Author Mauricio Rubaja is Great Plains consultant
at Alba Spectrum Technologies (
http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains,
Navision, Axapta, MS CRM, Oracle Financials and IBM Lotus Domino Partner,
serving corporate customers in the following industries: Aerospace & Defense,
Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance,
Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising &
Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates,
Apparels, Durables, Manufacturing and having locations in multiple states and
internationally.
We are serving LATAM: Mexico, Peru,
Brazil, Bolivia, Venezuela, Colombia, Ecuador, Chili,
Paraguay, Uruguay, Argentina,
Dominican Republic, Puerto Rico
Article Source: http://www.simplysearch4it.com/article/19323.html
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/19323.html" as shown above and make it hyperlinked. |
Some other articles by Mauricio Rubaja | |
| |