Dynamics GP eCommerce Integration Programming

If you are working in an THAT department and now you are facing eCommerce web application integration project with your Corporate ERP, we would like to give you several options to consider using their pluses and minuses. This small article is based on Great Plains eCommerce integration technology, however our company is trying to discuss such universal options, as real time versus quasi real time or group mode eCommerce integration, so you may find it useful for other Small Company ERP applications, such as SAP Business One. eCommerce is reflecting your unique business processes, so you should not expect custom programming to be something unusual:

1. Product vs Tribe The Fun Size of Tech Solution. If you can find existing eCommerce expansion for your accounting and logistic application - this is great news. Usually - this means that you have to redeploy your working eCommerce web application on the bottom of that cool product. This approach may well not look to encouraging to you, as you might be original eCommerce application developer or perhaps you simply want to maintain your company historical purchases. Solution is generic expression, meaning programming tools, fittings, or deployment of proven programming codes. Solutions allows you to keep existing eCommerce software and integrate it with Dynamics GP ERP in many phases. Both product and solution might be open up to software bugs. Product might be more beta tested comparing to solution, however you should request references from your recruiting Dynamics GP ISV internet commerce partner

2. Commerce integration specifications. Ideally you want to see your eCommerce originated sales invoices in your accounting systems the same moment, if technology permits. Nevertheless , the technology itself might be the place, where you wish to stop and review. Here we are reviewing Real Time, Quasi Real Time and Batch mode integration. In the frames of Microsoft Dynamics GP technology - real time eCommerce integration requires either eConnect or SQL Stored Procedures programming. Quasi real time (every five, ten, twenty minutes) could be realized via Integration Manger scheduled integration. And in turn, batch mode integration could be called on demand by Great Plains customer - typically Integration Supervisor

3. Connect eCommerce development. This tool allows you to realize real-time incorporation. eConnect is pretty friendly tool for Microsoft Visible Studio C# or VB. Net programmers. If you are area of the GP e-commerce development team in your organization, we recommend you to definitely invest your time into eConnect training. The ground level of eConnect technology stack is the established of encrypted SQL Machine Stored procedures, where the majority of the Great Plains master records, setups, and work transactions are exposed via eConnect methods. In the case of SAP B1 you have SDK which is comparable in its capacity to eConnect

4. Incorporation Manager. Here you are about set mode or quasi real time integration. If you are OK to foreign trade your eCommerce transactions to tab or coma delimited text files and then import them into Great Plains through Integration Office manager - this technique is very reliable (it validates business logic of Dynamics DOCTOR ERP), however it is not real time compliant. You may try to routine Integration to run every twenty minutes by implementing Windows macros or 3rd party Macro programs. Regarding SAP Business One you should review Data Exchange Workbench as analog to Integration Manager

5. Grasp and Slave application. You should decide which software is master (where almost all of your cards or learn records are originated: supply Items, Prices). Dynamics GP or SB1 are better suited to be professionals, as all the again office business logic is already there, versus custom eCommerce application, where you have to program all the playing cards from scratch. If Company ERP is chosen to become the master - Products, Prices and promotion promotions are pushed to internet commerce following that.