Dynamics,eCommerce,Integration computer Dynamics GP eCommerce Integration Notes
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
In this case you are moving away from emailing orders automaticallyfrom ecommerce to Great Plains users to somewhat like batch overnight ecommerceSales Invoices and Payments processing or even in ideal case to real timeInvoices creation triggering from ecommerce to Dynamics GP SOP module. Popular PHP based ecommerce shopping cartsalso create customer profile on the fly or update existing customer. In this case integration goes to ReceivableManagement Customer Master file in Great Plains. Lets take a look at technical side orprogramming tools: 1. DynamicsGP eConnect. If you are comfortable inprogramming in C# or VB.Net, and you have basic SQL scripting and storedprocedures understanding we recommend you to invest your time ineConnect. For Dynamics GP version 10.0 itis installed automatically on your DB side. eConnect, in fact, does have most of the logic, that you would be tryingto build in custom SQL stored procedures. However, eConnect stored procedures are encrypted and you would need toformalize your programming logic to accommodate eConnect rules. If all you need to do is create or updatecustomer record, and then create Sales Order and possibly apply credit cardcustomer payment (for Credit Card Processing you should deploy third partyproducts: PC Charge, IC Verify, etc.) eConnect does this job 2. DynamicsGP Integration Manager. If you do notsee yourself as Microsoft Visual Studio developer, and you are OK to dointegration in batch mode overnight or every few hours, consider Great PlainsIntegration Manager. If you have verybasic programming skills, probably from high school, IM has VBA scripting,where you can tweak Integration logic a little bit. IM could be scheduled for shuttingintegration, Microsoft Business Solutions has scheduling tool, however youcould schedule it via DOS batch file or third party add-ons 3. AlbaSpectrum Order Connector. Thinking aboutIM or even eConnect, where integration logic is rich and requires processingtime and power, when you need simple repetitive integrations on the very high volume,we have Order Connector, written in very direct SQL stored procedures, providingastonishing integration speed 4. PostingServer or Autopost. Here you arebreaking through eConnect or Integration Manager limitations and you can nowpost Great Plains Batches automatically from your eCommerce application 5. Giveus a call: 1-866-528-0577, [email protected]
Dynamics,eCommerce,Integration