Andrew Karasev, Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP Great Plains customers in USA/Canada nationwide. Local service is available in Houston, TX: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village; Chicago, IL: Naperville, Aurora, Bolingbrook, Romeoville, Joliet, Wheaton, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard, Woodridge, Darien, Westmont, Batavia, St. Charles, Elgin, Crystal Lake. Service is also available in Houston and Dallas metros, plus internationally in Canada, Australia, New Zealand, South Africa, Oceania and UK
Microsoft Dynamics GP, current version is 10.0, as of October 2007 – is successor of former Great Plains Software Dynamics/eEnterprise. Great Plains Software specially created GPS Dexterity technology and programming language to be used as the shell to abstract Dynamics business logic from computer operating system, database and graphical platform (such as MS Windows and MAC OS) in earlier 1990th. IM was initially and still is to the certain extent Microsoft Dexterity application, which uses Microsoft Dynamics GP workstation as OLE server to validate integration business logic behind the scenes. This is the reason, why performance might be a bit disappointing for large scale integration. However IM is powerful user friendly and “developer-friendly” tool, if you are comfortable with VBA scripting and ODBC SQL queries (including SQL data aggregation), you should be able to program advanced integrations
1. IM Queries. You can have tab or comma delimited text files as the sources (these are the most popular, especially tab delimited, as you can expect commas in customer or vendor names). The second option is ODBC queries, where you can have simple and advanced. Advanced will allow you to group records into one, good example is GL transaction import from one file, where you create GL transaction header by grouping records in the source by date. Advanced ODBC queries also allow you to script sophisticated SQL select statements (however you should be aware that ODBC standard does not support all SQL expressions and functions)
2. VBA Scripting. VBA scripting was very popular prior to the time when Microsoft introduced new software development and customization conception – Microsoft.Net. VBA scripting allows you to extend and customize Microsoft Office applications: Excel, Word, MS Access and as you could expect Microsoft Dynamics GP Integration Manager. As VBA was designed and it is applicable to GP IM – certain events are exposed to VBA developer: before document, before records, after document, after records – where you can intercept and replace or modify original IM logic. The example of interception would be changing document date to the end of the week
3. eConnect performance improvement project. IM is in the process of being rewritten in eConnect. eConnect has SQL stored procedures in its core and these are definitely or supposedly faster than Microsoft Dexterity cursors and OLE GP server
- Related Videos
- Related Articles
- Ask / Related Q&A
- Microsoft Dynamics Gp Great Plains Consultants With Industry Expertise
- Microsoft Dynamics Gp Great Plains East European Options Overview for Consultant
- Microsoft Dynamics Gp Great Plains Integration and Upgrade in Chicago
- Crystal Reports for Microsoft Dynamics Gp Great Plains – Overview & Faq
- Microsoft Dynamics Gp Great Plains Series and Modules Faq
- Microsoft Dynamics Gp Great Plains Custom Logic Programming
- Microsoft Dynamics Gp Great Plains Ecommerce Considerations
- Dynamics GP Great Plains in Russia, please consider instead SAP Business One
Preventive measures for avoiding PDF files corruptions
By: tech nova | 01/01/2010For dealing with PDF file corruption issues, considering prominent PDF recovery software is the best choice.
Preventive measures for avoiding PDF files corruptions
By: tech nova | 01/01/2010For dealing with PDF file corruption issues, considering prominent PDF recovery software is the best choice.
Signs that You Need to Perform a Graphics Driver Download and Other Solutions
By: Victoria | 01/01/2010The process of installing your driver to a freshly put operating system might trigger usability issues as a consequence at the very least if not a total computer breakdown problem.
The How To’s and Whys of Microsoft Driver Updates for XP
By: Victoria | 01/01/2010To ensure the smooth performance of your computer, Windows XP have packs of internal and system drivers that get to work every time you will use your machine.
SharePoint Development: Offering an Opportunity for Information Sharing and Collaboration
By: Arun Kumar | 01/01/2010All businesses from small to medium and large are increasingly feeling the need of information sharing and collaboration. The growing need for collaboration and information sharing is felt within an organization as well as outside of the organization and the organization itself to better make use of time and cost. Microsoft’s SharePoint is one such solution which allows you to streamline business operations and increase productivity through sharing and collaboration.
How to convert protected iTunes M4V movies to Plain MP4 AVI WMV DVD
By: Kindour | 01/01/2010The following step by step guide will share with you how to remove DRM from protected WMV and at the same time convert DRM protected WMV to DVD for backup, enhancement or playback on traditional TV sets, home DVD players with Media Converter Ultimate.
Document Management Systems Audits: Expecting a Documentation Audit in Your Work Environment?
By: Marci Lynn Crane | 01/01/2010Document management systems are often audited by third-parties auditors or even the internal auditors of a given corporation. Document management system audits are important as they determine what actions a company must pursue to have a status of “validity” as they utilize their document management system. As your company prepares for a DMS audit here’s a few things you might consider:
How Well do Document Management Systems Publish Documents?
By: Marci Lynn Crane | 31/12/2009Within regulated environments, the publishing of a document involves various processes. These processes include but are not limited to proofreading, public review, approval and printing. Most document management systems can implement any of these steps to a given document but not all document management systems are created equal.
Microsoft Dynamics GP Applying Service Packs Technology
By: Andrew Karasev | 30/12/2009 | SoftwareIf your organization deploys Microsoft Dynamics GP Corporate ERP, formerly known as Great Plains Dynamics, Microsoft Great Plains, we would like to review new Service Packs applying technology in this small publication, especially after hearing opinions from former Great Plains Consultants, who are now working in Industry IT departments.
Migration to SAP Business One from Great Plains Accounting Notes
By: Andrew Karasev | 30/12/2009 | SoftwareThere are still customers, who are on Great Plains Accounting for DOS, Windows or Macintosh, typically versions 9.5, 9.2, and earlier. When Great Plains Software encouraged its GPA customers to convert to Great Plains Dynamics at the end of 20th Century (as there was a concern of GPA not being year 2000 compliant, plus support for GP Accounting was about to expire those old good days), large number of GPA customers followed the advise and migrated.
Microsoft Dynamics GP 7.5, 9.0 version update notes
By: Andrew Karasev | 27/12/2009 | SoftwareAs recession seems to be over, now it is time to take care about your Corporate ERP application, and if it is Microsoft Dynamics GP (also known as Microsoft Great Plains and Great Plains Dynamics), this small publication might be helpful on introduction level
Ecommerce to Dynamics GP Real Time Integration: Order Connector
By: Andrew Karasev | 25/12/2009 | SoftwareIf your back office Corporate ERP application is Microsoft Dynamics GP, former versions were also known as Microsoft Great Plains and Great Plains Dynamics, and you have in-house developed ecommerce web application with items catalogs with advanced price lists (especially in B2B ecommerce scenarios), shopping cart, credit card processing, we would like to present you this small publication in the form of FAQ and orientation session.
Microsoft Dynamics GP Deployment and User Training Notes
By: Andrew Karasev | 24/12/2009 | SoftwareIf your organization plans to deploy Microsoft Dynamics GP, formerly also known as Great Plains Dynamics, eEnterprise and its predecessor Great Plains Accounting for DOS, Windows and Mac, we would like to offer you this small introduction level publication.
Great Plains Support: Covering All Versions - Dynamics GP, Pervasive SQL, GPA for DOS
By: Andrew Karasev | 22/12/2009 | SoftwareAll versions of Microsoft Dynamics GP and its predecessor Great Plains Dynamics and eEnterprise, plus earlier versions of GP on Pervasive SQL 2000 or Ctree (including Mac based Faircom version), as well as Great Plains Accounting for DOS, Windows or Macintosh are supportable. In this small publication we will review all versions of GPA, Great Plains and Microsoft Dynamics GP (from earlier 1990th up to May 2010) and their support methods.
Microsoft Dynamics GP Customization Support and Recovery Service
By: Andrew Karasev | 19/12/2009 | SoftwareIf you have current or old version of Great Plains Dexterity custom add-on module, or another modification type, such as Modifier with VBA scripts or eConnect application (including the case when it is Microsoft Visual Studio .Net C# or VB ecommerce integration project), GP Integration Manager advanced customization with VBA events handling scripts, simple or Advanced ODBC data sources, Great Plains Macros (including such cases, when you are moving ongoing transactions and master records...
eCommerce B2B and B2C Shopping Cart Integration to Microsoft Dynamics GP Programmer Notes
By: Andrew Karasev | 17/12/2009 | SoftwareIf you are working for the organization, deploying Microsoft Dynamics GP, formerly also referred as Great Plains Dynamics and your next step is ecommerce shopping cart integration to your Corporate ERP (Microsoft Great Plains Dynamics GP), we would like to recommend you this small publication written in FAQ technical style.