Navigate to Netsuite Dashboard
Click "Reports"
Expand "Saved search"
Click "NEW"
Click "Transaction" in the list
Under "Filter" section, Add the following criteria
Select "Type" in the first column
Click on the next column to open a popup
Select "any of Invoice"
Click on "Set" button
Add a new criteria item "Main Line"
Click on the second column next to "Mainline". Set this criteria as "Yes"
Add a third row to filter table
Select "Days Overdue" in the first column
Click on the second column to set the value "Greater than or equal to" "10" as shown
Click on the fourth row and add the next filter
Click "Amount Remaining" from the list
Set "Amount remaining" field as "greater than" 0
Go to "Results" sub-tab
Remove fields you do not want in the email from the list
For eg: Click on "Tax Period" > Click "Remove"
Ensure the fields "Document Number", "Amount", "Date" etc are present
Next click on "Email" sub-tab
Enable "Send emails according to schedule", "Summarise emails"
Uncheck "Send if no results"
Click "Customize Message"
Click a subject text as well as introduction text
Click "Send as CSV" button to ensure that outstanding invoice list is attached as CSV
Uncheck "Include view Record Link"
Click "Schedule"
Select "Weekly Event" to send invoices once every week
Provide a new name to the automation for eg: "Send invoice overdue by 10 days"
Click "Save"