Web Design for Microsoft Dynamics GP – custom ecommerce solutions

Aug 18
22:46

2007

Andrew Karasev

Andrew Karasev

  • Share this article on Facebook
  • Share this article on Twitter
  • Share this article on Linkedin

More articles are published about Microsoft Great Plains Dynamics GP 10.0. Very hot topic is eCommerce and web site design, development and support with integration to Great Plains via eConnect or custom SQL stored procedures and triggers. E-Commerce sites may have legacy trace and so be developed in the past in various technologies, including non-Microsoft: Java, JSP, ASP, ASPX, PHP, Oracle, IBM DB 2, etc

mediaimage

When we are talking about Microsoft Dynamics GP version 10.0,Web Design for Microsoft Dynamics GP – custom ecommerce solutions Articles 9.0, 8.0, 7.5, 7.0, 6.0 or 5.5 we mean such ecommerce integration technologies as eConnect (10, 9 and 7.5) and SQL stored procedures (for earlier Great Plains Dynamics/eEnterprise versions).  If you still deploy legacy Pervasive SQL 2000/Btrieve or Ctree/Faircom versions of GP, this is 7.5 and earlier – ecommerce can still be tailored to your legacy ERp, however we recommend you to upgrade to GP 9.0 or 10.0.  Some technology and programming highlights:

1.      eConnect and Posting Server.  Posting Server is extension to eConnect, allowing you to post GP batches, while eConnect has the option to create work transactions and place them into GP batch in the case of ecommerce – more likely you are interested in Sales Order Processing module (SOP)

2.      ASPX .Net development.  If you start from scratch or modify existing .Net e-commerce website, your choice is simple - .Net ASPX.  Back end is probably SQL Server, assuming that you may need custom databases, aside from such GP database as DYNAMICS and company databases

3.      Visual Studio .Net C# or VB development.  If you are VS .Net developer you can create and debug GP eCommerce integration project.  However, you should expect some technical challenges, especially when going deep to GP business logic imitation.  We recommend you to combine Microsoft Dynamics GP Dexterity customization with your .Net C# project to make your job done

4.      eCommerce upgrade and redeployment.  If you think that you should switch away from non-Microsoft platform to .Net, then you should invest your time in such SDK as eConnect, initially designed for eCommerce developers to hook Great Plains as back office ERP

5.      Great Plains Integration manager.  This GP module allows you to do ongoing integrations to GP back office.  In the past it was mostly end user tool.  Nowadays when IM is in process of being rewritten in eConnect, integration performance issues are to be resolved and IM is promoted as excellent development instrument.  From legacy IM side you can easily modify it via VBA scripting.  In connection to ecommerce website, IM can be scheduled for GP backoffice MRP update