(1888PressRelease)
May 02, 2007 - Simple Integration. This is when you have text (preferably tab delimited file, not comma delimited, because in some cases you customer or vendor description will include comma characters). You build your initial query upon text file and then you select your destination: Sales Order Processing, Customer Master, Vendor Master are ones of the most popular destinations. If simple integration works Ok for you, this is great and you are positioned to go ahead and put it into production
ODBC integration. This is where you would like to do some tricks, good example is GL transactions integration one source here you would like to aggregate GL header record and then link it with GL lines. The advantage of ODBC compliance is the possibility to use group by statement of SQL
Data Translation. This is next step for you to dive into customization world. Imagine you work for collection agency and your customer AR is then transformed into Vendor AP (as you do your job and virtually collect the bad debts). In this scenario you should be able to create translation Excel file, and import it into your integration for AR or SOP
VBA scripting. This is probably the most advanced technique associated with GP Integration Manager. Consider the situation: you have text file which lists your due dates, vendor invoices and payment amounts. This is from opposite side, but from your side you had vendors sign the agreement that you will pay all invoices submitted in the month by the end of the first week of the following month. This is where you need payment document manipulation technique in IM. VBA scripting is very old (late 1980th) Microsoft blend of VB programming language and you can find plenty of VB programmers on the job market, however if they will be doing GP data programming some GP technical training and business logic exposure might be recommended
Andrew Karasev, Alba Spectrum Group
http://www.albaspectrum.com
help ( @ ) albaspectrum dot com
1-866-528-0577, 1-630-961-5918,
serving GP customers in USA/Canada/Australia/UK/New Zealand nationwide: Ontario, Quebec, Calgary, British Columbia, California, Florida, Arizona, Colorado, Georgia, Virginia, New York, Nevada, Nebraska, Utah, North and South Dakota. Local service is available in Houston/Dallas area: Rosenberg, Katy, Richmond, Sugar Land, Galveston; in Chicago/Springfield: Bloomington, Normal, Peoria, Naperville, Plainfield, Aurora, Romeoville, Lisle, Downers Grove, Batavia, Elgin, Crystal Lake, Montgomery, Oswego, Morris, Ottawa, Marseilles.
