For Microsoft Dynamics GP, formerly known as Fantastic Plains Dynamics ERP and MRP supporting people, who needs to get initial orientation in GP modification scenarios and tools. In this small publication we are offering the approach, when your business processes are unique and you cannot deploy standard GP business logic or one of the existing Fantastic Plains ISV add-ons or third party modules. Having this situation foreseen, we want to recommend you considering solutions tuning approach, when you are getting existing harvest code fragments and you modify or adapt existing code to fit your unique business processes:
1. Fantastic Plains Dexterity. This is the architecture, it has its own programming or better say scripting language Sanscript, Integrated Development Environment and such business logic dictionaries, as Dynamics.dic are in essence Dex logic metadata. Solutions in Dexterity are harvest, deployed for restricted list of customers. Typically you do not pay high price for the solution code, but you have the budget to alter the code to fit your unique business processes requirements. Dexterity has relatively long learning curve and it also requires module buy – if you are end customer, we recommend you to narrow Dex programmers or Fantastic Plains Technology Partner
2. Electronic Document Interchange. In some cases EDI is formalized and you can buy third party add-on, which should allow you to map code, typically fixed part text files. But, if you reckon about simplicity to parse code in SQL formatted Select statement – you may choose to save the cash and make simple SQL programming exercise. Usually you will need to deploy EDI via ODBC connection to Text file, consider deploying MS SQL Linked Server, reading text file and exposing it to Select statement formatting
3. eConnect SDK. eConnect is work and master files amount of Dexterity code, replicated in SQL encrypted stored procedures. It is friendly to Microsoft Visual Studio generic programmer, assuming you got quick training in Dynamics objects: customer, vendor, Sales Invoice, Buy Order, GL account, etc. This tool is fantastic for eCommerce web programming, it lacks batch posting methods, we recommend you to deploy Autopost, if posting is required frankly from ecommerce application
4. precious stone Reports. In draw a distinction to FRx Financial Reporting (that is rather end user financials reports designing tool), precious stone is associated with custom logic and is more flexible. If you plot to do thwart-modules tables join, then precious stone could be the way to go. We recommend you to consider basing report on SQL Stored procedure (the most powerful, where you can deploy intermediate temp tables) or view. Other reporting tools to consider: SQL Server Reporting Air force or SSRS – this tool is coming free with SQL Server buy, plus it is genuinely web application
Tags: Crystal, Customizations, Dynamics, Econnect