Automatic Payment Reminders

How to configure and run reminders for unpaid invoices, including through the Job Queue.

⚙️ Configuring automatic reminders

Step 1: Setting up the date formula

In settings, set the Notification Date Formula field in Step 3: Automatic e-mail sending. The formula calculates a cutoff date relative to the day the process runs. Reminders include invoices due on or before that date:

  • Negative values move the cutoff date back. With -3D, reminders include invoices that were due at least three days ago.
  • Positive values move the cutoff date forward. With +1D, reminders include invoices due through tomorrow.
  • Zero (0D) sets the cutoff date to today. Reminders include invoices due through today.

Formula examples

Formula Description Example
-7D Due at least 7 days ago Run on Jan 15: due Jan 8 or earlier
-3D Due at least 3 days ago Run on Jan 16: due Jan 13 or earlier
0D Due through today Run on Jan 15: due Jan 15 or earlier
+3D Due within the next 3 days or earlier Run on Jan 15: due Jan 18 or earlier
+1W Due within the next week or earlier Run on Jan 15: due Jan 22 or earlier

Step 2: Customer filter configuration (optional)

In the "Customer Filter for Notifications" field, you can specify which customers should receive automatic reminders:

  1. Click the "..." button next to the field
  2. Set filtering criteria (e.g., posting groups, country codes)
  3. If the field remains empty, all customers with unpaid invoices will be included

Filter examples

  • Customer Posting Group: DOMESTIC - only domestic customers
  • Country/Region Code: US - only customers from US
  • Customer Price Group: RETAIL - only retail customers

🚀 Running automatic reminders

Method 1: Manual execution

  1. Navigate to ⚙️ PR | Start Here! page
  2. In "Step 3" section, click "Run Automatic Payment Reminders" button
  3. Confirm that you want to send reminders
  4. System will process all appropriate invoices

Method 2: Automatic execution

Configure a Job Queue entry to automatically run reminders:

  1. Go to Job Queue Entries
  2. Create a new entry with following settings:
    • Object Type: Codeunit
    • Object ID: 71610483 (N24PR Mass Email Notification)
    • Recurrence: set according to needs (e.g., daily)

🔍 Automatic processing logic

The system automatically:

  1. Finds appropriate invoices:

    • Open invoices with remaining amount > 0
    • Invoices for which no reminder has been sent yet
    • Invoices due on or before the date calculated from the formula
  2. Filters customers:

    • Checks if customer has email address set
    • Verifies if customer meets filter criteria
    • Skips customers without complete data
  3. Groups and sends:

    • Groups invoices by customers
    • Creates one email per customer with all qualifying invoices
    • Records information about sent notification

✅ Benefits of automatic reminders

✅ Time saving - No need to manually select entries
✅ Consistency - Reminders sent according to established policy
✅ Completeness - System finds all appropriate invoices automatically
✅ Flexibility - Ability to customize formulas and filters
✅ Automation - Can be run through Job Queue

⚠️ Important notes

Warning
  • If the date formula is empty, automatic reminders will not be sent
  • System sends only one reminder per invoice - no automatic repetitions
  • Ensure email scenario is properly configured before running

Check the setup before scheduling a recurring job.

Tip
  • Test settings on a small group of customers before full deployment
  • Regularly check Job Queue logs to ensure automatic execution works correctly or consider using Advanced Queues solution

📈 Monitoring and tracking

After sending automatic reminders:

  • Check the "Last Reminder Sent" field in customer ledger entries to see processed invoices

📋 Examples and scenarios

Configuration example: Mass notifications with -3D

Configuration:

  1. On the start page, assign an email account to N24PR🔹Unpaid Invoices Reminder and prepare an email template.
  2. In Step 3: Automatic e-mail sending, enter -3D in Notification Date Formula. Select recipients with Customer Filter for Notifications, or leave it empty to include all eligible customers.
  3. Run Run Automatic Payment Reminders on the start page, or create a recurring entry in Job Queue Entries with object type Codeunit and object ID 71610483 (N24PR Mass Email Notification), for example, to run daily.

Result: When the process runs on January 16, the cutoff date is January 13. It selects open invoices with a remaining amount greater than zero, a due date on or before January 13, and no reminder previously sent, for customers with an email address who match the filter. It sends one email per customer with their qualifying invoices. The customer's address is used as the To recipient; configured CC and BCC addresses are added to their respective fields. If email preview is enabled, send the message from the editor. After a successful send, the reminder date is recorded on the selected entries.