| |
eConnect: Microsoft Dynamics GP Integration
By Andrew Karasev
Microsoft Dynamics GP, also often referred as Microsoft Great Plains or Great Plains Dynamics may be considered as very good ERP platform, ready for custom logic and integrations with legacy systems. eConnect is one of the tools of choice to be deployed in the case of creating and moving objects to Microsoft Dynamics GP.
• Master Records. Accounts, Customers, Vendors, Employees are typical master records. eConnect can create, update and remove these records. eConnect methods first try to validate business logic, so eConnect should be preferred over direct SQL scripting (trying to add or change records directly in Microsoft Dynamics SQL tables)
• Transactions. eConnect also allows you to create or modify so-called work transactions. However eConnect doesn't typically go beyond work transactions, so-called open or historical transactions should be created through Microsoft Dynamics GP posting, moving to history, voiding, etc. routines and this requires MS Dynamics GP operation intervention
• eConnect Limitations. First of all – we saw numerous clients, who were disappointed in the fact that eConnect can not automate posting and SOP Orders transfer to Invoices. You should understand the rules of ERP system – first you create so-called work documents: quote, order, invoice and then you post it – documents should be approved for posting and this should be done through standard ERP fat client interface, not eConnect or other standard integration tools. Second important limitation – if you have dexterity customization – eConnect can not address custom logic – it works with standard Great Plains objects only. We understand that this is difficult to foresee when you ask questions to your Microsoft Business Solutions VAR, and also that each ERP has specifics you need to know: say Oracle Financials world has its own must-know bells-and whistles – when you work with specific large ERP – you should invest a lot of time in analysis and decision making.
• Dexterity Overview. Dexterity itself is a shell/IDE/programming language written in C back in earlier 1990th. You probably remember old-days-believe that C will secure database and graphical platform independence, plus it will direct you to the way of computer platform independence. But the matter of fact is – Great Plains Dexterity dictates the rules of customization – each GP custom-logic table must be created in Dexterity to be viewed via GP standard interface,
• Dexterity Limitations. Of course – Dexterity is kind of legacy IDE and it was created in the days when nobody could predict internet and thin clients future. So – you can not use Dexterity in your web application, you have to stick to stored procedures or eConnect.
• Beyond eConnect. There are multiple options for you to deploy Microsoft Dexterity to automate such processes as posting. Imagine, you are moving daily eCommerce sales from your third party e-Commerce system to Great Plains and want them to be posted automatically. In this case you can deploy eConnect to bring work Sales Invoices and Payments and then you deploy Microsoft Dexterity Posting server to trigger posting all the way to the General Ledger
• Alba Spectrum Posting Server. It uses Dexterity posting engine and enable you to "signal" Microsoft Dynamics GP workstation with customized logic to launch batch posting.
Please do not hesitate to call or email us: USA/Canada: 1-866-528-0577, 1-630-961-5918 help@albaspectrum.com
About the Author
Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Oracle Financials, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.
We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN
Article Source: http://www.simplysearch4it.com/article/35402.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/35402.html" as shown above and make it hyperlinked. |
| Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like ...
SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of SAP ERP brand. This ERP ...
Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. ...
Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, ...
|
|
| |
|
