Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
saved search with column under results tab to show value from available filter selected by user
Hi,
I am trying to see the filtered value of a saved search in a column under Results. Is there a way to achieve it by formula?
Example: From the attached screen shot, if the Available Filter: End Date is selected by user as 31st May 2022, I want to see the same as a column under Results when the search runs.
Adding the Accounting Period : End Date field in the Results tab will only give the end date of the particular document or transaction.
You can see in below screen shot that I have selected the filter value for end date as 31st May but the end date shown in Results tab is different which is same as 'Period' ie., the month/period in which the document or transaction is recorded.
Tagged:
0