Customer was running Salesforce for sales automation, Netsuite for ERP and finance and OpenAir for Project Management. Salesforce Opportunities were being manually converted into Netsuite Sales Orders, Netsuite Projects and OpenAir Projects. Product data was being updated in both Salesforce and Netsuite, along with the manual synchronisation of Customer data. There was a requirement to automate this process to eliminate manual entry, ensure data accuracy, provide visibility to payments and ensure a consistent reliable process for revenue recognition for their business.
| Purpose | Automate the creation of Netsuite sales orders from Salesforce Opportunities
Automate project creation from Salesforce to Netsuite and OpenAir Automate project updates from OpenAir to Salesforce and Netsuite Automate invoice and payment information from Netsuite to Salesforce |
| Applications | Salesforce CRM Netsuite OpenAir |
| Integration option | Boomi Atomsphere HTTP Connector (XML API) Salesforce Connector Netuite Connector |
| Information | Netsuite Item  Salesforce ProductSalesforce Account Netsuite Customer Salesforce Opportunity Netsuite Sales OrderSalesforce Opportunity Netsuite ProjectSalesforce Opportunity OpenAir ProjectOpenAir Project Netsuite ProjectOpenAir Project Salesforce Project (Custom Object)Netsuite Invoice Salesforce Invoice (Custom Object)Netsuite Payment Salesforce Payment (Custom Object)
|
| Data formats | XML |
| Integration process |
Products are created and maintained in Netsuite. Salesforce is the master for customer data. When an opportunity is closed, the integration process will create a Sales Order in Netsuite, a project in Netsuite and project in OpenAir. Invoice and payment updates are reflected in Salesforce. Project updates are reflected in both Salesforce and Netsuite. |
| Schedule | Several times/day |
| Time Spent | 25 days |
| Complexity | Complex |
