Andrew Karasev, Alba Spectrum Group, 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com http://www.albaspectrum.com, servicing customers in Chicago, Houston, Dallas, Rockford, Milwaukee; Illinois, Texas. Via remote support we serve USA Nationwide: California, New York, Virginia, Florida, Georgia, Colorado, Minnesota, Utah, Canada: Toronto, Montreal, Vancouver, Quebec-City. Please not that our local service is available in Chicago area: Naperville, Downtown Chicago, Warrenville, Bolingbrook, Romeoville, Joliet, Aurora, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard. In Houston Metro: Richmond, Sugar land, Rosenberg, Stafford, Meadows, Katy, Mission Bend, Pasadena, Pearland.
Microsoft Dynamics GP 10.0 is SQL 2005 application, however direct SQL scripting to feed or integrate eCommerce orders or invoices and payments might be complicated, due to rich GP business logic and its required validation in data integration. As eCommerce typically sends sales data to Great Plains Sales Order Processing module, which is really eConnect covered area, we recommend you first research Microsoft Dynamics GP eConnect technology, we will review eConnect in brief in this article below. Direct data feeding via SQL stored procedures is also OK if you try to restrict your integration functionality: do not allocate inventory items in SOP lines, create sales orders rather than invoices (to avoid building up GL distribution in your SQL scripting). Let’s begin:
1. eConnect. This tool and SDK was specially developed for eCommerce programmer, and later on Microsoft Business Solutions advanced eConnect and now it is covering other modules: POP, Payroll, General Ledger, etc. If you dig deeper, you will figure out that the heart of eConnect is set of encrypted SQL stored procedures. These procedures imitate GP Dexterity business logic in creating, deleting, modifying master records and work transactions. eConnect should be preferred tool as it validates Dex business logic and is recommended by MBS for e-commerce developers. If you think that eConnect is not a relevant tool for you, you can go ahead and take SQL querying route
2. SQL. Here you need to be comfortable with your GP SQL tables familiarity. The best tables reference could be found in GP workstation: tools->resource description->tables. Tables are sorted by series, you go to Sales, sort by tables physical name and jump to SOP10100 – this is Sales Header table, it keeps Sales Order, Invoice, Return, Quote document header. The second table will be SOP10200 – this one stores sales document lines: inventory items or non-inventoried items
3. eConnect and Batches posting. GP architecture has several phases of transaction life: work, open and history and among these phases only work transactions could be created in eConnect and be submitted for GP operator approvals. In eCommerce application you often want to post payments against invoice plus you want invoice to be posted and scheduled for delivery. If this is the case, you should research Alba Spectrum Posting Server, which is extension to eConnect and by technology it is Great Plains Dexterity application, appealing to Dex source code – developer places approved GP batches to custom table and posting server calls GP Dexterity native logic to post the batches
4. GP Integration Manager. If the volume of eCommerce transactions is relatively low and you are small organization, you can consider integration e-commerce transactions via IM over night. IM deploys GP as OLE server and so, GP workstation should be running behind the scenes. Some customers report IM performance issues, which is normal scenario for OLE server, where you open and feed data into GP hidden forms and screens.
- Related Articles
- Related Q&A
- Microsoft Dynamics Gp 10.0 Customization Scenarios
- Microsoft Dynamics Gp – Typical Customizations
- Microsoft Dynamics Gp 10.0 Technical Notes or Under the Hood
- Automatic Batch Posting in Great Plains Microsoft Dynamics Gp Overview
- Custom Sales Order System Integration With Great Plains Microsoft Dynamics Gp
- Great Plains Microsoft Dynamics Gp Implementation in Florida
- ECommerce Integration Developing for Microsoft Dynamics GP Notes
- Development for Microsoft Dynamics GP, formerly known as Great Plains: Dexterity, eConnect, eCommerce programming
A Simple Steps to Make Your Pc Run Faster
By: minping peng | 08/01/2010Spending much money for with High-End Configuration isn't the only way to accelerate you PC in your house and your office. It is will cost you too much money and at the end it's speed will be down every bit as other computer, in that situation, you will be so worried about how to speed up your computer.
Kanban Leader Ultriva CEO to Present at January 13 Cincom Webinar
By: Thomas Cutler | 08/01/2010Kanban Leader Ultriva CEO to Present at January 13 Cincom Webinar
Ruby Red Harvest Adopts TraceGains CaseTrace PTI Printing, Labeling, and Compliance Solution
By: Thomas Cutler | 08/01/2010Ruby Red Harvest Adopts TraceGains CaseTrace PTI Printing, Labeling, and Compliance Solution
AiRISTA Unveils Asset & Personnel Tracking Solutions Based on Wi-Fi TDOA Technologies
By: Kari Nelson | 08/01/2010AiRISTA continues to bolster its technological leadership position and extend its initiatives of offering unified visibility into the location and status of assets, personnel, processes and environmental conditions.
SharePoint consulting companies a new opportunity to shine
By: Joy Brain | 08/01/2010Microsoft SharePoint 2010 gives SharePoint consulting companies a new opportunity to shine. SharePoint 2010 boasts improvements that make custom solutions for businesses that make it possible to cut costs, improve productivity with cost effective maintenance.
The Importance of Evidence Eliminator in an Ever Connected World
By: Anne Alaska | 08/01/2010In an ever connected world, people have one common problem. That problem is the privacy problem. The more people connect to you, the more they can see what you are doing. And this problem occurs in the least unexpected of places- your computer. That is why in this article you will walk through the importance of Evidence Eliminator in an ever connected world.
iMovie import MPG, MPEG to iMovie - How to import .mpg video files to imovie with MPG to iMovie Converter
By: appletv1985 | 08/01/2010With mpg to imovie for mac, you not only can importing .mpg video files into imovie, but also can importing AVI, MP4, MOV, FLV, WMV,TS, DV, F4V, MKV, TOD, AVCHD, HD Video, etc. into imovie on Mac.
The Easy Way To Non Profit Accounting
By: Tom Hope | 08/01/2010Accounting, also known to some as bookkeeping, is all about numbers. For any organization, it is important that figures line up accurately, in order to manage the flow of resources with exact precision.
ECommerce Integration Developing for Microsoft Dynamics GP Notes
By: Andrew Karasev | 07/01/2010 | SoftwareWhen you have legacy in-house programmed ecommerce web application in production with shopping cart, credit card payment interface, B2B or B2C items catalogs and promotional pricing - which does the job - likely that you will favor the idea to leave it there and try the way of ecommerce integration connectors to your Microsoft Dynamics GP Corporate ERP application.
Microsoft Dynamics GP User Training Notes
By: Andrew Karasev | 06/01/2010 | SoftwareThe best results in user training for your Corporate ERP application could be achieved if trainer role is performed by your original Dynamics GP Implementation consultant. In that case you do not have to waste your users time and concentration on the features and procedures, which are not directly related to their day to day Dynamics GP data entry routines
Microsoft Dynamics GP 2010 Payroll Tax Update Notes
By: Andrew Karasev | 05/01/2010 | SoftwareIf your organization processes US Payroll internally in Microsoft Dynamics GP 10, 9.0 or earlier version: GP 8.0, 7.5, Great Plains 7.0, 6.0, 5.5, 5.0, in this small publication we would like to review annual Payroll Tax rates update methods.
Microsoft Dynamics GP: Recovering Failed Implementation Notes
By: Andrew Karasev | 04/01/2010 | SoftwareYour Microsoft Dynamics GP (Microsoft Great Plains, Great Plains Dynamics or Great Plains Accounting for DOS, Windows or Macintosh), not successful implementation story might be not unique. GP is mid-market Corporate ERP application, where industry expertise might be required, plus profound technical exposure for your chosen Dynamics GP Partner. Of course, if you are insisting on coming through quick Sales cycle, there is often a temptation to sell you Dynamics GP software license...
Exporting Data from Dynamics GP Notes for Consultant
By: Andrew Karasev | 03/01/2010 | Information TechnologyThere might be situations, where you need to extract info from Microsoft Dynamics GP (formerly known as Great Plains Dynamics or Microsoft Great Plains) table. In this small publication we will describe you two scenarios. First, when you need one tame data export for following data conversion into future Corporate ERP accounting system (when you are walking away from Dynamics GP to something like SAP Business One, Oracle eBusiness Suite, etc.), and second - when you need ongoing data export
SAP Business One Full Service in Chicago and Atlanta Consulting Notes
By: Andrew Karasev | 02/01/2010 | SoftwareThis small and mid-size business Corporate ERP and MRP application is relatively new on US accounting software market, however it is so flexible and robust (plus it has SAP brand, which is important in the sense of reliability and future commitment), that it provides tough competition to such traditional lower mid-market Corporate ERP applications as Microsoft Dynamics GP (formerly known as Great Plains Dynamics), Microsoft Small Business Financials (this small business corporate ERP...
Great Plains US Payroll Tax Update Service Notes
By: Andrew Karasev | 31/12/2009 | SoftwareFor customers on older versions of Microsoft Dynamics GP, Great Plains Dynamics and eEnteprise, in the case when you are processing Payroll internally (including W2 printout and mailing to your employees) - we would like to let you know that it is possible to update Federal, State and Local Taxes directly in Dynamics GP Payroll tables. We traditionally offer this service at the end of the calendar year, or in January at your convenience.
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.