# Lookup for NetSuite Sales Rep

**URL:** https://connective.celigo.com/t/lookup-for-netsuite-sales-rep/1426
**Category:** Integration Apps
**Tags:** filter, lookup, salesforce, netsuite
**Created:** [July 16, 2020, 3:07pm UTC](https://connective.celigo.com/t/lookup-for-netsuite-sales-rep/1426 "2020-07-16T15:07:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![damonbetlow](https://avatars.discourse-cdn.com/v4/letter/d/ecae2f/32.png) [@damonbetlow](https://connective.celigo.com/u/damonbetlow)
#### Post date: [July 16, 2020, 3:07pm UTC](https://connective.celigo.com/t/lookup-for-netsuite-sales-rep/1426/1 "2020-07-16T15:07:34Z")

</div>

Some sales reps have common names or multiple accounts in Salesforce (ie. Community account). We should be able to filter on Email address or Internal Salesforce accounts...

Email is not an option.

 ![5301043caa20740200000001-f1b38f62c58a41d1828877893ebeb172.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/19560af2f8a26c4ef9f66a3725b511aa00816d7b.png)

 ![5301043caa20740200000001-da4b43caa387478295a16bef63541c00.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/71ac346f6fa6a40b796d87a3100c1b50fb8ae258.png)

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

---

<div class="post-metadata">

### Author: ![damonbetlow](https://avatars.discourse-cdn.com/v4/letter/d/ecae2f/32.png) [@damonbetlow](https://connective.celigo.com/u/damonbetlow)
#### Post date: [July 16, 2020, 3:44pm UTC](https://connective.celigo.com/t/lookup-for-netsuite-sales-rep/1426/2 "2020-07-16T15:44:30Z")

</div>

Athough Celigo wasn't passing the correct values for IsActive and UserType, I was able to modify the filter to use the IsPortalEnabled. Not sure why it was passing null values when I used the Boolean IsActive and Picklist UserType...

 ![5301043caa20740200000001-f27f12b5c5884e1b93a12ba846dbaf83.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/4/422c24110e93ae6747e053a0b5bf1c54eeef28e7.png)

---

<div class="post-metadata">

### Author: ![courtneyjordan](https://avatars.discourse-cdn.com/v4/letter/c/b2d939/32.png) [@courtneyjordan](https://connective.celigo.com/u/courtneyjordan)
#### Post date: [July 16, 2020, 7:48pm UTC](https://connective.celigo.com/t/lookup-for-netsuite-sales-rep/1426/3 "2020-07-16T19:48:26Z")

</div>

Thanks so much for letting us know about this issue and how you were able to fix it, @damonbetlow739! I've let the PM for our SFNSIO integration app know as well.