This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

Hi everyone, I have a question regarding a Vendor Bill Saved Search. My client wants to display the vendor name (entity) in the saved search results for both debit and credit lines. Currently, the vendor name is shown only for the credit line GL impact, and it is empty for the debit line.

Is it possible to achieve this by using a formula field? I have tried a few formulas, but none of them have worked so far. Any suggestions on how to add the vendor name for the debit lines as well?

Thanks in advance!

Sorry to clarify: you don't need a formula field, just replace where you have Name with the field Main Line Name that's in the drop-down on the Results tab

best option is to use vendor join - vendor&gt;name