When Journal Entries (JEs) are automatically created by an integrated purchasing system, the line-level memos are populated, but the header memo field remains blank. Since NetSuite’s Bank Data Matching tool displays only the header memo, this creates visibility issues for reconciliation.
Solution:
NetSuite doesn’t provide a native way to roll up line memos into the header memo field, but you can implement a workaround using:
- A custom non-stored field on the Journal Entry header
- A Saved Search to extract and concatenate line memos
- A Scheduled Workflow to copy that value into the standard header Memo field
Step 1: Create a Custom Transaction Body Field
- Navigate to:
Customization > Lists, Records & Fields > Transaction Body Fields - Create a new field:
- Label: e.g., "Combined Line Memo"
- Type: Free-Form Text
- Store Value: Unchecked (non-stored)
- Under Applies To, select Journal Entry.
- Save the field.
Step 2: Create a Saved Search to Pull Line-Level Memos
- Go to:
Reports > Saved Searches > Transaction Saved Search > New - Set filters:
- Type is Journal Entry
- Add any filters needed to narrow to specific records
- On the Results tab:
- Group by Internal ID (or Document Number)
- Use a Formula(Text) field to concatenate line-level memos (or use
MAX({memo})
- Expose the result using the field you created in Step 1.
Step 3: Create a Scheduled Workflow
- Go to:
Customization > Workflow > Workflows > New - Set the base record type to Journal Entry.
- Set trigger to Scheduled and define the schedule.
- Add a Set Field Value action:
- Field: Memo (native field)
- Value: From field you created in step 1.
- Save and run the workflow.
Now, the header memo will automatically reflect the concatenated line-level memos—giving you the visibility needed for reporting, even for journal entries generated through integration.