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

[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

[toddk]

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

[markluu]

Good news!

Cheers

[Author]

Posts