| Microsoft Dynamics GP should be considered as | | | | Orders and placing EDI inventory |
| ERP technical platform, which is open for | | | | replenishment PO to your EDI nationwide |
| software developers through such technologies | | | | vendor, then consider SQL stored procedure |
| as SQL Stored Procedures, Microsoft | | | | approach. Stored Procedure is capable to |
| Dexterity, Extender, VBA scripting and | | | | create EDI header, lines, trailing end and |
| Modifier, SRS, Crystal Reports, GP | | | | export this in typically fixed length EDI |
| Integration Manager, MS Visual Studio SDK, | | | | text file |
| eConnect, GP Report Writer to name the most | | | | |
| popular. If you are programmer, who just got | | | | 3. GP user interface modifications. Here you |
| the project to alter or extend GP business | | | | need to review Dexterity, Modifier and |
| logic, you need to review and compare | | | | Extender. We do not really recommend you to |
| modification instruments to select the best | | | | dive on your own into Dexterity realm, you |
| fit. Let's review popular customizations: | | | | should rather subcontract dex customization. |
| | | | Modifier allows you quickly alter GP screens |
| 1. eCommerce integration. Here you should | | | | and modify business logic with VBA scripts |
| consider eConnect if you need real time | | | | |
| integration and Great Plains Integration | | | | 4. Reporting. Here you are free to select |
| Manager, if you are OK with scheduled or | | | | either one: SRS (or Microsoft SQL Server |
| overnight data synchronization. eConnect | | | | Reporting Services), Crystal Reports, Report |
| requires C# or VB.Net programming skills, | | | | Writer, or FRx (this one only if dealing with |
| while IM requires VBA scripting if you need | | | | pure financial reports: Balance Sheet, Profit |
| to intervene into standard integration logic | | | | & Loss, Cash Flow) |
| | | | |
| 2. EDI integration. Here you have two | | | | 5. Data Conversions. It is not really a |
| scenarios: exporting from GP and importing to | | | | customization, rather initial data massage |
| GP. If you are just exporting Purchase | | | | and move from legacy MRP to Great Plains. |