How to Send Dunning Emails via NetSuite’s Mass Update Function

08/04/2025

If you’re tired of manually chasing down customers with overdue invoices, NetSuite’s Mass Update feature gives you a scalable way to automate your dunning process - complete with PDF invoice attachments. Here’s how to set it up in a few steps.

Use Case:

You want to automatically email overdue invoice reminders to customers once an invoice hits 7+ days past due.

Prerequisites

Before you begin:

  • PDF Invoice Template: Make sure your invoice PDF is ready and assigned.
  • Set Email Attachment Format: Go to Set Preferences > Transactions > Email Attachment Format and select PDF.

Step 1: Create a Mass Update for Bulk Emailing

Start by creating a Bulk Email Mass Update to automate sending dunning emails for overdue invoices.

NetSuite Mass Updates list with the Bulk Email option highlighted under Transactions

Step 2: Set Search Criteria

Under Search Criteria, set filters to identify the invoices you want to email:

  • Status: Open
  • Days Overdue: Greater than 7

You can add additional filters (like Customer Group or Territory) depending on your business rules.

Invoice Dunning mass update criteria filtering open invoices 7 or more days overdue

Tip: Add relevant fields to your results view - this helps when sending emails manually using the preview.

Mass update Results tab with document number, amount remaining, status and days overdue columns

Step 3: Schedule the Mass Update

  • Define the Start Date and (optionally) an End Date
  • Choose how often you want the update to run (daily, weekly, etc.)
  • Check “Run Update According to Schedule”

Only the Mass Update owner can schedule it. To assign scheduling rights, transfer ownership if needed.

Mass update Schedule tab set to run weekly every Monday with no end date

Step 4: Set Email Recipients

The system sends emails based on this order of priority:

  1. Transaction Email
  2. Customer Email
  3. Contact Email

Leave the 2nd and 3rd fields blank if you don’t want those used.

Mass update Recipients tab with Transaction Email set as the first email address

Step 5: Compose the Email

  • Set your Subject Line and Email Body
  • The invoice PDF will be auto-attached based on your earlier settings
  • Save the Mass Update to finalize

Mass update Message tab with the subject Reminder: Overdue Invoice - Action Required

Dunning email body template reminding the customer that an invoice is 7 days overdue

Optional: Manually Send Emails from the Mass Update List

Prefer to control things manually? Here’s how:

1. Go to your Saved Mass Update List

Saved Mass Updates list showing the Invoice Dunning update scheduled every Monday

2. Click Preview to view matching invoices

Saved Mass Updates list with the Preview link highlighted for the Invoice Dunning update

3. Adjust filters as needed

Mass Update Preview Results listing overdue invoices with the total count highlighted

4. Click Perform Update to send emails

Mass Update Preview Results with the Perform Update button highlighted to send dunning emails

Once you click “Perform Update,” there’s no cancel or undo. The process will begin immediately.

Mass Update In Progress confirmation screen for the Invoice Dunning update

NetSuite’s Mass Update feature is a powerful way to streamline your A/R follow-up. Just be sure your email content is clear and professional, and that your PDF invoice template is configured before launching.

Talk to a NetSuite Expert

Tell us what you're working on, and we'll help you figure out the next step.