Software Information

Microsoft Great Plains Integration with Microsoft Access - Overview for Developer


Home | Site Map | 101InfoLinks.com | Best Book Shop | Sports Fans ONLY
     .
© 2007

 
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:

    LetsGoMobile (press release)

    Sony Ericsson to release software upgrade for C905
    CNET News, CA - 13 hours ago
    Starting in mid-February, C905 owners can download a software update from Sony Ericsson's Web site that will bring new features to the camera phone. ...
    Sony Ericsson to Provide Software Updates for C905 8 Megapixel ... SlashPhone
    all 51 news articles


    Acresso Software Finalizes Intraware Acquisition
    CNNMoney.com - 17 hours ago
    Acresso Software (Acresso), a privately-held company and an investment of private equity firm Thoma Bravo, LLC, announced today it has completed the ...


    Times Online

    Apple unveils software updates, new laptop
    San Francisco Chronicle,  USA - Jan 7, 2009
    The presentation included updates to the iLife and iWork software suites, a new 17-inch MacBook Pro with an 8-hour battery and a new digital rights ...
    Video: Steve Jobs Weight Loss Due to Hormone Imbalance AssociatedPress
    Macworld goes for the soft sell with budget-minded software USA Today
    Apple's Macworld Surprise Is the Software PC Magazine
    The Associated Press - Reuters
    all 2,918 news articles


    CNET News

    Sun Acquires Cloud Computing Software Supplier, Q-Layer
    InformationWeek, NY - 10 hours ago
    The Belgian company makes data center modeling and management software that helps companies organize their computing resources as a cloud computing layer. ...
    Sun Acquires Cloud Computing Automator Q-layer eWeek
    Sun Buys Cloud-computing Vendor Q-layer PC World
    Sun acquires cloud computing vendor ZDNet
    TheStreet.com - ITProPortal
    all 92 news articles


    Macworld

    IBM Lotus Delivers New "Social" Notes and Free Symphony Software ...
    CNNMoney.com - Jan 6, 2009
    At Macworld, IBM (NYSE: IBM) today announced the availability of Lotus Notes 8.5 collaboration software with social computing features for all Mac OS X ...
    Macworld: IBM finalizing free Symphony office suite for Macs Computerworld
    Lotus Notes 8.5 ships, free IBM Symphony suite coming MacNN
    WebEx goes mobile on iPhone; Notes 8.5 ships on Macs ZDNet Blogs
    VNUNet.com - eWeek
    all 55 news articles


    Telegraph.co.uk

    ITunes embraces 3-tier pricing, will remove anti-copy software
    Los Angeles Times, CA - Jan 6, 2009
    Apple also updated much of its software. The latest version of iPhoto scans for individual faces so computer users can label photos of friends or family, ...
    Apple removes protection software from songs TourDates.Co.Uk
    Apple changes iTunes prices; removes copy protection USA Today
    Apple changes iTunes pricing CNNMoney.com
    Bloomberg - Shiny Shiny
    all 1,174 news articles


    MacNN

    Autodesk offers three new Mac creative software tools
    Macworld, CA - 17 hours ago
    by Peter Cohen, Macworld.com Autodesk, which is not participating in Macworld Expo this week, introduced three new creative software tools for the Mac ...
    Autodesk releases Toxik, Mudbox, Stitcher for Mac MacNN
    Autodesk adds Mac versions of Toxik, Mudbox and ImageModeler 2009 Digital Arts Online
    all 35 news articles


    Bonaire Software Solutions Announces EMPOWER/BI Business ...
    MSNBC - 16 hours ago
    BOSTON, MA - Bonaire Software Solutions, LLC today announced its new business intelligence product -- EMPOWER/BI. "Bonaire's EMPOWER/BI, designed ...


    CNET News

    FileMaker Banks on Ease of Use, Flashy Interface With New Database ...
    eWeek,  NY - 17 hours ago
    By Brian Prince FileMaker released version 10 of its database software this week. FileMaker hopes a redesigned interface and a number of feature ...
    FileMaker Pro 10 Gets New Look InformationWeek
    all 66 news articles


    Updated FlukeView(R) Forms 3.4 Software Enhances Compatibility ...
    MSNBC - 16 hours ago
    With FlukeView Forms documenting software, the logging capabilities of handheld test equipment can be used to solve tough problems. ...

    Software - Google News


    Google
     

    Home | Site Map | 101InfoLinks.com | Best Book Shop | Sports Fans ONLY
         .
    © 2007