Ecommerce Web Developers

Here at Ecommerce Web Developers we do our best to provide honest and ...

Dynamics GP Development in Dexterity, eConnect, VBA

Mid-market Corporate ERP applications typically have variety of the programming tools and methods. Great Plains is open for modifications via such tools, as Dexterity, Modifier with VBA, MS Visual Studio SDK, Extender. There are several tools, dedicated to the integrations: eConnect, Integration Manager and to certain extent you can use your skills in SQL stored procedures. The variety has the other side of the coin, where you need to be sure that you have clear understanding on what you plan to accomplish and that you select the appropriate tool. Let’s review each tool individually and try to help you in the selection process:

1.Dexterity. This is more than just a tool, this is the whole architecture of this application, where you define such objects, as fields, tables, forms, windows, buttons, constants and make them work together via Sanscript procedures, functions, triggers and the script associated with the fields. We are not providing detailed documentation here, and you may expect more objects to discover, we are just giving you’re the idea on what it is. Dexterity is good, if you plan to change user interface or add new tables to the company or Dynamics database. However, if you are planning on something like web programming, Dex might be not your first choice, as this technology was introduced in earlier 1990th, where we didn’t have such concepts as web service, Microsoft .Net, XML. Please, keep reading the next paragraph on eConnect

2.eConnect SDK. We already mentioned above that it is rather integration tool, initially it was planned for ecommerce web developers to integrate shopping cart as Sales Order Processing Invoice with customer deposit. Well, that fact might look like a limitation, but imagine the following scenario. You are programming your web interface as the .Net project in Microsoft Visual Studio C# or VB. In this project you build your own web based buttons, fields, icons and you are including eConnect libraries in the project to reference GP transactions and master records. This scenario makes eConnect the champion in the tools selection for the ecommerce, customer, vendor, or employee self-service web based applications. As a C# programmer you might be excited at this point, be sure, that you already reviewed such web technology based tools as GP Business Portal, and various web add-ons for Great Plains

3.VBA scripting. There are two tools, where VBA is open for you to deploy: Modifier and Integration Manager. Let’s make these two stops and review. Modifier does just what it name suggests it allows you to modify existing forms, and other resources. Modification of the form means the possibility to change existing fields position and visibility as well as placing new fields on the forms and windows. New fields could be animated with VBA scripts, it is even possible to change associated table records via traditional Microsoft ADO (pre .Net). And the second tool is Integration Manager, where VBA scripts could intervene in the event handling logic. For example, you may introduce Before Integration VBA script, where you are loading text file into custom MS SQL Server table, and the following integration is based on the Advanced ODBC query to load new records directly from SQL View or newly created custom table

4.Some cautions. So far all these tools look good and even pretty cool, don’t theyc Please, consider some level of the conservatism. First of all Dexterity is semi proprietary and it commands long learning curve, if you have several years of Dexterity programming with your previous employer under your belt, then it might be a way to go. But for generic C#, VB programmer we do not really recommend to invest into Dex training and learning curve, especially when your customization project has moderate magnitude. Second caution please try to stay away from direct SQL Insert and Update statements, as these clauses might lead to data compromising

5.New customization tools. We also recommend you to keep your eye on such tools as Microsoft Visual Studio Tools for GP. Here you should be able to modify user interface in the manner, similar to Dexterity. We do not recommend this tool for large magnitude customization project, as it might require some work to be done in Dex, especially new tables creation

6.Reporting. If you just need to open GP for reporting, we recommend you to take a look at traditional tools, such as Crystal Reports, MS Access, MS Excel, and new tools, such as Microsoft SQL Server Reporting Services (often referred as SSRS). For pure financial reports, such as Balance Sheet, Profit and Loss Statement, consolidated reporting consider FRx as traditional tool or Microsoft Management Reporter as the alternative to FRx for newer versions 2010 and 10.0

About the author: Andrew Karasev is Great Plains Certified Master, MVP, 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project and founder of Alba Spectrum information space


10 thoughts on “Ecommerce Web Developers”

  1. Experienced web developers/designers- Need web hosting/ecommerce sites **10 Points** for best answer?
    Hi all,

    Could anyone recommend any reliable web hosts that also include ecommerce/webstore features. I have an existing site and am not at all pleased with my current provider for it’s poor service.
    *** I don’t mind having to build from scratch as I have lots of experience in web design,can use use html/Css, create graphics etc
    *** Ideally I’d also like the host to have a web building tools so not everything is 100% coded.

    Sites I have used before and therefore looking for others are
    – (really BAD service) but great features if they weren’t always under maintenance all the time.
    – (Excellent service but need to move as there max for products is 100, and I have heard you can get much cheaper packages for your money overall than just a webstore).

    Any input would be greatly appreciated, I live the UK and would love a UK host but will happily stick with an overseas one if they’re good. Thanks in advance for your feedbck.
    A litte more clarity in regards to hosting and what it is I am looking for…I simply meant a host where I can maintain my site online from any place, not the types where you have to install software (more expert, than my self taught skills) If you look at tht is a good example of what I mean only I would never go with webs again as their site is always down.

  2. I think it comes down to personal choice and experience of the provider. Someone could have used exactly the same services as you and have had no problems it’s just like everything in life. I quite like 50 webs. Not the most popular but good enough for most needs.

  3. I am a web/ecommerce developer and looking for web promotion tips to increase sales. Thks?
    We provide various web design, maintenace and ecommerce solution ( and looking for ways to promote our services online. We have multiple internet lines, staff of 25 with Masters and Bachelors Degree. We have power backup and have systamic approach to web development process through training and project management

  4. What is a good web host with a user-friendly ecommerce solution?
    Looking for a web host that provides a solid, user-friendly shopping cart that can be integrated with Paypal and is not buggy. Which web hosts do you like for ecommerce? Thanks for your help!

    P.S. Experienced web developer looking for a new host for my personal web site after using the same company for many years. Just looking to find out which ecommerce hosts people like these days. Thanks!

  5. What skills does a web developer need to know to set up a PrestaShop website?
    What different things does a web developer need to know to be able to customize a PrestaShop ecommerce site? PHP? Perl? Java? etc.

  6. i wonder, i am a web developer myself and i never heard anyone calling eCommerce site to be called as “shopping trolley”

  7. Good Company huh!
    Here are some tips to increase sales and promote them
    # You can do online advertising!. The online advertising is very good than tv or magazine advertising. It covers all over the world and most of all it is cheap too.
    But don’t just go to any site for advertising.
    The google is one of the trusted company. Try google adsense . You will have to deposit certain amount then when a user views ur website or buys a good then only the money will decrease nor it will remain still.

    # The next is advertise on forums discussions! There are many forum addictors and many peoples visit it. Join a forum and start advertising of your goods.

    # Do search engine optimization : When a user searches something in a website, if your website comes first the certainly he will go to it and have a look. So make your best keywords for your website with good description to attract peoples.

    Thats all what i got in my mind now
    best wishes
    bye c ya

Comments are closed.