This topic contains 3 replies, has 0 voices, and was last updated by markluu 7 years, 10 months ago.

  • Author
    Posts
  • #23001 Score: 0

    toddk
    • Contributions: 0
    • Level 1

    Is it possible to access the vendor record from the transaction search?

    I am trying to write a saved search that will display invoice lines for which the "Preferred Vendor" on the invoice line item has a checkbox on the vendor record set to "Yes".

    When I run it now, I get no results, even though some of the items have a preferred vendor with the flag set to "Yes".

    Each of our item only has 1 preferred vendor.

    Thanks in advance for any help.

    Todd
    This is a cached copy. Click here to see the original post.

  • #23002 Score: 0

    markluu
    • Contributions: 0
    • Level 1

    Hi Todd,

    It seems like what you are trying to do is a 2 level joins, which is not supported by Netsuite. I am assuming you are starting from a transaction search. You would then join on the item and then onto the vendor record.

    Depending on the what you need, you could try to see if you can start from an Item search, and join it to the transaction and vendor

  • #23003 Score: 0

    toddk
    • Contributions: 0
    • Level 1

    Thanks markluu, that did work. I was a little surprised, but it does seem to work fine.

  • #23004 Score: 0

    markluu
    • Contributions: 0
    • Level 1

    Good news!

    Cheers

You must be logged in to reply to this topic.