I have an import to NetSuite to create Item Fulfillments. In the mapping I am looking up the created from Sales Order with this dynamic lookup - ["otherrefnum","is","{{{CustOrdNbr}}}"]. The error I'm getting is:
"A mapping error occurred. More than one match for \"[\"otherrefnum\",\"is\",\"5266520146\"]\" for the record type \"Sales Order\"."
I have verified via saved search in NetSuite that there is only one Sales Order with that 'otherrefnum'. What else could be causing this error message?
Hi Cory,
It's possible that you have inactive records with the same "otherrefnum" (usually PO# on a sales order), or that you have a multi-subsidiary NetSuite and the flow was checking all subsidiaries, where the UI search was not.
There is only one subsidiary. The saved search that I ran to find all records with that number would have come back with all records regardless of status. Also, I am not aware of an 'Inactive' option on transactions. They only have status.
Ah, ok. I just noticed something else -- otherrefnum is an integer field, so you have to use "equalto" instead of "is" in the filter.
I am experiencing the same issue; verified there is only one result via Saved Search but the lookup is reporting more than one.
A mapping error occurred. More than one match for "["custrecord_41_tracked_container","is","TCNU8264411"]" for the record type "customrecord_shipment".
// final search.filterExpression: [["custrecord_41_tracked_container","is","TCNU8264411"]]
var lookupResults = search.run().getRange({"start":0,"end":10});
// lookupResults.length: 10
Celigo Admin, have you tried the approach provided by Orion Abrams of using "equalto" instead of "is" in the filter. Please let us know if you have tried this approach and still facing the same issue.
Just adding that this is still an issue. There is something amiss in the way that field specifically interacts with lookups.
@tylerbarrick would you like to share details of your issue?
Hi, someone found what's causing this message error? I'm just tried with "IS", "EQUALTO", "ANYOF" and any of them is working.
Best regards
@arturoduranmoreno if you are going to a transaction record, you may need to add a main line = T filter to your criteria. You should be able to make this search in the UI of NetSuite to confirm that you actually get multiple results when using only that container criteria.
Can someone suggest solution for this issue?
I also experience the same issue for credit memo lookup.
A mapping error occurred. More than one match for "["otherrefnum","is","DML54231"]" for the record type "creditmemo".
Hi @tylerlamparter I have tried with main line = T criteria still the same error. In NetSuite UI search there is only one result.
@aishwaryamj maybe also try isinactive = F?
@tylerlamparter There is no “inactive” filter in the transaction search.
@aishwaryamj is this for a lookup, import with “how to find existing record”, or on a mapping step? I'm trying to recreate.
Hi @tylerlamparter
I'm doing a Dynamic: NetSuite search lookup in the Mapping step.
Thanks
@aishwaryamj if you run the same criteria in NS itself on a saved search, do you get 1 result?
@tylerlamparter Yes, in NetSuite saved search there is only 1 result.
Hi Cory,
It's possible that you have inactive records with the same "otherrefnum" (usually PO# on a sales order), or that you have a multi-subsidiary NetSuite and the flow was checking all subsidiaries, where the UI search was not.
There is only one subsidiary. The saved search that I ran to find all records with that number would have come back with all records regardless of status. Also, I am not aware of an 'Inactive' option on transactions. They only have status.
Ah, ok. I just noticed something else -- otherrefnum is an integer field, so you have to use "equalto" instead of "is" in the filter.
