Thursday, October 26, 2006

Microsoft Dynamics GP Dexterity Customization

by: Andrew Karasev

Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, eConnect, XML: Web Services.

Alba Spectrum Group is proud to announce Microsoft Great Plains Dexterity group development headcount increase. We are serving USA nation-wide from our Dexterity project management facilities in Houston, TX and Chicago, IL. Luis Leung (Alba Spectrum Texas) and Andrew Karasev (Alba Spectrum Illinois) are lead project managers for Microsoft Great Plains Dexterity customization, integration, reporting, form modification projects. Some Microsoft Dexterity technological features:

? Sanscript. This is Dexterity programming language. It is actually compiled and stored in Dynamics.dic with development source code. Dex is cursor oriented DB accessing programming language, however you can also call MS SQL Server stored procedures (with SQL Select statement aggregation logic)

? Alternate Forms. Technically you can modify any form you like in Dynamics.Dic ? original Microsoft Dynamics GP objects repository. But you might encounter future upgrade issues ? original forms are subject to redesign by Microsoft Dynamics subdivision without any notice

? Dexterity Reports. As software developer you can create new Dexterity report, assuming that you will also provide new Dex form, where report will be getting parameters

? Dexterity Alternatives. In 1990th the alternatives were VBA ? you could modify Greta Plains form with Modifier and include VBA scripting into your modification ? Dynamics.vba is the dictionary, storing your modification. In 2000th you have .Net instruments, such as eConnect with XML Web Services interface. Technically eConnect is very powerful, but comparing to Dexterity ? Dex has access to all Dynamics GP objects, while eConnect is secondary enabler ? it has access to objects, covered by eConnect development team. Future direction will probably give more options to Business Portal developer, using either eConnect or manipulating another future interface for Great Plains objects

? Dexterity Advancements. These are typically related to Microsoft Great Plains Source Code Programming. Very good extension is posting server, allowing ecommerce developer automatically post GP batches in such modules as Sales Order Processing, GL, Inventory Control, POP, and others

? Comparison to Other Microsoft Dynamics Products. Microsoft Dynamics ERP family include Axapta, Navision, Solomon and with some restrictions Microsoft CRM. Dexterity should be compared with similar technologies: Axapta Microsoft Dynamics AX ? MorphX / X++, Navision Microsoft Dynamics NAV C/SIDE

? Heterogeneous. Or cross platform software development: Oracle, IBM, Sybase, Ingress: Oracle Financials/Ebusiness Suite, Lotus Notes Domino. Microsoft SQL Server technology gives you Linked Server concept, Oracle gives you similar technologies, plus from Java/J2EE you can create various JDBC/ODBC bridges or native drivers

We are always available by phone: 1-866-528-0577, 1-630-961-5918,, or skype: albaspectrum

About The Author

Andrew Karasev, Alba Spectrum Group ( ), serving clients in USA Nationwide: Chicago, Houston, Dallas, Phoenix, Atlanta, Miami, San Francisco, Denver, Orlando, Washington, New York, Seattle, Minneapolis, New Orleans, Toledo, Detroit, Austin, Des Moines, Springfield, Naperville, Aurora, Schaumburg, Philadelphia, Pittsburgh, Boston, Canada: Montreal, Ontario, Vancouver, UK, Australia, New Zealand and internationally: India, China, Pakistan, France, Germany, Italy, Spain, Brazil, Argentina, Mexico, Chile, Colombia, Ireland.

This article was posted on October 24, 2006

1 comment:

JasonBourne said...

to develop customizations for dynamics gp you need a deeper knowledge of the schema/architecture of the table, columns and indexes. you might find this useful for custom programming of great plains dynamics, it's at http://GP-DYNAMICS.COM