Invoice integration from CRM Online to GP 2013 using eConnect

About Scribe Online:
The Scribe Online Platform delivers Integration Services, Connectors and Solution Paks that help customers and partners:

• Replicate cloud data to a local database
• Integrate customer data across critical business systems such as CRM, Marketing Automation and ERP

About eConnect:
This article uses eConnect directly from a SQL stored procedure.
The stored procedures are executed from the Scribe Online integration solution to perform business logic verifications on the data being integrated and inserted into the appropriate transaction work tables in Dynamics GP.

1. Create a Scribe Online account http://www.scribesoft.com/Online

2. Integrate customer data across critical business systems such as CRM, Marketing Automation and ERP

Click to Enlarge

3. Install an on-premise agent to communicate with Dynamics GP which is installed on the amazon server.
The Agent is required to communicate with both your source and target data as well as with Scribe Online in the cloud.

Click to Enlarge

Click to Enlarge

4. Create an Advanced Map for integration between CRM accounts and Invoice integration to GP

Click to Enlarge

5. Create CRM Source connection by providing details and credentials as shown below:

Click to Enlarge

6. Create GP Target connection. Make sure to select ‘Support stored procedures

Click to Enlarge

7. Steps Forintegration

Click to Enlarge

Query Invoive from CRM
For Each Invoice- Insert Invoice Header in GP using stored procedure
Map the fields

Click to Enlarge

8. Insert Invoice line items Lookup product in GP Map the fields

Click to Enlarge

9. Run the solution

10. Check the data in Target

      Invoice in CRM

Click to Enlarge

Click to Enlarge

Click to Enlarge