MICROSOFT DYNAMICS GP AND DYNAMICS CRM INTEGRATION PREREQUISITE 2

If yo want to integrate Dynamics CRM and Dynamics GP sales information, which might be customers and invoices and orders, etc, you need to have salespersons defined and identical in each system. so once you run the integration, you can assign the records from GP to appropriate owner in CRM.

This is the query to get the salespersons from  GP database:

  select RM00301.SLPRSNID,RM00301.SLPRSNFN , RM00301.SPRSNSLN, RM00301.SALSTERR,   * from RM00301
  where RM00301.INACTIVE='0'
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s