Dunning Setup

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.

Table of Contents{{#if: Table of Contents#Business Features| | Table of Contents#Business Features }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Dunning Setup{{#if: | | [[{{{next}}}]] }} ⇒

Dunning is the process of collecting money from customers. As a process, it generally starts with polite requests, perhaps verbally, 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.
  2. For returned checks - enter a negative payment. 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.
  3. For invoices over 30 days, a letter requesting immediate payment.
  4. For invoices over 60 days, a letter threatening that the amounts will be passed to a collections agent.
  5. For invoices over 90 days, write off the amount owing and pass the invoice to the collections agent. This is a manual process.

ADempiere offers some features for dunning. You can define multiple dunning types each with several levels which are linked to business partners or business partner groups. A dunning run collects the due unpaid invoices that should be dunned and the 'print dunning letters' process prints all dunning letters of a dunning run. The instructions below set up dunning with two levels.


  • Login as client admin.
  • Go to Partner Relations -> Business Partner Rules -> Dunning.
  • Create a new entry (Default Dunning) and check at least the 'Default' checkbox.


  • Create a new dunning level (First Reminder). Make sure to select a 'Dunning Print Format and be careful with the 'Days between dunning' field at your first dunning level:

If you uncheck the 'Show all due' and 'Show not due' flags and set the 'Days between dunning' greater then '0' the system will never generate dunning letters because the method DunningRunCreate.addInvoices() performs this check where DaysAfterLast will allways be '0' for not yet dunned invoices:

if (DaysBetweenDunning != 0 && DaysAfterLast < DaysBetweenDunning && !m_level.isShowAllDue () && !m_level.isShowNotDue ()) continue;

Dunninglevel 01.png

  • Create a second dunning level (Second Reminder).

Dunninglevel 02.png

Set the dunning type for your business partners

  • Go to Partner Relations -> Business Partner Rules -> Business Partner.
  • Select a customer.
  • Open the 'Customer' tabulator and select the new created dunning type from the 'Dunning' drop down.
Note.gif Note:

To set the default dunning type for all customers for the first client (AD_Client_ID=1000000) you can run this sql statement:

UPDATE C_BPartner SET C_Dunning_ID= (SELECT MAX(C_Dunning_ID) FROM C_Dunning WHERE IsDefault='Y' AND AD_Client_ID=1000000) WHERE IsCustomer='Y' AND AD_Client_ID=1000000;

Create the dunning runs

  • Go to Open Items -> Dunning Run and create a new entry for each of your dunning levels (First Reminder and Second Reminder).

Dunningrun 01.png

  • Select the dunning run entry for the first dunning level, enter a dunning date and push the 'Create dunning run' button.
  • Press the 'OK' button, this will create the dunning entries and lines.

Dunningrun 02.png

Dunningrun 03.png


  • Zoom to a dunned invoice. You will notice that the collection status is set to 'Dunning' and the dunning level is set to 'First Reminder'.
  • Before we can proceed with the dunning run for the second dunning level (Second Reminder) we first have to print the dunning letters of the first dunning run. We have to do this because the dunning print process sets the 'processed' flag for the printed dunning lines and that is the only indicator for the system that a certain invoice already has been dunned.

It is not possible to reuse dunning runs (e.g. every week) because the information about the dunning status of an invoice is taken from the existing dunning runs. If you delete the entries of a dunning run the system doesn't know anymore that the invoice has been dunned!

Print the dunning letters

  • Go to Open Items -> Print Dunning Letters.
  • Select a dunning run from the dropdown list.
  • Press the 'Start' button. The dunning letters are printed and the 'processed' flag is set for the dunning run and it's entries. You now can proceed with the second dunning level.