Dynamics,Customizations,Dex,ED computer Dynamics GP Customizations: Dex, EDI, eConnect, Crystal
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
In this small publication we are offering the approach, whenyour business processes are unique and you cannot deploy standard GP businesslogic or one of the existing Great Plains ISV add-ons or third party modules. Having this situation foreseen, we would liketo recommend you considering solutions tuning approach, when you are gettingexisting products code fragments and you modify or adapt existing code to fityour unique business processes: 1. Great Plains Dexterity. This is the architecture, it has its ownprogramming or better say scripting language Sanscript, Integrated DevelopmentEnvironment and such business logic dictionaries, as Dynamics.dic are inessence Dex logic metadata. Solutions inDexterity are products, deployed for restricted list of customers. Typically you do not pay high price for thesolution code, however you have the budget to alter the code to fit your uniquebusiness processes requirements. Dexterity has relatively long learning curve and it also requires modulepurchase if you are end customer, we recommend you to contract Dexprogrammers or Great Plains Technology Partner 2. Electronic Document Interchange. In some cases EDI is formalized and you canpurchase third party add-on, which should allow you to map code, typicallyfixed length text files. However, if youthink about simplicity to parse code in SQL formatted Select statement you maydecide to save the money and make simple SQL programming exercise. Usually you will need to deploy EDI via ODBCconnection to Text file, consider deploying MS SQL Linked Server, reading textfile and exposing it to Select statement formatting 3. eConnect SDK. eConnect is work and master files level of Dexterity code, replicated inSQL encrypted stored procedures. It isfriendly to Microsoft Visual Studio generic programmer, assuming you got quicktraining in Dynamics objects: customer, vendor, Sales Invoice, Purchase Order,GL account, etc. This tool is great foreCommerce web programming, it lacks batch posting methods, we recommend you todeploy Autopost, if posting is required directly from ecommerce application 4. Crystal Reports. In contrast to FRx Financial Reporting (that is rather end userfinancials reports designing tool), Crystal is associated with custom logic andis more flexible. If you plan to docross-modules tables join, then Crystal could be the way to go. We recommend you to consider basing report onSQL Stored procedure (the most powerful, where you can deploy intermediate temptables) or view. Other reporting toolsto consider: SQL Server Reporting Services or SSRS this tool is coming freewith SQL Server purchase, plus it is naturally web application
Dynamics,Customizations,Dex,ED