max(formulatext: NS_CONCAT({custrecord_parent_rec_id.isinactive})) doesnotcontain 'T'
This NetSuite formula retrieves the highest parent record ID while ensuring that the results do not include records where the `isinactive` checkbox is set to `TRUE`.
1. `NS_CONCAT(…)` aggregates multiple parent record IDs into a single text string.
2. `max(formulatext: …)` extracts the highest ID from that concatenated set.
3. `doesnotcontain TRUE` ensures that any parent record marked as inactive (`isinactive = TRUE`) is excluded from the final result.
This formula is valuable for filtering out inactive parent records, improving saved search efficiency, and ensuring only active records appear in reports.