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 http://www.greatplains.com.mx http://www.enterlogix.com.br ) - 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
|
This article was posted on January 26, 2006
Other Interesting Topics
Final Windows Uninstaller v2008.08 deletes files from incomplete uninstallations and also cleans up registry. It detects leftover files of various programs, lists applications that can be removed, then completely uninstalls them with one click. Using Submit My Software feature, users can upload difficult to uninstall application to server, and in 48 hr, receive update that solves issue. This ...
Microsoft has announced plans to offer free anti-virus software to PC users starting next year. The Redmond, Washington-based software giant said the software, code-named "Morro," will "provide comprehensive protection from malware including viruses, spyware, rootkits and trojans."
The median annual wage for computer support specialists in May 2007 was $45,300.
Open the door, Hal. Researchers at IBm are working on building a new computer platform that mimics the processing power of the human brain. The idea is to make it easier for PCs to process vast amounts of data in real time.
We have all experienced the excitement that comes with a new computer. Unfortunately, as many of us have experienced, pretty soon it takes twice as long for your computer to start, error messages start to appear, and gradually, you begin to notice that your computer is considerably slower while your frustration grows at an exponentially faster rate.
The Akoya P7300D desktop computer, available from Aldi shops, is something of a powerhouse. For instance, it uses an Intel Core 2 Quad Q8200 processor, which is one of the fastest you're likely to find in the shops without paying through the nose.
