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
o 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
MICROSOFT SECURITY
o 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
Microsoft Dynamics GP Integration Tools Review
Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de [http://www.enterlogix.com.br] ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, 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, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Colombia, Ecuador, Chili, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico
MICROSOFT SECURITY
No comments:
Post a Comment