Article Categories

»	Arts & Entertainment
»	Automotive
»	Business
»	Careers & Jobs
»	Education & Reference
»	Finance
»	Food & Drink
»	Health & Fitness
»	Home & Family
»	Internet & Online Businesses
»	Miscellaneous
»	Self Improvement
»	Shopping
»	Society & News
»	Sports & Recreation
»	Technology
»	Travel & Leisure
»	Writing & Speaking

Reprint Article Code

Category: Articles » Technology » Computers » Article » Article Code

Microsoft Dynamics GP Integration tools review

Article Title:

Article Body:

Microsoft Dynamics project was first known as Microsoft Project Green, and got its current name in September 2005. Currently Microsoft Dynamics unifies the family of former Microsoft Business Solutions ERP & CRM products: Great Plains, Microsoft CRM, Axapta, Navision, Solomon. The idea of former Project Green was to create several Microsoft Suites: Financial, HR, Manufacturing, Supply Chain (SCM) on the base of its ERP products, where they would assumedly take the best core for each suite from one of MBS ERPs. Microsoft Dynamics seems to emphasize interfaces unification and merge, so you should not be confused if all the sudden instead of GP database you will be switching to say Axapta database for SCM. Obviously in the initial phase of Microsoft Dynamics each product: GP, NAV, AX, CRM, SL has its own integration methods and tools. Let's consider Microsoft Dynamics GP 9.0 integration tools in this small article
 
•	Microsoft Dynamics GP Integration Manager. It is end-user tool and as the user you should feel free to experiment. You should understand that Integration Manager is in the redesigning phase when instead of using GP workstation or so-called fat client as OLE server and use behind the scenes forms data entry and update validation – it will be using more eConnect, which is repeating the data entry logic on the SQL stored procedure level and this is definitely way faster and efficient. Some drawbacks – as Integration Manager is switching from OLE to eConnect – VBA scripting becomes not available too, so you should redesign your old integrations if you use a lot of custom integration logic via VBA scripting
 
•	Microsoft Dexterity. We would say that Dexterity should be avoided in integration logic, however you can use custom dex forms to initialize integration parameters and then pass them to SQL Stored procedures, eConnect, etc. The reason for avoicing Dexterity – the complexity to create dex integration is similar of exceeds the complexity to create stored procedure. At the same time dex is cursor driven language and in SQL you can use aggregation and get higher performance
 
•	eConnect. It was initially designed for eCommerce web developers to enable them use Microsoft Great Plains as backend for eCommerce application. So – the answer is natural – it is good tool to create GP objects, such as Customer, Product, Sales Order or Invoice. Later on eConnect logic took over almost every object in Microsoft Dynamics GP. eConnect has some limitations, however – it was designed to take care of creation and update of so-called work records, such as enter Sales Order, then Sales order transfer to Invoice and Invoice posting were supposed to be the duty of GP operator – in the case if you need posting to be done automatically you need eConnect extensions
 
•	SQL Stored Procedures. We do not recommend you to use DTS directly, because data validation is pretty sensitive and you need to imitate it in the code of more flexible stored procedure. Also stored procedure may be the way to go, when your integration is pretty simple and straightforward and it is not feasible to pay for eConnect or Integration Manager. As developer / programmer what you need to do is enter transaction you expect to integrate in GP test environment and look how do they go to SQL tables. In GP you have DYNAMICS (or system) database and multiple company databases, you integration is usually hits company database only. The most typical tables for integrations: SOP10100 – Sales Header, SOP10200 – Sales Lines, RM00101 – Customer master, RM00102 – Customer Address Master, PM00200 – Vendor Master, etc.

Please do not hesitate to call or email us: USA/Canada: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027 help@albaspectrum.com

Author Bio:

Some other recently published computers articles

Microsoft Word. The power is under the hood by Robert Duval
Recently I have had the opportunity to play around with Microsoft Word. We all use daily, but 99% of the users don't take advantage of ...

How To Select The Best Business Laptops by Tim Childree
The corporate life is hectic, so it is important to have a fast, reliable, lightweight notebook that can maximize your daily output by keeping your projects organized ...

How To Select The Best Gaming Laptops by Tim Childree
Most veteran PC gamers know exactly what they want in a gaming laptop, and those who have the time and money have probably already built their dream ...

High-Tech Computer Rental for Business Promotion by Michael Braganza
In current development of technology, everyday comes with some enhancements in latest technology. To grow business and to compete with competitors, high tech equipments are required for office use and to organize conferences, trade show ...

Managing a Worldwide Print Infrastructure from a Single Workstation in a Central Location by Rick Ferguson
Company – This US based company is one of the world's largest manufacturers of automotive parts and sub-assemblies in the world. ...

A Sneak Peek Into The World Of Refurbished Laptops by Javier Fuller
A refurbished or recertified laptop is one that has been previously used for a short period of time and after ...

Publisher Guidelines

You may reprint this article electronically in your newsletter or on your website, free of charge.

If you reprint this article from our site, then you must keep everything intact. This includes the articles title, author name, articles body, authors bio / resource box, the links contained within the article, all copyright notices and the link pointing back to our site. All links within the article must also be made active / hyperlinks.