Microsoft Dynamics GP Integration With Ms CRM, Where eConnect Doesn?t Work ? Alba Spectrum

Microsoft Great Plains and Microsoft CRM both use MS SQL Server 2005 or 2000 databases, GP has eConnect tool, which covers MBS owned GP modules: GL, SOP, POP, PM, RM, Payroll

Microsoft Great Plains and Microsoft CRM both use MS SQL Server 2005 or 2000 databases, GP has eConnect tool, which covers MBS owned GP modules: GL, SOP, POP, PM, RM, Payroll. So, if you plan ?standard? integration, our suggestion is to deploy eConnect. If you use third party GP modules, such as Wennsoft, Mekorma and others, you will have to use SQL Stored Procedures to feed data into Great Plains.

Let?s consider high-level technical scenarios:

1. CRM->GP. You have two scenarios here. The first scenario works if you are strong Visual Studio developer with C# skills, consider Microsoft CRM SDK programming to pull objects from CRM. Then to push them to GP, you should create series of stored procedures and call them via ADO.Net objects in C# project. VB.Net should be also OK, however you may see fewer number of sample codes to help you in MS CRM SDK objects programming. In the second scenario, if you don?t really like the idea to deploy CRM SDK based Visual Studio .Net project, then simply create new database (named something like crmcustomization, as you can not create custom stored procedures and views in CRM databases ? they will be wiped out by upgrade). Then go ahead and create set of stored procedures, which will pull and mark data as processed from MS CRM ? here you should get good familiarity with linking CRM tables by GUID column

2. GP->CRM. If you need objects to go backward to CRM, then the only option would be MS CRM SDK (if you are not using something like Scribe or another tool available for purchase on the market). Pulling data from Great Plains is fairly simple. Research tables structure: Tools->Resource Description->Tables and you will be prepared to send master records: customer, vendor, employee, account; work transactions: quotes, orders (SOP10100 and SOP10200 tables), etc.

3. eConnect posting dilemma. If you are deploying Connect to feed Sales transactions to GP from your eCommerce application, then you will realize that you can not force eConnect to post sales batches. eConnect by its architecture works with master and work records only. To do posting you have two options ? first one would be code posting logic in SQL or Microsoft Dexterity; the second option is to deploy Albaspectrum posting server, which utilizes Dexterity posting logic and allows you to put the batch in the approved posting queue ? then Microsoft Dexterity will do the rest of posting job. Posting Server works with all standard GP modules

Andrew Karasev, Alba Spectrum Group help ( @ ) albaspectrum dot com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP USA and Canada nationwide: Toronto, Montreal, Vancouver, Calgary, Windsor, New York, San Francisco, Los Angeles, Miami, Orlando, Pittsburg, Toledo, Indianapolis, Detroit, Philadelphia, Boston, Washington, Seattle, San Diego, Phoenix, Austin. Local service is available in Chicago and Houston metros: Rosenberg, Katy, Richmond, Dallas, Galveston, Sugar Land, Naperville, Wheaton, Plainfield, Aurora, Wheaton, Downers Grove, Lisle, Oakbrook, Morris, Marseilles, Joliet, Montgomery, Oswego, DeKalb. With reasonable travel we serve Springfield, Bloomington, Normal, Peoria, LaSalle, Ottawa, Dixon


Contact Details

Company Name: Alba Spectrum Group
Issued By: Andrew Karasev
Phone: 1-866-528-0577
Zip: 60565
Website: Visit the website

by Andrew Karasev (few years ago!)

Latest Press Releases

The Mad Hatter Now Offer a Full Line of Hearth Products and Full Line of Grills

Diabetes Insulin Delivery Pens Market Research Report 2018

Dr Kapadia Provides Tips to Patients Interested in Hair Transplant Procedures

love vashikaran specialist

Solar Blanket Sales Market Report 2018

Spring Bottled Water Market Insights, Forecast to 2025

Biochemical Incubator Sales Market Report 2018

Quinine Sulphate Sales Market Report 2018

Automotive Chassisc System Market Insights, Forecast to 2025

2,6-Dicarboxypyridine market size in key regions like North America, Europe, Asia Pacific an..

Remove this press release ?

Due to extra work required to remove the press-releases we have started charging $1.99 for press release removal.

Your press release will be removed in 24 hours, once the payment has been received.

Search Press Release
e.g. Business, Computer, etc.