Dunning System
The Dunning System feature manages the generating and distributing of periodic reminders for unpaid invoices.
This helps streamline the credit management process and reduce the risk of incurring bad debts. Once configured, the process can be automated to routinely send out payment notifications.
Exploring

The programs related to this feature are accessed from the Program List pane of the SYSPRO menu:
- Program List > Accounts Receivable


A dunning group is a category into which you can group customers. Dunning letters are issued to all customers in the selected dunning group.

A dunning letter is a notification letter or a payment reminder that is sent to customers when payment is due or overdue.

The dunning status is linked to a dunning group and the invoices within that group. It contains the specifications and format of the dunning letter that will be generated.
Starting

You can secure this feature by implementing a range of controls against the affected programs. Although not all these controls are applicable to each feature, they include the following:
- You can restrict operator access to activities within a program (configured using the Operator Maintenance program).
- You can restrict operator access to the fields within a program (configured using the Operator Maintenance program).
- You can restrict operator access to functions within a program using passwords (configured using the Password Definition program). When defined, the password must be entered before you can access the function.
- You can restrict access to the eSignature transactions within a program at operator, group, role or company level (configured using the eSignature Setup program). Electronic Signatures provide security access, transaction logging and event triggering that gives you greater control over your system changes.
- You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).
- You can restrict operator access to programs by assigning them to roles and applying access control against the role (configured using the Role Management program).

-
Historical invoices (i.e. invoices created before implementation of the Dunning system) are not automatically included in the Dunning run, even if the customer has been categorized into a Dunning group.
Historical invoices must be added to the Dunning run manually using the AR Dunning Group for Invoices program.
-
If no Dunning fax or Dunning email is specified in the Customers program, a warning message is displayed and the Dunning letter is not sent to the customer.
-
No letters are generated if you selected to generate a single dunning letter per customer (i.e. you selected Customers at the Option field of the AR Dunning System program) and the customer's invoices are categorized in different dunning groups.
Solving


- Open the Dunning Group Maintenance program.
-
When adding a new dunning group, enter an alphanumeric code at the Dunning group field.
When maintaining an existing dunning group, search for and select the code at the Dunning group field.
- Capture or maintain the description for the dunning group.
- Save your changes.

- Open the AR Dunning Statuses program.
- At the Dunning group field, search for and select the dunning group.
-
When adding a new status, enter a numeric code for the dunning status at the Dunning status field.
When maintaining an existing status, search for and select the status at the Dunning status field.
- Capture or maintain the status details.
- Save your changes.

- Open the Customers program.
- Locate the required customer.
- Enter and or select the following detail in the Dunning section at the General Details pane:
- Dunning group into which you want to categorize the customer.
- Dunning fax to which the dunning letter will be faxed.
- Dunning e-mail to which the dunning letter will be emailed.
- Save your changes.

- Open the AR Dunning Group for Invoices program.
- In the Criteria section, select the customer(s) who have invoices you want to link to a dunning group.
-
Click Start Processing.
The customers are listed in the Report pane.
-
Expand the customer to display all unpaid invoices.
The invoices are now included in the dunning group into which the customer has been categorized.

- Open the AR Dunning Group for Invoices program.
- Select the customer in the Criteria pane.
-
Select Start Processing.
If invoices were updated, the customer will be displayed in the Report pane.
The current and previous dunning groups are displayed.
- Select the customer to display a list of invoices.

- Open the AR Dunning System program.
- Use the fields on the Selection Criteria pane to indicate which dunning letters you want to generate.
-
Select Start Review.
The invoices are displayed on the Invoice Review pane, which lists all invoices with the dunning status. These invoices are checked (included) by default.
-
Choose to include or exclude invoices.
Highlight an invoice and select Exclude Invoice to remove it from the dunning run.
To manually add an invoice that is not in the list, select Include Invoice to search for and include an invoice in the dunning run.
-
Choose the invoices and select Print / Send to generate and print or send dunning letters.
The number of letters that were printed or sent are displayed on the Report output pane.
Once the letters are printed or sent, the status on the invoice is updated.

Although you can edit the description of a dunning group, you cannot edit the dunning group code.

Yes, you can delete a dunning group (even if statuses and/or stationery are linked to the group) by using the Delete function of the Dunning Group Maintenance program.

Dunning letters are only sent to the dunning fax and email.
If no Dunning fax or Dunning email is specified in the Customers program, a warning message is displayed and the Dunning letter is not sent to the customer.

You can only include invoices that have a positive balance. Invoices with a zero balance can't be included in the dunning run.

All future invoices will be linked to the new dunning group and all historic invoices will be linked to the previous dunning group (or no dunning group if this is the first time the customer is being placed in a dunning group).
Use the AR Dunning Group for Invoices program to update the dunning group of all historic invoices, or use the AR Invoices for Customer program to update the dunning group on a single invoice.

This may occur in the following instances:
- No dunning group was saved against the invoice. Use the AR Dunning Group for Invoices program to update the dunning group of all historic invoices, or use the AR Invoices for Customer program to update the dunning group on a single invoice.
- No dunning fax or dunning email was specified against the customer. Use the the Customers program to specify this information.
- No dunning status was saved against the invoice.
-
The selected customer's invoices are categorized in different dunning groups and you have selected to generate a single dunning letter per customer containing all outstanding invoices (i.e. you selected Customers at the Option field of the AR Dunning System program).
The dunning system can't generate a single dunning letter if invoices are in different groups. Deselect to exclude invoices that are in a different dunning group and/or generate one letter at a time per dunning group.

-
Open the AR List of Dunning Groups report program (Program List > Accounts Receivable > Reports).
-
Indicate the report criteria you require in the Report Options and Output Options tabs.
-
Select Process.
If you use server-side printing, the report is sent to the report queue before the report is displayed.
If you use client-side printing, the report is displayed immediately.

-
Open the AR Dunning Statuses report program (Program List > Accounts Receivable > Setup).
-
Indicate the report criteria you require in the Report Options and Output Options tabs.
-
Select Process.
If you use server-side printing, the report is sent to the report queue before the report is displayed.
If you use client-side printing, the report is displayed immediately.
Using

The programs related to this feature are accessed from the Program List pane of the SYSPRO menu:
-
Program List > Accounts Receivable
Setting up the Dunning System involves creating Dunning groups, statuses and letter formats (Dunning Group Maintenance, AR Dunning Statuses and AR Dunning Letter Format programs):
- Link customers to Dunning groups.
This ensures dunning letters are created for all new invoices saved against the customer. - Link individual invoices to Dunning groups.
This ensures that a dunning letter is created for that specific invoice. - Link historical unpaid invoices to a Dunning group.
This ensures that dunning letters are generated and distributed for all invoices processed prior to categorizing the customer in a dunning group. - Run the Dunning process to generate letters.
This creates the dunning letters and either faxes or emails them to the customer, or prints them.