blogoffline.net

Microsoft Dynamics GP is becoming very popular ecommerce ERP and accounting back office.  This trend is probably related to success of eConnect SDK, especially for Dynamics GP 10.0 and 9.0 versions.  

eConnect allows you, being generic C#, VB.Net programmer
with good SQL and XML skills to program Great Plains objects manipulation:
Customer, Address, Sales Invoice, Customer Payment and other attributes of
ecommerce shopping cart.  eConnect, being
coded in SQL Server Stored Procedures (they are encrypted, so you probably
should not expect to trace SQL code for Great Plains business logic there).  In this small publication we would like to
share with you ecommerce coding experience and Dynamics GP automatic batch
posting from eConnect application directly:

Advanced techniques in SAP BO Data Transfer Workbench integration scenarios.  This method allows you to establish ongoing integration from such systems as Microsoft CRM, Oracle custom database, Lotus Notes Domino, etc.

Microsoft Great Plains or Dynamics GP ERP application is working on Microsoft SQL Server Db platform, and this fact opens GP to such industry reporting tool as Crystal Reports.  CR can work with such report base constructions as SQL View and even SQL stored procedure ? deploying these technologies you virtually have no limits in pulling data from Great Plains company database.  

This FAQ style publication will try to compare Crystal
Reports with other Great Plains reporting tools: Report Writer, Dexterity, FRx,
Advanced Financial Reporting, SRS:

Microsoft Dynamics GP ERP application, or popular old name Great Plains Dynamics and eEnterprise, if you have relatively recent version, is based in Microsoft SQL Server.  If you are experienced SQL DBA yourself, just this fact should give you the idea on structuring select statement and make it Electronic Document Interchange code compliant. 

Of course, for luxury EDI solution you can purchase Add-Ons and simply setup EDI export in the user friendly interface, however this publication is for people, who are either on the tight budget, or who have really complex EDI requirements and data format export rules.  This news should also ideally help you with your Great Plains Partner, ISV and technical consultant and programmer selection:

Microsoft Dynamics GP, or former ERP name is Great Plains Software Dynamics / eEnterprise gives you, programmer or software developer vide spectrum of report design tools: Crystal Reports, Microsoft SQL Server Reporting Services, GP ReportWriter, MS Access, MS Excel to name some of the popular. 

In this small technical paper we would like to introduce you into Crystal Reports design for Dynamics GP, assuming that you are new to GP and need some starting help.  We also assume here, that you are on MS SQL Server Database: GP 10.0, 9.0 and 8.0, if you are on GP 7.5 and earlier: 7.0, 6.0, 5.5, 5.0 or 4.0 where Great Plains was available on Ctree or Pervasive SQL/Btrieve, please review database connection options, described in our earlier articles ? you will need to install Ctree/Faircom or Pervasive ODBC drivers.  Let’s come back to Crystal for GP on MS SQL Server:

Microsoft Dynamics GP ERP requires data massage and initial conversion as well as data repair and day-to-day maintenance. 

If you are mid-size or large enterprise, you should consider having Microsoft SQL Server DBA in staff, however certain data repair routines might be too complex and dependent on the GP tables and data flow architecture, where you will need GP technical consultant to do the job.  In this small publication we would like to review data management techniques and the most convenient ways to do these jobs: