Dunning
Dunning is the process of informing customers about the state of their account and collecting money from customers that they owe to the organization.
Dunning is the process of informing customers about the state of their account and collecting money that they owe to the organization. As a process, it generally starts with polite requests, perhaps verbally or a sent statement of account, followed by e-mails and letters that might escalate to legal threats before the account is written off and passed to a collections agent.
An example of a company policy on Dunning might be as follows:
- 1.For invoices over their due date by less than 15 days, a polite phone call to inquire and request payment. No action taken on the Customers's Account.
- 2.For returned checks - enter a negative payment and a new invoice charging a returned check fee. Find the original payment and reset the payment allocation. Allocate/cancel the original payment and the returned check. This will leave the invoice unpaid. Call the customer and politely request payment. No action taken on the Customers's Account.
- 3.For invoices over 30 days, a letter requesting immediate payment. No action taken on the Customers's Account.
- 4.For invoices over 60 days, a letter threatening that the amounts will be passed to a collections agent. The Customers credit is stopped and the payment term applied to new invoices is changed to Immediate.
- 5.For invoices over 90 days, write off the amount owing and pass the invoice to a collections agent. This is a manual process.
ADempiere includes tools to help with the Dunning process making it easy to manage collections for a large number of customers by keeping track of where each customer and invoices sits in the process. The intent is that the Dunning process be "run" on a periodic basis and at each run, invoices move through the process until they are paid or written off. There are two key periodic tasks:
- 1.Generating lists of invoices and payments relevant to the Dunning policy, referred to as a "Dunning Run"; and
- 2.Printing or emailing Dunning letters to the delinquent customers, a process called "Print Dunning Letters."
The Dunning process can be customized for a particular Business Partner or Business Partner Group and each process can have multiple levels or steps that collectively define the Dunning policy of the company. Each level can take a number of actions such as printing letters, sending emails, stopping credit or resetting the payment terms for the Customer. Customer Invoices are flagged as being in the Dunning process and associated with a particular Dunning Level.
The relationship with individual customers can be further managed by setting a Dunning Grace Date in the Business Partner window, Customer tab, which affects all invoices, or in the Invoice (Customer) window, Invoice tab, for a particular invoice. The Customer or Invoice affected will not be included in Dunning processes until after the Dunning Grace Date.
Dunning Setup
To start using Dunning, the dunning policies must be defined and setup according to your needs. Once the setup is complete, Dunning becomes a periodic and repeatable activity of creating Dunning Runs and Printing Dunning Letters.
The Dunning Policy
A Dunning policy definition starts with a Dunning record and one or more Levels. Open the Dunning window in the Partner Relations > Business Partner Rules menu. The Dunning window is relatively simple. You will need to create a new record for each distinct dunning policy or collection of levels you require. The key fields are as follows:
Field
Description
Name
Any useful name. The Name is used to identify the Dunning process to apply to Business Partners and Business Partner Groups.
Default
Indicates the Dunning record is the default Dunning process. It is not currently used.
Create levels sequentially
Select if the actions defined by the Dunning Levels need to be performed in order. For example, if you have several reminders based on the number of days an invoice is due, it might not be a good idea to send all of them at the same time to the same customer. On the other hand, if the Levels can be performed in parallel, then you can deselect this field. Examples of parallel actions might be sending a statement and stopping credit for overdue accounts.
Dunning Levels
The Dunning Level defines the actions that should be taken based on some triggers. To understand how to setup the levels it helps to know how they are used.
The gathering of information on which Business Partner needs to be Dunned is called a "run". When the Dunning process is run, it is run for a particular level or all levels and for a particular date. The date when the Dunning process is run determines the age of the invoices and the number of days after the payment due date for each unpaid invoice. For each level, all the invoices that meet the constraints of the Level are identified. If payments are to be included, these are also identified. Fees, if any are added. All this information is gathered in a Dunning Entry for each Business Partner but nothing is done with the information at this point. You can review the Dunning Entries and the Entry Details (the identified invoices etc..) and verify that all is in order or you can re-run the Dunning process and recreate the Dunning Entry information. If a new run is performed before the previous was processed, the Entries and Entry Details will be duplicated.
Actions are taken when the Dunning Entry is processed. This could include the sending of e-mails or printing of letters and other actions as mentioned below. Once processed, no further changes are allowed and the invoices identified will be in the dunning process. Once processed, if a new run is performed, the Entries and Entry Details will be different depending on the constraints set in the Level.
The Level defines the constraints using the following fields:
Field
Description
Show All Due
If true, the dunning letter with this level includes all due invoices, including invoices that are not due yet. If false, it will only show invoices where the Days after due date is less than the days due of the invoice or within the range of Days From and Days To if Range is selected.
Show Not Due
If true, invoices that are not due yet (based on the Dunning Run date) will be included. If false, only invoices with a positive number of days due will be included (>=0). The field is ignored if Range is selected.
Range
If selected, only invoices with days due that fall between Days From and Days To are considered. Range is only displayed if Show All Due is deselected. __
Days after due date
Indicates the number of days after the payment due date to initiate dunning. If the number is negative, it will include invoices due in the future (not due). Days after due date is only displayed if Range and Show All Due are deselected.
Days between dunning
The Days Between Dunning indicates the minimum number of days between sending dunning notices. Invoices that were dunned more recently than this will be ignored. Days between dunning is only tested if Range and Show Not Due are deselected. See the note below. Days between dunning is only displayed if Range and Show All Due are deselected.
Days From
The inclusive lower limit of the invoice days due to consider. Invoices with days due less than Days From will be ignored. Only relevant if Range is selected.
Days To
The inclusive upper limit of the invoice days due to consider. Invoices with days due more that Days To will be ignored. Only relevant if Range is selected.
Include Payments
If selected, unallocated payments for the Business Partner will be included. If Is Statement is selected, all payments will be included. Otherwise, payments will only be included if there is at least one invoice - this prevents dunning for money you owe to the customer.
Charge fee
Indicates if the dunning letter will include fees for overdue invoices. Note that the fee amount is not automatically added to the customer's account.
Fee Amount
The Fee Amount indicates the charge amount on a dunning letter for overdue invoices. This field will only be display if the Charge Fee checkbox has been selected. Note that the fee amount is not automatically added to the customer's account.
Print Text
A label to be printed on documents or correspondence.
Note
Optional additional information about this record.
Dunning Print Format
The Dunning Print process will generate a PDF of the list of entries associated with this Level and either print it or send it as an attachment to an e-mail. If you do not specify a Dunning Print Format, the PDF will not be generated and the Dunning Run will not be processed.
Credit Stop
Select if the Customer's Credit Status should be set to Credit Stop for any invoices found at this level. This may help prevent further losses.
Set Payment Term
Select if the Customer's Payment Term should be changed, for example from Net 30 to Immediate, if any invoices are found at this level.
Payment Term
The Payment Term to set if Set Payment Term is selected. Payment Term only appears if Set Payment Term is selected.
Collection Status
The Collection Status to set on the affected invoices. If left blank and Is Statement is not selected, the invoice Collection Status will be set to Dunning.
Is Statement
Select if the dunning level is intended as a statement of accounts for the Customer. If selected and Collection Status is blank, then the Collection Status of any affected invoices will not be changed.
For the first Dunning Level, its important to set the Days between dunning to zero since invoices that have not yet been dunned have zero days since the last dunning. If you set Days between dunning > 0 on all Levels, no new invoices will ever be found.
This only applies if you deselect the Show all due and Show not due flags.
Assigning a Dunning Policy to Business Partners
Each Business Partner needs to be associated with a Dunning policy or they will not be included in the Dunning process. The Dunning policy can be set for a Business Partner Group or individual Business Partners. The individual setting takes precedence.
To set the Dunning policy for a whole group, open the Business Partner Group window in the Partner Relations > Business Partner Rules menu. Select the desired Dunning entry in the Dunning field.
To override the Group Dunning policy, set the Dunning field in the Customer tab of the Business Partner window for a particular Business Partner.
Dunning Runs
A Dunning Run is a record of the dunning process. The Dunning Run record identifies the Dunning Date and Dunning policy and Dunning Level that was used. Each affected Business Partner becomes an Entry in the Dunning Run and each invoice, payment and fee becomes a Line of the Entry.
The Dunning Run window can be found in the Open Items menu.
There are two ways to create Dunning Runs:
- 1.Manually, by creating a record in the Dunning Run window with a Dunning Date, Dunning policy, and optionally a Dunning Level; or
- 2.Via a process, Create Dunning Run, which will also create the Entry and Line information.
The Create Dunning Run process is found in the Open Items menu as is the Dunning Run window. The Dunning Run window/tab also includes a button that executes the Create Dunning Run process.
Creating Dunning Runs Manually
Open the Dunning Run window and create a new record. Set the fields accordingly. The key fields are as follows:
Field
Description
Dunning Date
Mandatory. Specifies the date of the Dunning Run. The Dunning Date determines the number of days payments are past their due date for invoices. The Dunning Date defaults to the current system date.
Dunning
Mandatory. The Dunning policy used to create the Entry and Line records.
Dunning Level
The Dunning Level used to create the Entry and Line records. If blank, all Levels of the Dunning policy will be used.
In addition to these three key fields, there is a Button Create Dunning Run **_and a flag Processed. The button process and parameters are described below. When run from the Dunning Run window, the Create Dunning Run_ process will generate the Entry and Line records for the Dunning Run.
The Processed flag is read-only and will be set once the Dunning Run is sent/printed.
There is a button Send in the Dunning Run window that appears when the Processed flag is set. It is not used. See issue #2363.
Creating Dunning Runs via the Process
Dunning Runs can also be created using the Create Dunning Run process found in the Open Items menu. The benefit to using the Create Dunning Run process from the menu is that it will create a number of Dunning Run records at once along with their associated Entry and Line information.
If you run the Create Dunning Run process from the menu, it may duplicate an existing **unprocessed Dunning Run** rather than recreate the Entry and Line records.
Whether run from the menu or from a Dunning Run record, the process is similar. The Create Dunning Run process has a number of parameters that control how the Dunning Run, Entry and Line records are created:
Parameter
Description
Organization
Sets the Organization to use in the Dunning Run. If not All (*), the invoices and payments added to the Entry Lines will be limited to those belonging to the specified Organization.
Include Disputed
If selected, the Lines will include invoices that are marked as In Dispute.
Only Sales Invoices
If selected, only Sales (Customer) Invoices will be included. Otherwise, both Sales and Purchase (Vendor) invoices will be included. This is useful where a Business Partner is both a Customer and Vendor and contra allocations are possible.
Default Sales Rep
The Sales Rep added to the Entry when it is created. The Default Sales Rep is not used to filter the invoices or payments.
Dunning Currency
If Include All Currencies is not selected, only invoices in the selected currency are included in the Lines.
Include All Currencies
Select to include items in all currencies in the Dunning Run.
Business Partner
If not blank, only generate Entries and Lines for the specified Business Partner.
Business Partner Group
If not blank, only generate Entries and Lines for Business Partners in the specified Business Partner Group. Ignored if Business Partner is not blank.
Dunning Date
Specifies the date of the Dunning Run. The Dunning Date determines the number of days payments are past their due date for invoices. The Dunning Date defaults to the current system date.
Dunning
If selected, only that Dunning policy will be used to create a Dunning Run. If blank, Dunning Runs will be created for all active Dunning policies for the Client. This is only relevant if the Create Dunning Run process is performed from the Menu and not from the Dunning Run window. In the Dunning Run window, if the parameter is not blank it will replace the Dunning policy set in the Dunning Run record.
Dunning Level
If a Dunning policy is specified, the Dunning Run Entry and Line information can be limited to a single Dunning Level. If not specified, Entries will be created for each Dunning Level in the Dunning policy. In the Dunning Run window, if the parameter is not blank it will replace the Dunning Level set in the Dunning Run record.
Dunning Run Entries and Lines
Once the Dunning Run Entries and Lines have been created by the Create Dunning Run process, they can be reviewed and adjusted if required. No changes to the status of the invoices or customers has occurred and won't until the Dunning Run is printed. Until then, Run Entries and Lines can be deleted or made inactive (by deselecting the Active field). The entire Run can also be deleted. It may be apparent, for example, that payments can be allocated to unpaid invoices and that this should be done before the Customer is sent a dunning note. If necessary, the Create Dunning Run process can be repeated and the Dunning Run entries will be recreated.
To review the Dunning Run, open the Dunning Run window in the Open Items menu. The Dunning Run tab is pretty straight forward. Processed runs will be read only. Click the Create Dunning Run button to recreate the entries if required.
The Create Dunning Run process will overwrite the Dunning Date, Dunning policy and Dunning Level fields.
Dunning Run Entry
The Entry tab shows records for each Business Partner and Dunning Level. If a Level was not specified on the Dunning Run tab, there may be multiple Entry records for each Business Partner, one for each Level that applies. The following describes the key fields:
Field
Description
Dunning Level
Read only. Shows the Dunning Level that applies to this Entry.
Business Partner
Mandatory. The Business Partner that is responsible for the Line items. Note that this should be a read-only field. Be careful not to change it.
Partner Location
Mandatory. This will default to the Business Partner Location that is flagged as "Remit To" or "Pay From". If these aren't found, the first "Bill To" location will be used and if this also isn't found, the first active location will be used. If there are no active locations, the Create Dunning Run process will throw an exception.
User/Contact
Select the User or Contact who will receive the Dunning letter or email. The User/Contact will default to the first User associated with the Partner Location selected or the only User if there is just one User/Contact for the Business Partner. If there are multiple Users but none associated with the Partner Location, the field will be left blank. The User/Contact is required and the User record requires a valid email address if the Dunning letter will be sent by email.
Currency
Mandatory. The currency to use on the dunning letter. Defaults to the Currency used in the Create Dunning Run process. Invoice amounts will be converted to this currency using the default exchange rate in effect when the record is first saved.
Sales Representative
Mandatory. Defaults to the Sales Representative set in the Create Dunning Run process. The Sales Representative info can be used as contact info in letters and will be the "From" addressee on emails.
Note
The Note text can be used on the dunning letter to the Customer.
Amount
Read only. The converted total amount of all the invoices, payments, fees and interest in the Lines. A negative amount may indicate that the company owes the customer money.
Quantity
Read only. A count of all the invoices and payments in the Lines. The count does not include lines for fees or interest.
Dunning Run Line
The Line _**_tab list the invoices, payments, fees and interest being dunned. The fields are self explanatory.
The Times Dunned field is a count of the number of times the item appears on Dunning Run Lines, including unprocessed ones. See issue #2365.
Previewing the Dunning Letter
It is possible to preview or print a Dunning Letter from the Entry tab of the Dunning Run window. Simply select an Entry record and click the Print or Print Preview icon in the toolbar. A Dunning Letter for that entry, using the assigned print format will be shown/printed. An example is linked below.
Printing or previewing the Dunning Letter this way does not "process" the Entry. It only allows you to see the document that was or will be sent to the customer. To "process" the Entry, you have to run the Print Dunning Letters process discussed below.
dunningEntryExample.pdf
33KB
PDF
Example Dunning Letter
Print Dunning Letters
The process Print Dunning Letters in the Open Items menu will print the Dunning Run information and/or send the information as a PDF attachment to the customers. Running the process will mark the Dunning Run as "Processed", making it read-only. The process will also update the Collection Status and Dunning Level of the Invoice, and, if so configured in the Dunning policy, set the Customer's Business Partner Credit Status to Credit Stop and replace the Customer's default Payment Term.
There are a few parameters you can set to control how the process runs. The process can be run multiple times to reprint the information or change the parameters.
Parameter
Description
EMail PDF
If selected, the a PDF report listing the Dunning Run Entry Lines will be emailed to the Customer.
Mail Template
The email template to use. Mandatory if EMail PDF is selected.
Dunning Run
The Dunning Run to print. Only unprocessed Runs can be chosen. If left blank, ALL Dunning Runs will be (re)printed.
Only if BP has Balance
If selected, emails or printed reports will only be generated if the Entry Amount shows a positive balance greater than zero.
Print Unprocessed Entries Only
If selected, only unprocessed Entry records will be printed. If not selected, processed Entry records will be reprinted as well.
If the Dunning Run parameter is left blank and Print Unprocessed Entries Only is deselected, ALL Dunning Runs will be (re)printed. If EMail PDF is also selected, all the Dunning Run Entries will be (re)sent to the Customers. _**_See issue #2369.
Last modified 2yr ago