Configuring Sage CRM v7.2 – Sage 300 ERP 2012 integration

By | November 18, 2013

Recently Sage has released Sage CRM v7.2- Sage 300 ERP integration module. We will be explaining how to configure the Sage CRM v7.2 integration to Sage 300 ERP in a very easy manner.
The New Stuff: How to identify and backup correct Sage CRM Database
You just need to make sure that Sage CRM integration component is installed on Sage CRM server and Sage 300 ERP 2012 integration component checkbox is checked while installing Sage 300 ERP.
A) Configuration in Sage CRM v7.2
B) Configuration in Sage 300 ERP 2012
A) Configuration in Sage CRM v7.2
1) Login to Sage CRM.
2) Navigate to Administration |Sage 300 ERP Administration.

Note:
These options will be visible only if the Integration component is installed on Sage CRM instance.
3) Initially only 2 options will be visible to you. i.e. Setup Integration and About Sage CRM Integration.
Img1
4) Click on Setup integration to configure Sage 300 ERP 2012 parameters. You will get below screen. Configure as mentioned below.
Database Id: Database name of Sage 300
Sage 300 ERP Company Name: Name of Sage 300 Company
Sage 300 ERP Server Name: net://<<Server Name>>:9000
Img2
5) As soon as Save button is clicked, you will see below screen in Sage CRM with Synchronize Tables and Sage 300 ERP additional options.
Img3
6) Click on the Sage 300 Database Level Security options and click on New button to configure CRM Username, Sage 300 Company Name, Sage 300 ERP User ID and Password.
Img4
7) Once it is done, Sage CRM configuration for Integration is done. You can check the same by clicking on Synchronize Tables option and then Synchronizing all the Tables.
B) Configuration in Sage 300 ERP 2012
1) Login to Sage 300.
2) Navigate to Sage CRM |Sage CRM Setup.
Img5
Note:
These options will be visible only if the Integration component is installed on Sage 300 ERP server.
3) Click Sage CRM setup.
Img6
a) Sage CRM Installation Name: Name of Sage CRM instance.
b) Sage CRM Server Name: Name of Sage CRM server.
c) Sage CRM web Services URL: URL automatically gets updated based on entered Sage CRM instance and Sage CRM Server name after clicking on the Sage CRM Web Services URL.
d) Click on Save button.
4) Now, navigate to Workstation Setup.
5) Click Workstation Setup. You will get below box.
Img7
6) Click Test to get the confirmation message saying Sage 300 is now setup to communicate with Sage CRM Web Services.
Img8
Once done, Sage CRM v7.2 and Sage 300 ERP 2012 integration has been completed.
Also Read:
1) New Item Inventory Lookup in Sage CRM – Sage 300 ERP integrated system
2) .NET Web Deployment for Integrated Sage CRM
3) Issues while upgrading the Sage CRM-ACCPAC integrated system
4) Failed to update Sage CRM company status error
5) Dropdown Sync in Sage CRM System