# Mutiple matches Found for the Lookup

**URL:** <https://connective.celigo.com/t/mutiple-matches-found-for-the-lookup/168>\
**Category:** Integrator.io\
**Tags:** error-handling, transformation, lookup, salesforce, netsuite\
**Created:** [April 11, 2024, 11:54am UTC](https://connective.celigo.com/t/mutiple-matches-found-for-the-lookup/168 "2024-04-11T11:54:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aishwaryamj](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@aishwaryamj](https://connective.celigo.com/u/aishwaryamj)\
**Post date:** [April 11, 2024, 11:54am UTC](https://connective.celigo.com/t/mutiple-matches-found-for-the-lookup/168/1 "2024-04-11T11:54:54Z")

</div>

I am doing a sync between NetSuite Payment Record and Sales Force Invoice Record. I am finding the existing record by the Invoice Number.

 ![5301043caa20740200000001-c5af25556b1245baae8a8615bce9ac52.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/ccf6b4f593ebcffd159524b4fba6bab42b1d0b28.png)

The apply. refnum is taken from the below field from payments.

 ![5301043caa20740200000001-9a30eff4ad9043bdaee9871384604ff1.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/5240c19da73d410777f478def10ffd3b12c2da18.png)

There is only one invoice existing in the Sales Force Account with the same name. I have used transformation in export to include only the included payments line to import.

But, still i am getting the error.

 ![5301043caa20740200000001-339306a5d8d546248f09445b3b77e5bf.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3e0805ecadf8aa0692fbf78680998d680bc78ee6.png)

---

<div class="post-metadata">

**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\
**Post date:** [April 25, 2024, 1:04am UTC](https://connective.celigo.com/t/mutiple-matches-found-for-the-lookup/168/2 "2024-04-25T01:04:54Z")

</div>

@aishwaryamj you probably need to use an absolute path for your "how to find existing records" criteria. As in:

```
apply.0.refnum
```

This of course assumes you only ever have one payment. If that's not the case, you would need to use one-to-many path set to "apply" and then this would run per payment object in the apply array.