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

Last updated on MARCH 27, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms