Displaying Created Date in Standard Transaction Records in NetSuite

Even though the created date is readily available for custom records, it is not readily available in standard transaction records. This can be solved by creating a saved search and a custom Transaction body field to display the “Date Created” information for standard transaction records in NetSuite.

Step 1: Create a Saved Search

1. Navigate to Lists > Search > Saved Searches > New.
2. Choose the Record Type as “Transaction” and check the “Public” checkbox to make it available to all users.
3. Under the Criteria tab, click on “FILTER” and select “Type” and set the “DESCRIPTION” to “is any of” and select “Sales Order,” “Invoice,” and “Quote”.
4. Switch to the Results tab, and in the Columns section, select “Date Created” and set the summary type to “Maximum.”
5. Now, click on the “Sort” dropdown and choose “Date Created.”
6. Under the Available Filters, select “Internal ID.”
7. Finally, click “Save” to save the search with an appropriate name.

Step 2: Create a Custom Transaction Body Field

1. Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New.
2. Set the Label as “Date Created” and choose the Type as “Date/Time.”
3. Uncheck the “Store Value” checkbox since we are not storing the date but displaying it from the saved search.
4. Go to the Display subtab, and for the Field Type, select “Disabled” to prevent users from editing the field manually.
5. Move to the Validation & Defaulting subtab and choose the saved search created earlier from the “Search” dropdown.
6. Save the custom transaction body field.