Mutiple matches Found for the Lookup

[aishwaryamj]

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

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

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.

[tylerlamparter]

@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.