Sync NetSuite Transaction Financials to Salesforce Financials

Gogula R Bhavana
  • Updated

The financial flows provide a 360-degree view of the Salesforce lead-to-cash lifecycle. This flow syncs financial information from NetSuite to Salesforce each time a Sales Order goes through the stages of approvals, fulfillment, and billing – thus generating invoices, credit memos, payments, customer deposits, refunds, and so on.

This flow brings in invoice PDFs for the sales team with the updated information from NetSuite with regards to the invoice, credit memo, customer payments, and customer financials.

NetSuite Transaction Financials to Salesforce Financials

NetSuite Transaction Financials to Salesforce Financials is a scheduled flow that syncs NetSuite Transaction Records from NetSuite to the NetSuite Financials custom object in Salesforce. The various types of transactions include

  • Invoice
  • Customer Payment
  • Customer Deposit
  • Customer Refund
  • Cash Sale
  • Cash Refund
  • Credit Memo

The object contains details of each transaction and you can distinguish each transaction using the Type column.

Financials_SF.png

Customize NetSuite Transaction Financials to Salesforce Financials

The NetSuite Transaction Financials to Salesforce Financials flow uses the Celigo Salesforce(IO) NetSuite Financial Export [Locked] saved search present under Settings > Financial > NetSuite saved search for syncing Transaction Financials to fetch records based on the criteria shown in the following image.

NetSuite_Financials_Export.png

To customize the saved search

    1. In NetSuite, in the global search bar, enter Celigo Salesforce(IO) NetSuite Financial Export and press Enter.
    2. In the results that are displayed, find Celigo Salesforce(IO) NetSuite Financial Export [Locked].
    3. Click the View link corresponding to Celigo Salesforce(IO) NetSuite Financial Export [Locked].
    4. Click Edit this Search.
    5. Under the Criteria tab, add the desired criteria.
    6. In the SEARCH TITLE text box, enter a meaningful name for your choice.
    7. Click Save As.

A custom copy of the NetSuite saved search is created with the name you entered.

Sync NetSuite Transaction Financials to Salesforce Financials

    1. In the integration tile, go to Flows > Financial
    2. Turn on the NetSuite Transaction Financials to Salesforce Financials flow using the toggle button.
    3. In your NetSuite account, go to any of the Transaction Records (Cash Sale, Cash Refund, Credit Memo, Customer Payment, Customer Refund, and Invoice).
    4. Perform updates to the desired Transaction Record and Save.

The default mappings for Post Financials to Salesforce are shown below:

2021-10-20_17-35-45.png

If everything is configured correctly, the details you updated in the Transaction Record will automatically be synced to the Netsuite Financials object in Salesforce.

Note: To link PDFs to a Salesforce Object without errors, navigate to Settings > Financial. Under the Sync transaction types to Salesforce setting, select the appropriate transaction type. Then, in the Sync transaction files to Salesforce setting, select the corresponding transaction type.

Related articles

Comments

3 comments

Date Votes
  • Dom Jackson
    • Edited

    This doesn't explain how to show the PDF file in the screenshot for the Netsuite Financials in Salesforce to show in the line. The pdf file does not auto link with the current set up. How do I link the invoice lines to the pdf file in salesforce?

    0
  • Saikumar Rachamalla Docs Team Lead Principal Technical Writer

    Dom Jackson, we acknowledge your request and will provide you with an update shortly. Thanks!

    0
  • Saikumar Rachamalla Docs Team Lead Principal Technical Writer

    Dom Jackson To sync attachments, please enable the 'Sync transaction files to Salesforce' setting. Thank you for bringing this to our attention—we'll update the document soon with the necessary steps and screenshots.
     

    0

Please sign in to leave a comment.