Skip to main content

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

Comments

3 comments

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

    1
  • 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

Please sign in to leave a comment.