NetSuite Sale Order lookup is returning incorrect error message - A mapping error occurred. More than one match for \"[\"otherrefnum\"

Comments

9 comments

  • Orion Abrams Technical Implementation Consultant

    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. 

    0
  • Cory Anderson
    Answer Pro
    Great Answer
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    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. 

    0
  • Orion Abrams Technical Implementation Consultant

    Ah, ok. I just noticed something else -- otherrefnum is an integer field, so you have to use "equalto" instead of "is" in the filter.

    2
  • Celigo Admin

    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

    1
  • Balasubramanian Mahadevan Community manager Senior Technical Writer
    Engaged
    Celigo University Level 2: Seasoned

    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.

    0
  • Tyler Barrick

    Just adding that this is still an issue. There is something amiss in the way that field specifically interacts with lookups.

    0
  • Anitha Abraham Community moderator Principal Technical Writer
    Celigo University Level 3: Master

    Tyler Barrick would you like to share details of your issue?

    0
  • ARTURO DURAN MORENO
    Engaged
    Celigo University Level 4: Legendary

    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

    0
  • Tyler Lamparter Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    ARTURO DURAN MORENO 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.

    0

Please sign in to leave a comment.