Software informational articles

Microsoft great plains integration with microsoft admission ? overview for developer - software


Microsoft Affair Solutions stakes on Microsoft Great Plains as main Accounting/ERP attention for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation promote competitor to Oracle, PeopleSoft, SAP, IBM. This condition is brief appraise of Microsoft Great Plains integration with Microsoft Access. This is also applicable to Small Big business Administrator (which is based on the same know-how - Great Plains Ability glossary - DYNAMICS. DIC and runtime DYNAMICS. EXE) and Great Plains Accepted on MSDE or MS SQL Server.

If you are developer who is asked: how do we implement Great Plains integration/interface with your MS Access-based classification - read this and you will have the clues on where to look further.

  • Great Plains Integration Administrator - this is considerably end-user tool - it is very intuitive, it validates 100% of commerce logic, brings in/updates master report (accounts, employees, customers, vendors. etc. ) brings in transactions into work tables. The limitation of Integration Executive - it does use GP windows at the back the scenes exclusive of screening them - so it is moderately slow - you can bring 100 report - but when you are conversation about thousands - it is not a good option. By the way you can agenda Integration Director with VBA. Microsoft Contact is ODBC accommodating and so you can do as the crow flies Integration Director query to MS Contact
  • eConnect - it is type of Software Advance Kit with samples in VB. Net. Evidently the advancement background must be Visual Studio. Net. eConnect will allow you to integrate master report - such as new customers, vendors, employees, etc. , plus you can bring transactions into so called Great Plains work tables (eConnect doesn't allow you to bring open or past proceedings - you need to post work report in Great Plains, the same limitation applies to Integration Boss above) eConnect is fairly for ongoing integration. It was at first formed for eCommerce attention integration to Great Plains.
  • SQL Stored Procedures. Noticeably you have boundless be in command of and potential with SQL queries. You need to know Great Plains tables arrange and data flow. Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the appropriate series. If you are looking for the customers - it be supposed to be RM00101 - buyer master file. If you need chronological Sales Order Giving out papers - they are in SOP30200 - Sales Description Footer file, etc. Do not adjustment obtainable tables - do not construct new fields, etc. Also you need to apprehend that each GP table has DEX_ROW_ID - character column. Every now and then it is good idea to use inbound/outbound XML in the parameters - then you can arrange web advantage as a center party concerning two systems.
  • Data Transformation Military (DTS) - Good tool for importing your third party data into performance tables in GP - then you can pull them in using each stored procs of Integration Manager. You can also organize this tool for EDI export/import. You can have DTS running with Connected Ma?tre d' - SQL Head waiter Construction for involving to Microsoft Approach
  • Great Plains Agility Custom Screens. From time to time users choose to have seamlessly integrated into GP edge custom screens - for parameters settings and initiating integration. Ability is a good option, but commit to memory - it is at all times change for the better to coin new custom broadcast versus customizing accessible one - due to the hope upgrade issues. Also - Adroitness is in phasing our by Microsoft Affair Solutions.
  • Modifier/VBA custom buttons on the accessible screens - alternative to Agility is you are comfortable with VBA and ADO.
  • SQL Associated Servers - you can do aim SQL queries to other ODBC amenable platform via SQL Connected Head waiter (including Microsoft Access) - you may need to bring into the light by hand with OPENROWSET charge in Conclude SQL. This is also good opportunity if you need cross-platform Rock Article - pulling data from SQL Attendant and third party databases on the same report.
  • Warning - do not place obtainable GP tables into Replication! - you will have upgrade issues.
  • Happy integrating! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum. com

    Andrew Karasev is Chief Knowledge Administrator in Alba Spectrum Technologies - USA generally Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, New York, Florida, Georgia, Minnesota, Oregon, Arizona, Canada, UK, Australia and having locations in numerous states and worldwide (www. albaspectrum. com ), he is Dexterity, SQL, C#. Net, Rock Intelligence and Microsoft CRM SDK developer.


    WorkWave to Acquire TEAM Software  Silicon Prairie News

    Iris Software Acquires Conarc

    Developed by:
    home | site map © 2021