How to Configure Dunning in iDempiere

The Dunning window defines an organization’s customer payment reminder policy for overdue receivables, made up of one or more escalating Dunning Levels.

In retail, it is used to automate reminder letters for unpaid invoices, from a friendly first notice through fees, credit stop, and legal collection status.

The Dunning definition itself does not send reminders; it is the policy the Dunning Run process applies when evaluating overdue invoices.

Process Flow Diagram

Dunning1

Business Rules

  • A Dunning Name is mandatory on the header.
  • A Dunning can contain multiple Dunning Levels.
  • Each Dunning Level has its own overdue period, fee, and collection behavior.
  • Print Text is mandatory on every Dunning Level.
  • When Create Levels Sequentially is enabled, earlier levels must be reached before a higher level applies.
  • Collection fees, Credit Stop, Payment Term changes, and Collection Status are all optional per level.
  • Collection Status offers four options: Collection Agency, Dunning, Legal Procedure, and Uncollectable.
  • The Dunning configuration itself does not generate reminders; it is the policy used by the Dunning Run.

Prerequisites

  • Organization configured.
  • Payment Term configured, if a level will use Set Payment Term.
  • Dunning Print Format configured, if a custom print layout is required.

Configuration Steps

Step 1: Create the Dunning Header

The header names the policy and decides whether levels must be reached in order, before any individual reminder stage is defined.

Create a new Dunning record, enter the Name and Description, then set Active, Default, and Create Levels Sequentially as needed.

FieldSample ValueDescription
OrganizationCDCOrganization this dunning policy applies to
NameStandard Customer DunningMandatory name identifying the policy
DescriptionCustomer payment reminder with three escalation levelsOptional description of the policy
ActiveCheckedEnables the policy for use
DefaultCheckedUses this policy automatically when no other is specified
Create levels sequentiallyCheckedRequires earlier levels to be reached before a higher level applies
Note: Name and, on each level, Print Text are mandatory; saving with either blank leaves the field outlined in red.
TenthPlanet iDempiere Accounting Dunning

Step 2: Create the First Dunning Level

The first level is usually a low-pressure reminder, sent soon after the due date without any fee or credit restriction.

Add a new Level, enter the Name, Days after due date, Days between dunning, and Print Text, then leave Charge fee and Credit Stop unchecked.

FieldSample ValueDescription
NameFriendly ReminderLabel for this escalation stage
DescriptionFirst payment reminder for overdue invoicesPurpose of this level
Days after due date5.0How many days overdue before this level applies
Days between dunning5Minimum days before the next reminder can be sent
Show Not DueUncheckedWhether invoices not yet due are listed on the notice
Show All DueCheckedLists all due invoices, not just the overdue one
Charge feeUncheckedNo collection fee applied at this level
Print TextYour payment is overdue. Kindly arrange payment.Message printed on the reminder
NoteFirst reminder sent to the customer.Internal note about this level
TenthPlanet iDempiere Accounting Dunning1

Step 3: Create the Second Dunning Level

The second level escalates the reminder by adding a fee, signalling to the customer that the account is now further overdue.

Add a new Level, enter the timing and Print Text as before, then check Charge fee and enter a Fee Amount, and set a Collection Status.

FieldSample ValueDescription
NameSecond ReminderLabel for this escalation stage
DescriptionSecond notice for unpaid customer invoicesPurpose of this level
Days after due date15.0How many days overdue before this level applies
Days between dunning10Minimum days before the next reminder can be sent
Charge feeCheckedApplies a collection fee at this level
Fee Amount250.00Fee charged when this level is reached
Collection StatusDunningCollection status applied to the business partner at this level
Print TextSecond payment reminder. Settle all outstanding invoices.Message printed on the reminder
NoteSecond reminder with administrative feeInternal note about this level
TenthPlanet iDempiere Accounting Dunning2

Step 4: Create the Final Dunning Level

The final level is the last step before legal collection, so it typically applies a higher fee, stops further credit, and can force immediate payment terms.

Add a new Level, enter the timing and Print Text, check Charge fee with a higher Fee Amount, then check Credit Stop and Set Payment Term with the required Payment Term and Collection Status.

FieldSample ValueDescription
NameFinal NoticeLabel for this escalation stage
DescriptionFinal Demand before legal collectionPurpose of this level
Days after due date30.0How many days overdue before this level applies
Days between dunning15Minimum days before the next reminder can be sent
Charge feeCheckedApplies a collection fee at this level
Fee Amount500.00Fee charged when this level is reached
Credit StopCheckedBlocks further credit to the business partner
Set Payment TermCheckedOverrides the business partner’s payment term
Payment TermImmediatePayment term applied once this level is reached
Collection StatusLegal ProcedureCollection status applied to the business partner at this level
Print TextFinal payment notice, make immediate paymentMessage printed on the reminder
NoteFinal collection notice before legal escalation.Internal note about this level
Note: Collection Status offers four values: Collection Agency, Dunning, Legal Procedure, and Uncollectable.
TenthPlanet iDempiere Accounting Dunning3

Step 5: Review All Dunning Levels

Reviewing all levels together confirms the escalation makes sense from first reminder through to final notice before the policy is used.

Open the Level tab on the Dunning header and confirm each level’s Days after due date, Fee Amount, and Print Text increase in severity in order.

LevelDays after Due DateFee Amount
Friendly Reminder5.00.00
Second Reminder15.0250.00
Final Notice30.0500.00
TenthPlanet iDempiere Accounting Dunning4

Step 6: Use the Dunning Configuration

The configured policy only takes effect once it is applied during an actual Dunning Run against overdue invoices.

Assign the Dunning policy to a Business Partner if required, then execute the Dunning Run process; the system evaluates overdue invoices against the configured levels and applies the matching rules.

Common Issues and Resolutions

IssueCauseResolution
Cannot save DunningName not enteredEnter a unique Dunning Name
Cannot save Dunning LevelName or Print Text not enteredEnter both the mandatory Name and Print Text before saving
Reminder level not appliedOverdue days do not satisfy the configured Days after due dateVerify the invoice’s overdue days against the level’s threshold
Higher level not reachedCreate Levels Sequentially is enabled but earlier levels were skippedEnsure previous levels have already been generated before the next applies
Credit Stop not enforcedCredit Stop not enabled on the applicable levelEnable Credit Stop on the Dunning Level
Fee not appliedCharge fee unchecked or Fee Amount left blankEnable Charge fee and enter a Fee Amount for the level

Next Steps

  • Assign the Dunning policy to applicable Business Partners.
  • Create and complete Sales Orders and AR Invoices.
  • Allow invoices to become overdue based on their payment terms.
  • Execute the Create Dunning Run process.
  • Review generated Dunning Notices and send reminders to customers.
  • Continue through higher Dunning Levels until payment is received or the final stage is reached.