La Jolla

Microsoft Dynamics GP Integration Manager module is very simple, especially when the input data is prepared and structured in CSV or tab file delimited text. The same result if data is ODBC compliant and can easily assign the destination. However, very often in the situation where no can control the incoming text file and massage in the application. To achieve this goal, you must deploy Advanced ODBC Queries. A good example is when you import bills customers and some of them might be negative, in which case it is necessary to treat them as statements or orders of processing or receipt of Management Memos credit. Let's review the steps and highlights:

1. Create an ODBC DSN. Suppose we have obtained the export values separated by commas (CSV). Open the Control Panel, Administrative Tools, ODBC, select the System tab, Microsoft Text driver, uncheck Use Current Directory, select the directory in the text file is found, the exchange rate to a CSV file and if you have column names in the first row, then save and close the DSN. Sometimes this step you are getting an error message, it blocks the names of the savings in the first column of the line – if this happens to you – it only works with generic set of columns

2. Create Advanced ODBC query in IM. Here, you use SQL select group, the union and having clauses. The sample application in the header – to filter all credit notes, they document conditions are negative. Please not that in the case of having invoice lines in the source – negative document are can be calculated within the group by statement – check the conditions (quantity) quantity less than zero

3. If SQL query in the text file is too complex. In this case, consider creating SQL Server DTS package that moves a text file into a SQL table and the staging process through one or more procedures SQLL stored data to massage to fit the requirements of integration. When you are ready for the table data in SQL Server, advanced base their request for ODBC SQL View

4. Beyond Integration Manager. If you need to integrate online real time, and if you are on Great Plains version 9.0, 10.0 or later, consider programming integration routine in eConnect. eConnect allows you to create GP objects from your application e-commerce

Andrew Karasev, Alba Spectrum LLC, help@albaspectrum.com – http://www.albaspectrum.com – 1-866-528-0577 , Great Plains, VAR, Partner and Reseller in Illinois, Georgia, South Carolina, California, Texas. Please visit our info portal Pegas Planet: http://www.pegasplanet.com Local Service in Chicago, Atlanta, San Diego, Los Angeles, Orange County, Houston. We also have Dexterity Software Development Factory and SB1 Technical Support Call Center, serving USA country side businesses and internationally: Canada, Brazil. Illinois practice: Naperville, Aurora, Plainfield, Marseilles, Ottawa, DeKalb, Springfield, Oakbrook, Glenn Ellyn, Wheaton, Bolingbrook, Romeoville, Lisle, Melrose Park, Brookfield. San Diego and LA practice: Rancho Bernardo, Oceanside, Poway, Long Beach, Irvine, Mission Viejo, San Marcos, Carlsbad, La Jolla, Escondido. Houston Practice: Dallas, Galveston, Sugar Land, Pearland, Katy, Pasadena, Rosenberg, League City, Galena Park

Laboratory Study (1/3) of Pranic Healing Using Cells in Culture Subjected to Gamma Radiation.