Dynamics,eCommerce,Custom,Prog computer Dynamics GP eCommerce Custom Programming 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 paper we assume that you have self designed in-house made custom ecommerce web application with shopping cart and possible such additional features as credit card payment processing, custom B2B items catalogs or simple B2C ecommerce promotions, and also that your ecommerce website was programmed in .Net with MS SQL Server as DB platform, plus we will make some comments on other ecommerce alternatives, such as Linux/PHP/MySQL or Oracle based solutions with ODBC exposures, as Great Plains Dynamics GP is only available on Microsoft Windows and MS SQL Server platforms.  If our assumption seems too restricting, please review first GP ecommerce Add-ons available on the market as out-of-shelf products, directly available from Dynamics GP ISV ecommerce partners.  Again, here we assume that you already made significant investment into custom ecommerce website software development and you do not see the option to redeploy ecommerce on the base of Dynamics ISV partner ecommerce product.  Let's begin our review:1.Dynamics GP version and support.  Before we jump into your options, please be sure that these options are available to you as if you are on archaic Great Plains version, ecommerce might be very limited in integration and very expensive in design and support.  In our opinion, you should consider ecommerce custom website integration to Dynamics GP, if your GP is on currently supported versions: Dynamics GP 10.0 and 9.0 (we are writing these lines in October 2009).  The reasoning is also simple - GP eConnect ecommerce programming oriented SDK became matured product in our opinion for Dynamics GP version 9.0.  If you are on older Great Plains versions, such as 8.0, 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 and if you are on Great Plains on Pervasive SQL 2000/btrieve or Ctree (GP 7.5 and earlier) or Great Plains Accounting for DOS, Windows 9.5, 9.2 and earlier, in our opinion you should begin to move toward Great Plains upgrade up to Dynamics GP 10.0.  Upgrade is not something very simple, it might require additional budget and even software license repurchase (if reenrolling into Dynamics GP annual enhancement program cost is too high), plus upgrade requires Dynamics GP consultant help and assistance, where you also should expect reasonable cost, typically by hours.  The good news might be this - if your archaic GP version requires ecommerce integration on text file level (where you export new customers and invoices from ecommerce in text tab or coma delimited format), then the job of feeding ecommerce data into GP could be done by GP Integration Manager module2.Dynamics GP ecommerce integration tools.  The first option, that in our opinion you should check out is Dynamics GP Integration Manager.  IM for GP 10.0 has two types of connectors: traditional OLE Server connector (if you are Great Plains consultant, OLE server is what IM was using in older versions: 9.0 and earlier, where you have to initiate integration in the context of targeted company) , and second type is eConnect (here you have to specify company database, windows domain user for econnect credentials, for GP 10.0 you should expect some expected problems, for example SOP Returns are not covered for GP 10.0, however we expect this problem to be patched in the next Dynamics GP version).   IM is not only for Text file integration, in Advanced ODBC Data Sources you can count on SQL Views and call IM integration in quasi real time (every twenty minutes or more often).  Second option is really the one for ecommerce programmers (C#, VB, or other Microsoft .Net compliant programming language, where you should be aware that sample codes are available in VB and C# only).  eConnect has reasonable control over the creation or modification of such master records as GP Customer, Vendor, Address, Employee, Inventory Item, plus it has control over GP so-called work transactions and batches.  If you would like to post GP Sales Order Processing batches (and batches of different origin), please consider add-ons, such as Alba Spectrum Posting Server3.Dynamics GP ecommerce integration philosophy or architecture.  Here we recommend you to speculate about such questions as which application should be chosen as master to create ecommerce inventory items.  If it is GP, then ecommerce web site should pull items into its catalogs.  If this is GP, then Great Plains should be playing the role of sort of slave and pull and synchronize items, catalogs and price lists.  We placed here this paragraph as the example of possible complication factors4.Dynamics GP ecommerce integration to non Microsoft platforms.  For Java based, please be sure that you have good understanding of such technologies as IDBC-ODBC bridge or native Java ODBC drivers for Microsoft SQL Server 2008/2005/2000 (whichever is your case).  For Linux PHP popular hosting option, please check with your hosting partner if they allow you connection and serving scripts to your Microsoft Dynamics GP SQL Server database.  For Oracle custom database ecommerce application, please consider either link from Oracle or from Microsoft SQL Server (MS SQL Server Linked Server via Oracle ODBC driver)5.Limited ecommerce integration support for Dynamics GP 8.0, 7.0 and 7.5.  Our product Alba Spectrum Order Connector (written on the level of MS SQL Server Stored Procedures) supports integration to GP Sales Order Processing: SOP Orders, Invoices, Customers, Addresses.  Again, we would rather recommend you GP version update to 10.0, but if you see problems in this recommendation, please consider Order Connector as the way to go6.Great Plains Accounting and it compatibility status with ecommerce.  In our opinion GPA is not compatible with real time or quasi real time ecommerce program.  You can experiment with GPA integration module, or try to establish ODBC connection to GPA database via DDF files.  And even if you have reasonable tool  (such as Microsoft Access or MS SQL Server Linked Server) for feeding data into GPA Btrieve tables, we do not recommend this as GPA business logic should be considered as reasonably complex7.How to get help?  Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us [email protected]  We are very technical and real Dynamics GP Dexterity, SAP Business One SDK and Microsoft CRM programming gurus.  We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs.  Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants.  If you prefer skype: albaspectrum

Dynamics,eCommerce,Custom,Prog

computer

Equipment Rental Software – Features And Cost

Equipment rental management software is an essential thing these days for any equipment rental company.A well-developed equipment rental software provides you with a variety of features that can really help you maintain and organise your cus ...

computer

5 Big Reasons Why I Migrated From Angularjs To React

I have 5 main reasons for my angularjs to react migration. No, it's not a comparison on which is better. A comparison between apples and oranges would make no point. React is a library, and angular is a framework. Both can do stuff in their ...

computer

How to troubleshoot McAfee error 2318?

Security software means McAfee! For many computer users, McAfee antivirus is the only choice for security software as it provides all the features and tools which are necessary for device and data protection. This robust antivirus merely sho ...

computer

Manage Multiple Counter With AlignBooks Point of Sale

Fulfilling your businesss needs which can grow your firm is our aim. AlignBooks is better known for providing a strong pillar to newly started or midway businesss. Those companies who dont want to fall back with irregularity manage the inven ...

computer

How to Autoplay Embedded YouTube Videos

Source: How to Autoplay Embedded YouTube VideosEmbedding a video or audio enables the users to share their videos with any of their preferred sites or any social networking platforms. They can do so by copying the embedded link of the parti ...

computer

3 Major Mistakes to Avoid in Retail Business

Truth be told, nearly half of the retail businesses survive longer than four years and which can be something to ponder for a newbie before stepping into the industry. However, this being said, it is also true that you can excel in the indus ...

computer

Start Your Own Computer Repair Business

1. Know your street value. In the early 90's, running a PC repair business centered around selling parts and products, with service on the side. Today, it's about selling hours. If you run a business, you need to consider the X3 rule. That m ...

computer

How Establishments Show Up in Restaurant Searches

The revolutionary rise of technology has made things easy-peasy for consumers in the restaurant industry. Unlike the old days, the availability of innumerable platforms has made it possible for diners to choose from various searching options ...

computer

GuildWars 2 :

The last expansion pack for Guild Wars 2 was Path of Fire, which was released in 2017 and brings you a new enemy-Balthazar, the evil god of war. Although this doesn't sound like another expansion pack currently in production, some fans ma ...

computer

Customer Support at the time of COVID-19 Pandemic

COVID-19 is the worst crisis of our time as we observe social distancing protocols being imposed all around the world. While these measures are a step in effectively managing the COVID-19 pandemic, Hospitality and Retail businesses are confr ...

computer

How to Choose a Contract Management Solution (CLM)?

Contract life cycle management (CLM) systems can simplify and automate contract creation, negotiation, execution and storage. They are an intelligent alternative to the tedious hand tools formerly used for these tasks, which lacked visibili ...

computer

Contacting Google Live Person to Resolve Your Issues

Users are fond of all the Google supported products and look forward to the best services. Also, Google as a whole has never disappointed its users and helped them at every point with its commendable services. Also, being a customer-oriente ...

computer

how to uninstall discord

How to Uninstall Discord in Windows 10? has supported open source technologies, our tool is secure and safe to use. To uninstall a discord from your windows, you'll use this method which is given below.USING THIRD PARTY TOOLS1. Firstly, you ...