Total Invoice Amount is Not Calculating Correctly for Days Overdue Dunning
Last updated on APRIL 30, 2018
Applies to:Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.
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
- Create a new customer and create 3 invoices for $129 each (total overdue is $387).
- Run scoring and make them all delinquent.
- Create an on account credit memo for that same customer for $183.
- 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.
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