NetSuite Invoice Sync to Salesforce Financial Record
An invoice transaction in NetSuite creates a bill for goods, services (or both) sold to a customer when payment is not received at the time of delivery. The invoice indicates terms of payment that specify payment is to be received. Each invoice consists of multiple line items with corresponding sales amounts that add up to the total amount of the invoice. Companies that bill costs back to customers can identify billable costs, mark them up, and add them to invoices.
About the Invoice Sync
NetSuite is the source of truth for all information related to invoices. The Invoice sync sends invoice information from NetSuite to Salesforce. This sync updates financial records in Salesforce with changes made in NetSuite to invoices. The invoice-related information in Salesforce is only for reference. Any the Financial records in Salesforce are read-only.
The Invoice sync is triggered when the following conditions are met:
-
If a Sales Order is generated in NetSuite when the Opportunity sync is invoiced, the NetSuite Invoice record is synced to Salesforce as a read-only custom Financial record of the type Invoice.
Note:Invoice records created in NetSuite for Sales Orders which did not originate in Salesforce as a Closed Won Opportunity are not synced back to Salesforce.
-
If an Invoice that was previously synced to Salesforce is updated, those updates will trigger a sync to update the corresponding Salesforce Financial record of type Invoice.
For successful Invoice syncs, you will see Operation Succeeded in NetSuite. In addition, custom fields in the NetSuite Invoice object, the Salesforce Invoice ID will have a Salesforce Financial Id, and the sync status will be Completed.
The following tables show the mapping between NetSuite Invoice fields and Salesforce Financial fields to ensure that identical data is maintained in both applications.
Invoice Fields Mapping
|
NetSuite Invoice Fields |
Salesforce Financial Fields |
|---|---|
|
account |
Oracle_account__c |
|
balance |
Oracle_Balance Due__c |
|
createdfrom |
CreatedById |
|
Customer |
OwnerId |
|
discounttotal |
Oracle_discount_total__c |
|
duedate |
Oracle_due_date__c |
|
handlingcost |
Oracle_handling_total__c |
|
memo |
Oracle_memo__c |
|
shippingcost |
Oracle_shipping_total__c |
|
status |
Oracle_transaction_status__c |
|
subtotal |
Oracle_subtotal__c |
|
terms |
Oracle_terms__c |
|
total |
Oracle_total__c |
|
trandate |
Oracle_transaction_date__c |
|
tranid |
Oracle_transaction_Id__c |
Lookups Invoice Fields Mapping
|
NetSuite Invoice Fields |
Salesforce Financial Fields |
|---|---|
|
currency |
CurrencyIsoCode |