Software Information

Microsoft Great Plains Integration with Microsoft Access - Overview for Developer


 
Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market.  At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor to Oracle, PeopleSoft, SAP, IBM.  This article is brief review of Microsoft Great Plains integration with Microsoft Access.  This is also applicable to Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary - DYNAMICS.DIC and runtime DYNAMICS.EXE) and Great Plains Standard 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  system - read this and you will have the clues on where to look further.

  • Great Plains Integration Manager - this is rather end-user tool - it is very intuitive, it validates 100% of business logic, brings in/updates master records (accounts, employees, customers, vendors. etc.) brings in transactions into work tables.  The limitation of Integration Manager - it does use GP windows behind the scenes without showing them - so it is relatively slow - you can bring 100 records - but when you are talking about thousands - it is not a good option.  By the way you can program Integration Manager with VBA.  Microsoft Access is ODBC compliant and so you can do direct Integration Manager query to MS Access
  • eConnect - it is type of Software Development Kit with samples in VB.Net.  Obviously the development environment should be Visual Studio.Net.  eConnect will allow you to integrate master records - 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 historical records - you need to post work records in Great Plains, the same limitation applies to Integration Manager above)  eConnect is rather for ongoing integration.  It was initially created for eCommerce application integration to Great Plains.
  • SQL Stored Procedures.  Obviously you have unlimited control and possibilities with SQL queries.  You need to know Great Plains tables structure and data flow.  Launch Great Plains and go to Tools->Resource Description->Tables.  Find the table in the proper series.  If you are looking for the customers - it should be RM00101 - customer master file.  If you need historical Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc.   Do not change existing tables - do not create new fields, etc.  Also you need to realize that each GP table has DEX_ROW_ID - identity column.  Sometimes it is good idea to use inbound/outbound XML in the parameters - then you can deploy web service as a middle party between two systems.
  • Data Transformation Services (DTS) - Good tool for importing your third party data into staging tables in GP - then you can pull them in using either stored procs of Integration Manager.  You can also deploy this tool for EDI export/import.  You can have DTS working with Linked Server - SQL Server Construction for linking to Microsoft Access
  • Great Plains Dexterity Custom Screens.  Sometimes users prefer to have seamlessly integrated into GP interface custom screens - for parameters settings and initiating integration.  Dexterity is a good option, however remember - it is always better to create new custom screen versus customizing existing one - due to the future upgrade issues.  Also - Dexterity is in phasing our by Microsoft Business Solutions.
  • Modifier/VBA custom buttons on the existing screens -  alternative to Dexterity is you are comfortable with VBA and ADO.
  • SQL Linked Servers - you can do direct SQL queries to other ODBC compliant platform via SQL Linked Server (including Microsoft Access) - you may need to familiarize yourself with OPENROWSET command in Transact SQL.  This is also good option if you need cross-platform Crystal Report - pulling data from SQL Server and third party databases on the same report.
  • Warning - do not place existing 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 Technology Officer in Alba Spectrum Technologies - USA nationwide 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 multiple states and internationally (www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.


    MORE RESOURCES:

    Jive Software Q4 Earnings, Revenue Beat Street
    Forbes
    Updated: Enterprise social networking company Jive Software reported its first earnings as a public company today, beating Street earnings and revenue expectations. Jive generated $22.5 million in revenue in the fourth quarter of 2011, up 53% from the ...
    Photo Release -- Jive Software Announces Fourth Quarter and Full Year 2011 ...GlobeNewsWire (press release)
    Jive Software Q4 Loss Widens - Quick FactsNASDAQ
    Jive reports bigger 4Q loss, higher revenueBusinessWeek

    all 49 news articles »


    1 Software Stock to Buy Now
    DailyFinance
    The company, which specializes in providing accounting, inventory management, and other operational software over the Web, projected $0.19 to $0.21 in adjusted earnings on $295 million to $300 million in profits. All figures represented an increase ...

    and more »


    Advent Software Beats on EPS, but GAAP Results Lag
    msnbc.com
    31 (Q4), Advent Software beat expectations on revenues and beat expectations on earnings per share. Compared to the prior-year quarter, revenue expanded significantly and GAAP earnings per share contracted significantly. Advent Software notched revenue ...

    and more »


    American Software, Inc. Invites You to Join It's Third Quarter of Fiscal Year ...
    MarketWatch (press release)
    ATLANTA, Feb 07, 2012 (BUSINESS WIRE) -- In conjunction with American Software's Third Quarter of Fiscal Year 2012 Results /quotes/zigman/68042/quotes/nls/amswa AMSWA -2.11% , you are invited to listen to its conference call that will be broadcast live ...

    and more »


    Veeam Software Reports Record-Breaking Year in 2011
    EON: Enhanced Online News (press release)
    COLUMBUS, Ohio--(EON: Enhanced Online News)--Veeam Software, innovative provider of data protection, disaster recovery and management solutions for virtual datacenter environments, today announced results for the fourth quarter and full year of 2011.

    and more »


    Knoa Software Expands Executive Team with Addition of Michael Zuckerman as ...
    EON: Enhanced Online News (press release)
    NEW YORK--(EON: Enhanced Online News)--Knoa® Software, the leading provider of end-user management software, today announced the expansion of its executive team with the addition of Michael Zuckerman as chief marketing officer and vice president.

    and more »


    Guidance Software Acquires CaseCentral
    socalTech.com
    Pasadena-based Guidance Software, which develops digital forensics and e-discovery software, said Tuesday afternoon that it has signed a definitive agreement to acquire CaseCentral, a developer of electronic discovery software.
    Guidance Software to Acquire CaseCentralMarketWatch (press release)
    GUIDANCE SOFTWARE, INC.: Guidance Software Reports Q4 2011 Financial Resul..4-traders (press release)

    all 13 news articles »


    Rocket Software's $300 Million Dividend Loan Rises in Trading
    Bloomberg
    Rocket Software Inc.'s $300 million term loan to fund a dividend to Court Square Capital Partners rose in initial trading, according to data provider Markit Group Ltd. The six-year debt first exchanged hands at 99.88 cents on the dollar, according to ...

    and more »


    Bradenton Herald

    Hydrovolts Uses Autodesk Software to Create Plug-and-Play Water Turbines
    EON: Enhanced Online News (press release)
    (EON: Enhanced Online News)--Clean technology innovator Hydrovolts is using software from Autodesk, Inc. (NASDAQ: ADSK) to create unique hydrokinetic turbines that are more easily installed in rivers, canals and other waterways for faster generation of ...
    Hydrovolts Turbine For Clean Energy Generation, Designed With The Help Of ...TheStreet.com (press release)

    all 7 news articles »


    Confio Claims 2011 Growth
    techrockies.com
    Privately held Confio, the Boulder-based maker of database performance management software, reports today that it has 71 percent revenue growth in 2011. The firm--which did not disclose actual revenue numbers--also said it has more than doubled the ...
    Confio Software Finishes 2011 with Soaring GrowthEON: Enhanced Online News (press release)

    all 7 news articles »

    Google News

    Home | Site Map

    Powered By: Free Work At Home Business Opportunity!

    © 2006