Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/a26f9f83/public_html/articles/includes/config.php on line 159
Microsoft Great Plains Integration with Microsoft Access ? Overview for Developer > NetSparsh - Viral Content you Love & Share

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.

    In The News:

    This RSS feed URL is deprecated, please update. New URLs can be found in the footers at https://news.google.com/news

    The Verge

    Google is using software to make the Pixel 3's screen corners even rounder
    The Verge
    Material Theme, an updated version of the company's software design philosophy, is the driving force behind the Gmail and Chrome redesigns of late, and you'll notice it most prevalently in the new Chrome tab design that eschews rough and pronounced ...


    TechCrunch

    Buggy software in popular connected storage drives can let hackers read private data
    TechCrunch
    Security researchers have found flaws in four popular connected storage drives that they say could let hackers access a user's private and sensitive data. The researchers Paulos Yibelo and Daniel Eshetu said the software running on three of the devices ...


    Pinterest's Evan Sharp on the Future of Software
    WIRED
    Over the next few weeks we'll be publishing these taped conversations as a part of the podcast. In this particularly interview, Mike and Arielle ask Sharp what it's like to receive praise from Ive, how machine learning is changing software design, and ...


    Coupa Software Acquires Aquiire For Supplier Catalog Search
    Seeking Alpha
    Coupa has acquired Aquiire for an undisclosed amount. Aquiire has developed a highly regarded B2B eProcurement system. For COUP, the deal should bolster its Business Spend Management platform and provide customers with cost-reduction capabilities ...

    and more »

    GeekWire

    Software company Qualtrics files to go public
    MarketWatch
    Qualtrics International Inc., a Utah-based software company filed for an initial public offering Friday. The company did not yet provide a number of shares it expects to offer or an expected price, but said it plans to raise $200 million, which is ...
    Cloud software company Qualtrics plans to follow rival SurveyMonkey to the public marketsCNBC
    Qualtrics files for $200M IPO, continuing the trend of enterprise software companies going publicGeekWire

    all 11 news articles »

    Motley Fool

    Check Point Software Will Be Checking In With Investors Next Week
    Motley Fool
    Check Point Software Technologies (NASDAQ:CHKP) is dawdling even as the broader cybersecurity market is growing at a solid pace. The cybersecurity specialist has been more concerned with share buybacks and growing its bottom line, even as rivals are ...

    and more »

    Crunchbase News

    Early-Stage SaaS VC Slip Snaps Recovery As Public Software Stocks Soar
    Crunchbase News
    However, the investment boom times didn't necessarily carry over to the seed and early-stage end of the subscription software businesses. The chart below displays deal and dollar volume of seed and early-stage venture investments made into companies ...


    C4ISRNet

    The Army will test new software for its vehicles' computers
    C4ISRNet
    The two software products, which operate on Mounted Family of Computer Systems (MFoCS) hardware, include Frontline v2.0 — the core software that has a common look and with Command Post Computing Environment software — and the Android Tactical ...


    San Antonio Business Journal

    How the military is developing cybersecurity defenses quicker
    San Antonio Business Journal
    When the commercial software market shifted to apps, it was obvious that the old way of developing software had to go. With regular security and capability upgrades now expected by consumers, Silicon Valley companies replaced the traditional lengthy ...


    Health Data Management

    Salinas Valley using Pure Storage software to aid legacy performance
    Health Data Management
    Salinas Valley Memorial Healthcare System in Salinas, Calif., has gone live on software from Pure Storage to improve the performance of legacy applications, as well as supporting a next-generation electronic health record and a picture archiving and ...

    Google News

    Causes of ERP Failures

    ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

    Dont Choose Adobe When Working With PDF

    While Adobe is the most known maker of PDF tools,... Read More

    Microsoft CRM for Large Corporation ? Security

    Microsoft Business Solutions CRM proved to be reliable solution in... Read More

    Keeping Track

    One of the things we can be as certain of... Read More

    3 Reasons Why Medical Billing Software is Leading the Way

    Since technology changes so quickly, it is hard to begin... Read More

    Cisco Certification: Introduction To ISDN, Part V

    The major reason I recommend getting your hands on real... Read More

    Separate Anti-Keylogging Protection: Who Needs it Most?

    If there still are few unprotected computers left, I haven't... Read More

    Is Your Family Protected?

    When you think... Read More

    Free Software: How Not To Get More Than You Bargained For!

    I completed an experiment recently. I wanted to find out... Read More

    Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

    If you are software developer or database administrator - we... Read More

    Microsoft Great Plains PM: Payables Management

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    Snort for Network IDS

    What is Snort?Snort is an open source network intrusion detection... Read More

    Need of Document Management System (DMS)

    Document Management or Enterprise Information Management is perhaps one of... Read More

    Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

    Microsoft Retail Management System serves retail single store as well... Read More

    The Importance of Timely Timesheets

    Whether you are a small consultancy firm, a medium sized... Read More

    Microsoft Great Plains BR: Bank Reconciliation

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

    If you would like to pick something from Microsoft, or... Read More

    Microsoft Great Plains Middle East - Arabic Language Support

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

    ERP Consulting: Microsoft Great Plains Partner Future Directions

    In the Clinton era the status quo was simple: you... Read More

    Dreamweaver vs FrontPage

    There are two major WYSIWYG(What You See Is What You... Read More

    Linux Dual Boot-How To Format

    Just the thought of a duel-boot scares many people away,... Read More

    A Simple Guide To Wikis

    A wiki is an editable text-based website. But you don't... Read More

    Windows Screensavers Explained

    In this article you will find some background information about... Read More

    Microsoft Great Plains Customization Tools ? Overview

    Former Great Plains Software Dynamics/eEnterprise, and currently Microsoft Business Solutions... Read More

    Make or Break Factors - When Considering Estimating Software

    Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More