Dynamics,ecommerce,Integration computer Dynamics GP ecommerce Integration Technologies: notes for Pr

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 ----------------------------------------------------------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

Plus you have working ecommerce website, where integrationto GP is very loose: maybe it triggers email to Picking and Packing department,or Sales Order Processing people.  Inthis small publication we would like to review relatively open for end user orin the case of software developer - not difficult to begin integrationcoding.  We do not specifically reviewhere differences between B2B and B2C ecommerce scenarios in Dynamics GP, pleasereview our past articles.  There areready for deployment solutions, we assume that you already did this homeworkand decided to preserve your investments into your current eCommerce webapplication, and all you would like to do is robust integration: 1.       RealTime versus Batch Mode integrations. Real Time ecommerce transactions move to GP Sales Orders or Invoices isdefinitely cool to have, however if this is not absolutely required, werecommend you first to think about Batch Mode ecommerce integration.  Batch mode means, that ecommerce may havesome lookups for your customers if item is available in one of your warehouses(via simple SQL query to your Dynamics GP Company database), however ecommercetransactions are moved to GP Sales Document only once per day, or maybe everyhour, if you are larger ecommerce retailer 2.       GPIntegration Manager.  This tool is veryfriendly to Great Plains users, and it could be extended by programmer via VBAevent driven scripts.  IM is first choiceif you are planning integrate in Batch Mode. Please, do not be mislead by some GP consultants, that IM is for textfiles only.  For advanced ecommerceintegration to GP we recommend you to base IM data queries on SQL Server Views(Advanced ODBC based query) and the View itself looks at the existing GP ordersand lines and into new ecommerce document - in that case your scenario could becompletely automated.  Plus IMintegration could be called automatically via Windows macro third party tinyapplications (or you can purchase Integration scheduling tool from MicrosoftBusiness Solutions, check with your Dynamics GP Partner on that).  We helped implement scenarios for largeComputer IT integrator and warehouse, where all transactions are coming throughB2B ecommerce website on PHP/Linux and GP Integration Manager is scheduled torun every 20 minutes to be close to real time mode integration.  OK, now if you think IM is too simple, let'smove on to eConnect 3.       eConnectSDK and technology for Dynamics GP.  Ifyou are C# or VB.Net ecommerce programmer or programming savvy web master,please review eConnect, as it has set of libraries, which could be added toyour MS Visual Studio web projects and you could create, edit, delete virtuallyall GP Master records: customer, vendor, GL account, Item, Address, Employee,and work transactions: Sales Invoice, Purchase Order, Purchase Receipt, GLTransaction, Customer Payment.  Please,note that you cannot post GP Batches (such as popular in ecommerce scenariosSales Order Processing Batch) - if you need complete automation with BatchPosting you need to consider Alba Spectrum Posting Server or Autopost.  Also, eConnect doesn't cover some ratherhistorical modules, such as Invoicing (usually Great Plains Customers prefermore robust Sales Order Processing module). And plus, eConnect from Dynamics GP doesn't cover third party DynamicsGP ISV modules, which you may deploy - consider to check with you Great PlainsISV partner if they have extensions for eConnect.  If you are on Dynamics GP 10.0 and 9.0 -eConnect is the way to go, however if you are on older version, consider toupgrade to GP version 10.0 prior to deploying eConnect in your ecommerceintegration programming 4.       BeyondeConnect.  If you believe that yourintegration is SOP only and it is very simple, we offer Alba Spectrum OrderConnector.  This tool supports allcurrent versions: 10.0 and 9.0 plus older versions: 7.5 and 8.0.  You can also combine some Great PlainsDexterity programming to alter business processes in GP as additional help toIntegration.  We are trying to discourageyou from considering direct SQL Server Stored procedures coding, as eConnectalready have this work done for you - its initial layout is encrypted MS SQLServer Stored Procedures, plus consider the fact that Dynamics GP BusinessLogic and Data Flow is complex, and its database is not protected from inexperiencedSQL programmer - you can compromise data integrity and incur additionalunexpected expenses in involving GP Technical consultants to do data recoveryand repair 5.       Howto get help?  Please, feel free to callus: 1-866-528-0577, outside of USA: 1-630-961-5918 or email [email protected]  We are verytechnical and real Dynamics GP Dexterity, SAP Business One SDK programminggurus.  We have Great Plains Software DevelopmentFactory and could support unlimited Dynamics GP Customization and Programmingneeds.  Plus we speak English, Chinese,Spanish, Portuguese, Russian, and not only as native speaking sales folks, butas real technical consultants.  If youprefer skype: albaspectrum