way to show parent project and child project in two separate columns in transaction saved search

AI generated answer (using internal Slack threads):

To show parent project and child project in two separate columns in a transaction saved search, you can use the 'Main Line' criteria and 'Formula (Text)' fields in NetSuite. Here are the steps: 1. Create a new Transaction Saved Search. 2. In the Criteria tab, add 'Main Line' is 'F' to only show line level information. 3. In the Results tab, add the fields you want to display. To show the parent and child projects separately, you can use a Formula (Text) field. 4. For the parent project, use a formula like this:

CASE WHEN {parent.custentity_project} IS NOT NULL THEN {parent.custentity_project} ELSE {custentity_project} END

. This will display the parent project if it exists, otherwise it will display the current project. 5. For the child project, use a formula like this:

CASE WHEN {parent.custentity_project} IS NOT NULL THEN {custentity_project} END

. This will display the child project only if a parent project exists. Please note that you might need to adjust the field names in the formulas according to your custom fields and record types. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******