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:
- Click the "..." button next to the field
- Set filtering criteria (e.g., posting groups, country codes)
- 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
- Navigate to ⚙️ PR | Start Here! page
- In "Step 3" section, click "Run Automatic Payment Reminders" button
- Confirm that you want to send reminders
- System will process all appropriate invoices
Method 2: Automatic execution
Configure a Job Queue entry to automatically run reminders:
- Go to Job Queue Entries
- 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)
- Object Type:
🔍 Automatic processing logic
The system automatically:
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
Filters customers:
- Checks if customer has email address set
- Verifies if customer meets filter criteria
- Skips customers without complete data
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:
- On the start page, assign an email account to N24PR🔹Unpaid Invoices Reminder and prepare an email template.
- In Step 3: Automatic e-mail sending, enter
-3Din Notification Date Formula. Select recipients with Customer Filter for Notifications, or leave it empty to include all eligible customers. - Run Run Automatic Payment Reminders on the start page, or create a recurring entry in Job Queue Entries with object type
Codeunitand object ID71610483(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.