Microsoft Dynamics GP: new customization options – Alba Spectrum
Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918,
help@albaspectrum.com
In this small article we would like to review the way to
revise and redeploy legacy Microsoft Dexterity customization, which is probably
still in production mode in your company. Former Great Plains Software Dynamics
and eEnterprise product lines were under extensive tailoring to fit business
processes back in 1990th. Now it is time to upgrade to Microsoft
Dynamics GP 9.0 and redesign custom logic
- eConnect. This tool and connector allows you
to manipulate: create, modify, delete and change GP objects, such as
Customer, SOP Invoice, Purchase Order, Employee, etc.
- Extender. This tool allows you to create new
GP screens and tables and associate them with GP native screens, such as
Customer maintenance
- Microsoft Visual Studio. When you deploy
eConnect and custom tables, created by Extender, you may consider create DLL
project in Visual Studio.Net to add business logic
- Dexterity retro. Great Plains Dexterity allows
you to create screens, which will be integrated into Microsoft Dynamics GP
workstation (and specific GP user) security realm. In this case you can
call DLL procedures, created in MS VS as suggested above directly from
Microsoft Dynamics GP Dexterity sancscript scripts in either GP alternate or
new dexterity form
- Dexterity relicts. There are Dex legacy
techniques, that needs to migrated to new technologies. One of these
dinosaurs is dexterity cursors. You will see that they are really slow
bottlenecks if your custom logic requires huge data processing. This is
similar to cursors in Microsoft transact SQL – it is a way slow comparing to
aggregated select statement. Historically dex cursors enabled
multi-platform DB support: ctree, faircom/btrieve/Pervasive SQL and MS SQL
Server 6.5/7.0. When Microsoft Business Solutions was formed on the base of
former GPS – Microsoft decided to concentrate on MS SQL Server platform only
Alba Spectrum Group:
http://www.albaspectrum.com
help@albaspectrum.com . Please feel free to call us: 1-866-528-0577,
1-630-961-5918. We are serving MS Dynamics GP clients US nationwide with
customers in Chicago, Houston, Dallas, Los Angeles, Atlanta, San Francisco, New
York, Miami, Orlando, New Orleans, Phoenix, Denver, Seattle, Milwaukee,
Montreal, Toronto and internationally: Palau, Sao Paulo & Curitiba Brazil,
Cayman Islands, Israel, New Zealand, Australia. Local service in Illinois:
Naperville, Lisle, Bolingbrook, Wheaton, Lombard, Aurora, Villa Park, Joliet, in
Texas: Richmond, Katy, Rosenberg, Sugar Land, Missouri City, Meadows