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

  • Author
    Posts
  • #23001

    toddk

    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

    markluu

    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

    toddk

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

  • #23004

    markluu

    Good news!

    Cheers

You must be logged in to reply to this topic.