# NetSuite Customers - Salesforce Accounts (Mapping 'Sales Rep' in NS to 'Account Owner' in Salesforce)

**URL:** https://connective.celigo.com/t/netsuite-customers-salesforce-accounts-mapping-sales-rep-in-ns-to-account-owner-in-salesforce/644
**Category:** Integration Apps
**Tags:** filter, lookup, salesforce, netsuite
**Created:** [September 16, 2022, 4:01pm UTC](https://connective.celigo.com/t/netsuite-customers-salesforce-accounts-mapping-sales-rep-in-ns-to-account-owner-in-salesforce/644 "2022-09-16T16:01:49Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![itadmin](https://avatars.discourse-cdn.com/v4/letter/i/97f17d/32.png) [@itadmin](https://connective.celigo.com/u/itadmin)
#### Post date: [September 16, 2022, 4:01pm UTC](https://connective.celigo.com/t/netsuite-customers-salesforce-accounts-mapping-sales-rep-in-ns-to-account-owner-in-salesforce/644/1 "2022-09-16T16:01:49Z")

</div>

I thought I would take a moment to share a solution for an issue I was facing for the past week. I was trying to find a way to map the Sales Rep's name in NetSuite, to the Account Owner field on an account record in Salesforce.

After lots of trial and error I finally found the solution.

The mapping for this needs to be set as a lookup, taking 'Sales Rep' from the NetSuite side (Source Record) and populating this to 'Owner ID' on the Salesforce side (Destination Record Side)

 ![5301043caa20740200000001-a3ec0a0c8de7480ea51f082135f64150.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b3c99e60958c9d8b892971d22668c751947bdbe2.png)

The settings mapping should be set up as follows - ' **Field Mapping Type**' : **Lookup** --- ' **Dynamic Salesforce Search'** ---- ' **sObject Type**' : **User** ---- **Add Filter** : **Full Name** = **Sales Rep** ----- ' **Value Field**' : **User ID**

 ![5301043caa20740200000001-b0445a05d9f44d3c8430c73f541a0d07.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/20e8cbc0f07acb19077d2d1c7d962e73de63ddea.png)

 

 ![5301043caa20740200000001-2c1af9515dbb4d008cda85e48f4ad345.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/efd0919b31ee891457a4b3dc8c8fdfa30111b952.png)

 

Follow these steps and you can easily set the 'Account Owner' field for new/existing accounts in Salesforce as the 'Sales Rep' information in NetSuite!

---

<div class="post-metadata">

### Author: ![anithaabraham](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/anithaabraham/32/6964_2.png) [@anithaabraham](https://connective.celigo.com/u/anithaabraham)
#### Post date: [January 12, 2023, 7:23am UTC](https://connective.celigo.com/t/netsuite-customers-salesforce-accounts-mapping-sales-rep-in-ns-to-account-owner-in-salesforce/644/2 "2023-01-12T07:23:20Z")

</div>

[IT Admin](http://itadmin@echonous.com), thanks a lot for sharing your solution! It will really help others who run into the same mapping issue.