Total Invoice Amount is Not Calculating Correctly for Days Overdue Dunning (Doc ID 2098591.1)

Last updated on MAY 20, 2024

Applies to:

Symptoms

When using Days Overdue dunning in Advanced Collections, the Total Invoice Amount is not calculating correctly, and can result in no dunning letter. Running Staged Dunning for
the same customer works fine.

Steps to Reproduce:

Responsibility: Collections Agent
Navigation: Run IEX: Send Dunning for Delinquent Customers program

1. Create a new customer and create 3 invoices for $129 each (total overdue is $387).
2. Run scoring and make them all delinquent.
3. Create an on account credit memo for that same customer for $183.
4. Run Days overdue dunning, no letter is produced, and the log file indicates the following (actual past due balance = $204):

   Total Invoice amount= 129
   Total of open Account Receipts and credit memos= -183
   Total amount due remaining at Billto level= -54
   Total amount due is less than Minimum dunning amount, so returning value "N"
   Error:The dunning amount does not exceed the minimum required in customer profile to send dunning.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.