blogoffline.net

In Microsoft Great Plains Dynamics GP you have Integration Manager and with the addition of large number of new eConnect based connectors in Dynamics GP version 10.0 ? you, as Great Plains user, programmer or consultant can now do really wonderful integrations, however there are always certain restrictions and we would like to review simple work around ? Great Plains Macros

This small publication is not intended to be technical
instructions, it is rather highlights:

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 implementation in ecommerce or EDI (Electronic Document Interchange) environments often requires documents creation in Dynamics GP from external applications, such as e-commerce web site. 

We recommend you to make a research in the SDK and integrating tool, named eConnect.  eConnect creates, deletes and updates GP master records: customer, vendor, employee, GL account, address for customer or vendor to name few examples.  Also eConnect creates so-called work documents: Sales Order Processing Invoice, Sales Order, Purchase Order, GL transaction, Payroll Payment and Check, etc.  Please, note here, that these documents have work status, they are not posted and awaiting for your review and posting on the batch level.  It is often the requirements to post Great Plains batch automatically from ecommerce or EDI integration application ? and here you will get the limitation of eConnect ? it doesn’t have batch posting functionality and it probably should not due to GP architecture.  In order to post batches in GP you will need add-on GP Autopost

Microsoft Dynamics GP modifications and custom programming scenarios should be considered when third party add-ons are too expensive or too complex to implement.  If this is the case ? you can relatively quickly and cost effectively develop your own custom module. 

We recommend to review such software development tools as Great Plains Dexterity, eConnect, SQL stored procedures, Modifier with VBA, GP Integration Manager.  In this small publication we would like to give you customization specification for custom invoice mailer via email:

SAP B1 is making substantial progress, especially with the release of version 2007A (A postfix means the version released for USA).  We often see the scenario, when US based customer, who are in process or already implemented SB1 and needs integration with existing ecommerce website. 

If you have already invested into legacy and functional e-commerce, you may consider to just program integration connector in SAP Business One SDK.  SB1 Software Development Kit programming requires solid background in C# or VB.Net programming, plus SAP Business One object structure understanding.  The best approach is to hire SB1 ISV development firm, which carries SB1 SDK certified developer.  Let’s review integration highlights:

Microsoft Great Plains or current name of this mid-market ERP is Dynamics GP has various development and programming options: Dexterity, eConnect, VBA/Modifier, SQL stored procedures openness, SDK for Microsoft Visual Studio developer to name few popular. 

The topic is very popular as more GP MRP and accounting systems are in process of being installed and implemented.  Special interest we expect from eCommerce developers, where such questions as automatic batch posting, Sales Order deposits application are very popular ones.

When Microsoft acquired Great Plains Software and then integrated Great Plains into so-called Microsoft Dynamics ERP products family as Dynamics GP, modification tools became more Microsoft and .Net oriented, as you could expect. 

However in the initial design in earlier 1990th Great Plains Dynamics was intended as multi platform product and its fundament was built on new technology named Great Plains Dexterity.  Considering complicated origin of GP, let’s review development tools: