12/27/2023
Explore Optimized Salesforce Solutions on Aptaria’s Revamped Website
We're thrilled to introduce our new website, designed to cater to organizations seeking unparalleled and transformative Salesforce solutions. Learn more.
Welcome to our new website! Learn more about how we help Associations succeed with Salesforce solutions. Learn More >
December 04, 2023 | Andrew Lawlor
A major financial services company that provides funding to small and medium-sized companies needed a data-driven, 360-degree view of its business, starting from the moment a prospective client applies for funding and proceeding as the client makes payments, which continues indefinitely.
To support its business objectives, the firm would need a customization of its Salesforce CRM software, plus a seamless integration of that software with NetSuite, its separate cloud-based accounting tool.
Although it provides financing to businesses, unlike a traditional lender that expects to be repaid with interest over time, the firm purchases a percentage of its clients’ future accounts receivable.
Also, while lenders may take months to investigate their applicants’ past performance and available collateral, the firm offers a simple online application process and makes decisions about funding in as little as 72 hours.
Prospects who apply for funding online are entered into the company’s Salesforce system.
The application is reviewed by staff, and a decision is made.
When the applicant is approved and accepts funding, it becomes a client.
Data must then be shared seamlessly and automatically with its accounting system, which is built on the NetSuite platform.
NetSuite is popular with many companies for its sophisticated accounting and enterprise resource planning (ERP) tools.
However, though NetSuite does offer a customer relationship management tool, Salesforce is the undisputed best-of-breed CRM solution.
Conversely, some feel that Salesforce lacks the sophisticated ERP and accounting solutions that NetSuite delivers.
So it’s not surprising that the finance company wanted to access the benefits of both systems.
Yet despite NetSuite’s suggestion that its software integrates easily with Salesforce out of the box, the truth is that its data-sharing needs — like those of many companies — are far too sophisticated for a simple integration.
In fact, many enterprise businesses face a similar challenge to the finance company when it comes to integrating their customer relations management solutions with their accounting software.
Without Aptaria’s integration, it would have been faced with several less-than-ideal options.
It could have chosen not to integrate the two platforms at all.
That would have left its customer relationship data separate from its accounting data, forcing employees to manually transfer data between Salesforce and NetSuite whenever a prospect signed the paperwork to accept funding.
Businesses that choose this path often do this by copying text from Salesforce fields and pasting it into NetSuite (or vice versa), inevitably making data-entry errors as they go and wasting hours of time.
Or it might have chosen one of the packaged connectors that claim to integrate the two systems out of the box, without significant customization.
But these adapters don’t work very well for businesses that have complex data-sharing requirements, as the financing firm does.
A third option would have been to rely on expensive middleware that sits between the two platforms and acts as a kind of universal translator.
While that may be a reasonable solution for companies that need to integrate many different enterprise applications, when striving to share data only between NetSuite and Salesforce, it makes more sense to build the integration directly from one platform to the other without the need for middleware.
The SuiteTalk API exposes NetSuite’s web services, allowing developers to build the integration entirely on the Salesforce side.
Post-integration, accounts, and contacts are created in Salesforce and then automatically pushed to NetSuite.
Virtually no development work is necessary on NetSuite.
Instead, Aptaria’s solution is built on Salesforce calls on NetSuite whenever critical data is entered into Salesforce, automatically synching with NetSuite on a near-real-time basis.
It sounds simple enough.
However, the unique data-sharing needs of the financing company made this integration more complex.
First, because each application represents a potential deal for the financing company, its applicants for funding are its prospects.
So, its Salesforce software needed to be reconfigured to recognize those applications as Opportunities.
So Aptaria renamed the Opportunity object in the company’s Salesforce system to the “Application” object.
The graphic below represents each of the distinct data integrations that Aptaria developed for the client. In all, the integration includes transferring nine unique data types, each initiated from Salesforce via SOAP calls to NetSuite.
Yet simply synching data between Salesforce and NetSuite isn’t enough, for two reasons. First, the financing firm often works through brokers who are owed a commission when the deal is approved. So in addition to creating the standard sales order, Aptaria’s software also creates a separate record to advise accounting to pay the commission.
Second, the sales orders themselves needed customization, because each sales order includes line items that define particular fees associated with funding that business. So the integration software has to push the necessary data to NetSuite to create those line items on each purchase order. The financing company’s case was particularly intricate due in part to the sheer number of data types that needed to be integrated between NetSuite and Salesforce.
Yet even as this case was especially challenging, many midsized and larger businesses have sophisticated data-transfer needs requiring deep knowledge of the Salesforce platform.
Companies that prefer these two best-of-breed solutions, but need them to work seamlessly together, must carefully consider how to integrate them so data is exchanged automatically, and without error.
The SuiteTalk API exposes NetSuite’s web services, allowing developers to build the integration entirely on the Salesforce side.