#C29J1BPM3 Is it possible to display custom status that a vendor bill has bill payment and bill credit in NetSuite saved search? Example: If Bill has one bill credit and one bill payment, the standard status is paid in full, But we need the custom status should be “Credited and Paid” saved search and also in the search results it should only display only line details instead of two lines one if bill payment and another for bill credit. Can any one please help on this? Thanks in advance.

the native Status are not able to be modified. Yu could create your own "Status" field and display that in a custom field.

Thank you for your response. I attempted to use a Formula (Text) field to display a custom status in the search results. While it partially resolves the issue, I noticed that: • The bill details are displayed in two lines in the saved search results due to NetSuite's standard behaviour. • My requirement is that if a single Vendor Bill is associated with both a Bill Payment and a Bill Credit, the search should display the status as "Credited and Paid" in a single line. Currently, the standard behaviour splits the bill details into two lines, and the status does not consolidate as "Credited and Paid." Could you please suggest any alternative solution or workaround to achieve this functionality?

You wont be able to do it with a Formula inside a custom field, you will need a summary search that looks at the applying transactions and have that search setting the field's value.

To resolve the "two lines" issue, you could add the criteria Main Line = Yes. Or, if you actually need both those lines for reporting, but only want to return one line in your final output, perhaps summarizing them by grouping the results by Document Number. I'd wait to summarize until you have pinned down the record data you want, though. On the second piece... that sounds like it might be achievable using a CASE statement in a Formula (Text) field.