Secka Forum
cs GP eCommerce case stud

Nieuw onderwerp plaatsen   Reageren    Secka Forum // Voorbeeld Forum
Vorige onderwerp :: Volgende onderwerp  
Auteur Bericht

Geregistreerd op: 29 Aug 2019
Berichten: 222

BerichtGeplaatst: 28-05-2020 02:09:35    Onderwerp: cs GP eCommerce case stud Reageren met citaat
Linux eCommerce Integration to Dynamics GP Scenario Computers Articles | September 5 Cheap NFL Jerseys Wholesale , 2010
First of all we have to say, that it is not about Magento shopping cart. ?This publication is about real implementation of Microsoft Dynamics GP version 10.0, integrated in quasi real time with custom PHPMySQL ecommerce website.

Ecommerce application itself was coded in PHP by in-house programmers. ?In initial discussions developers were interested to know Dynamics GP table structure and how master records (customers Cheap Wholesale NFL Jerseys , items) and transactions (SOP Order with customer deposit) could be pushed down to Great Plains tables. ?We also discussed such integration methods as eConnect. ?And finally we ended up with Dynamics GP Integration Manager. ?Let?s review integration functionalities and technologies:
1. eCommerce B2B Shopping Cart as SOP Invoice with Customer Payment or open invoice (if sale of account). ?In Dynamics GP Integration Manager version 10.0, as you may be aware, you can use so-called sConnect connectors (not traditional IM OLE integration method Cheap Authentic NFL Jerseys , where GP Workstation should be running on the computer and play the role of the OLE Server). ?eConnect is more efficient from the performance perspective and you can integrate virtually several hundred ecommerce shopping carts per minute. ?However, we have to mention one of the drawbacks, that we discovered for GP IM eConnect ? it doesn?t handle returns (we?ll need to check if this issue is resolved for Dynamics GP 201011.0). ?So Cheap Custom NFL Jerseys , in order to handle lesser number of ecommerce returns we still had to have Dynamics GP Workstation and one user license to be assigned to Integration Manager with old SOP Transaction integration (OLE Server)
2. Integration Text File. ?First suggestion was to deploy elegant ODBC connection from Windows Server to Linux based MySQL database, or even Linked Server Construction in MS SQL Server 2005. ?However developers indicated that it is much easier for them just to export CSV text file and place it into the directory for processing. ?As you may know ? Integration Manager is very friendly to text files
3. Calling Integration Manager in quasi real time. ?Developer from customer IT department suggested to call IM with command line parameters through freeware windows utility which was schedule to call executable small application (exe file) every five minutes. ?This small application also moves text file with processes records and if any exception occurred ? reports to the administrator
4. Taking care of new customers and items. ?This is known method for Dynamics GP Integration Manager consultants ? you can call first customers, inventory items update integration and only then the one for SOP transactions. ?If you do it in this order ? all new customers and items will be added to the system Cheap NFL Jerseys From China , prior to integrating their Shopping Carts
5. Emailing processed SOP Invoices back to the customers. ?This was realized in SQL mail (in SQL 2008 we would also recommend SQL DBMail ? new functionality), where invoices were printed from the batch with intercepting the ones, marked for emailing to be printed to PDF file (we recommend you to schedule PDF printing interval to be at least one second Cheap NFL Jerseys China , otherwise PDF printer may print blank papers). ?We also discussed Electronic Document Delivery module in Dynamics GP Business Portal, but they decided that BP implementation just for this one module is too much. ?This specific customer had concerns about long list of serial numbers ? in Dynamics GP SOP Invoice forms serial numbers are printed automatically, but when the list is really long Cheap NFL Jerseys , Invoice form is a bit restricted in formatting. ?So, in the phase two local developer simply was calling out invoices from SOP10100 and SOP10200 tables and printing them into PDF directly from PHP application
6. Other Dynamics GP Routines and User training. ?These were typical for Great Plains implementation. ?Need to mention that the controller was happy about nice AP graphical check form (letters were in italic)
7. Some comments or what could have been done better. ?As general observation, large ecommerce retailers typically do not deploy standard ecommerce shopping carts Cheap Jerseys Wholesale , such as MagentoPHP or ASP.Net Storefront ? they tend to program the whole ecommerce website from scratch. ?And this fact is probably justifiable, they have business processes so unique to deploy standard element and plus they need complete control over the web application. ?For smaller ecommerce retailers or wholesalers we would rather recommend deploy shopping cart plug-ins available on the software market. ?If you follow the advise- we do have Dynamics GP eCommerce extension module, which allows you to avoid complex programming and Integration Manager deployment Cheap Wholesale Jerseys , as we described above. ?Instead you simply follow ecommerce setup wizard steps to have your Magento or other popular shopping cart integrated in quasi real time (via our SQL Stored Procedure based Order Connector technology) to SOP Invoice. ?For full ecommerce order automation and fulfillment we recommend you to consider combining Dynamics GP ecommerce module with Warehouse Management System, where ecommerce orders are scheduled for automatic fulfillment via barcoding on the warehouse floor
8. Dynamics GP eCommerce case study. ?As we already mentioned this publication is based on real new Dynamics GP customer, who implemented this mid-market Corporate ERP package in the fall of 2008 and earlier months of 2009 on GP version 10.0. ?In our opinion new version Dynamics GP 11.0 or as it was later renamed into 2010 Cheap Authentic Jerseys , is even more powerful and flexible to be chosen for large Distributor or Wholesaler with ecommerce presence
9. Last flint ? Dynamics GP ecommerce implementation on the international market or for the multinational corporation with overseas presence. ?We specially addressed the question . Cheap Jerseys Cheap Jerseys China Cheap T-shirts Cheap Jerseys Free Shipping Cheap Hats Cheap Nike NFL Jerseys Cheap New Jerseys China Wholesale Jerseys Wholesale NHL Shirts Wholesale NBA Hats
Terug naar boven
Profiel bekijken Stuur privébericht
Nieuw onderwerp plaatsen   Reageren    Secka Forum // Voorbeeld Forum Tijden zijn in GMT + 1 uur
Pagina 1 van 1

Ga naar:  
Je mag geen nieuwe onderwerpen plaatsen in dit subforum
Je mag geen reacties plaatsen in dit subforum
Je mag je berichten niet bewerken in dit subforum
Je mag je berichten niet verwijderen in dit subforum
Je mag niet stemmen in polls in dit subforum

Wilt u geen reclame op dit forum en genieten van extra voordelen? Klik dan vlug hier voor meer informatie!
Powered by phpBB and Andrew Charron
immo op Realo
Maak snel, eenvoudig en gratis uw eigen forum: Gratis Forum