Information » gramming lang

Dynamics GP Modification: Technologies Wholesale Jerseys China Free Shipping , Recommendations Computers Articles | December 23, 2010
With latest versions Dynamics GP 2010, 10.0 and even 9.0 Microsoft Business Solutions introduced numerous improvements and flexibilities from the client application interface, however these are mostly...


With latest versions Dynamics GP 2010, 10.0 and even 9.0 Microsoft Business Solutions introduced numerous improvements and flexibilities from the client application interface, however these are mostly from metrics, custom first page Wholesale Jerseys Online , workflow, integration with Microsoft Office stack.? If you need to alter application business logic, you may need to appeal to such customization tools as Modifier with VBA, Dexterity, SDK for Visual Studio (typically some Dexterity knowledge is recommended to create new custom table, for example).? Let?s review the methodologies and recommendations:


1.?Modifier with VBA scripting.? This tool does just what the name suggests, it allows you to include the Windows into modification dictionary (it would be FORMS.DIC for code product Dynamics GP Wholesale Jerseys Free Shipping , you can review this in Dynamics.set file, where Dynamics product has number zero, and respectively modified forms go to Forms.dic and modified reports into Reports.dic).? Now the modification in Modifier ? you can reposition existing fields, move them out of the form visible are.? And plus you can add new fields ? these ones you probably want to be present in Great Plains company database.? In order to manage fields associated records you would need to program VBA script with opening old-fashioned Microsoft ADO connection and insert, update or select fields through ADO.? Please, note, that VBA is not Microsoft .Net compliant language ? you will need to recollect your old days experience programming in old Microsoft Visual Studio.? The same flavor of VBA was available for Microsoft Excel programming.? And ? you can find VBA programmer manual for Dynamics GP Modifier module.? There are also very elegant solutions to translate Dynamics GP String resources into foreign language and make them available through Modifier (these string resources will go to Forms.dic ? you will need Customization Site Enabler license to exercise this option).? However do not be over optimistic Wholesale Jerseys From China , this option is available for the languages, compliant to ASCII (one byte), including Arabic, Russian, Persian, etc.? It is not available for Unicode based languages: usually where you deploy hieroglyphs: Chinese, Japanese Wholesale Jerseys China , Korean


2.?Report Writer.? This tool modifies reports in GP.? The most popular would be SOP Blank Invoice Form (I would bet that you need your company logo on the Invoice), Payable Check (usually graphical version).? In RW, besides basic apparent functionality you can also appeal to such techniques, as adding new table relations, adding new tables to the report.? Plus, if you need to pull the fields, not available through current or even new tables relations Wholesale Jerseys , you can add report to Dexterity customization, in Dex then add custom function with re_ prefix, which pulls the field, calling SQL Select statement (or doing the same in Dexterity selection mechanism) or even call SQL Stored procedure.? Then this report will be alternate and you can modify it in Report Writer, where rw_ function will be available.? Do not forget to change user security ? this report is now classified as Alternate Modified one (in Dynamics GP 2010 and 10.0 this is System -> Security -> AlternateModified Forms and Reports).? Report Writer allows you to export reports as Customization Packages in Tools -> Customize -> Customization Maintenance.? You are not really restricted to RW, if you need your reports to look professionally, you may do them in such tools as Crystal Reports Wholesale Soccer Hats , SSRS (Microsoft SQL Server Reporting Services), and even if you are Microsoft Access programmer and you are comfortable with Access reporting, feel free to connect MS Access to Dynamics GP database via ODBC


3.?Microsoft Dexterity.? This is all-mighty Great Plains customization tool.? Dexterity has its own IDE (Integrated Development Environment) as well as programming language Sanscript.? However, we have to recommend you to be conservative and do not plan to train your internal IT programmers, as Dexterity is proprietary technology and requires long learning and experience solidification time.? This learning curve might b