Skip to main content

AR: Sending Dunning Letters for Delinquent Customer and Statements in Receivables

 Sending Dunning Letters for Delinquent Customers

Introduction

Oracle Doc ID: Dunning Letter configurations in AR How to Setup and Troubleshoot Dunning Configurations (Doc ID 1324393.1)


Setups for Sending Dunning Letters for Customers.

Setups:

1. Create Aging Methods
2. Create Collectors
3. Create Dunning Configuration
4. Maintain Collector information in Account Profile Tab for Customer

1. Setup/review Aging Methods:

 

 

 

 

 

Navigator: Setup and Maintenance > All Tasks > Manage Aging Methods

 

 

 

 

 

 

 

 

 

Set the aging method you want to use. In this example “Vonage Aging” will be used.



2. Setup/review Collectors:

 

Navigator: Setup and Maintenance > All Tasks > Manage Collectors


3. Setup/review Dunning Configuration:

 

 

 

 

Navigator: Setup and Maintenance > All Tasks > Manage Dunning Configuration

 

 

 

 

 

 

 

 

 

Query the dunning configuration: In this example “Vonage Aged” will be used


Click on the dunning configuration row to review the details



4. Setup/review Collections Preferences:

 

 

 

Navigator: Setup and Maintenance > All Tasks > Manage Collections Preferences

 

 

 

 

 

 

 

 

Be sure you have entered aging method and email information



5. Setup/review Customer:

 

 

 

 

Navigator: Receivables > Navigator: Billing > Manage Customers

 

 

 

 

 

 

 

Be sure you have this information on the Account Profile



Be sure you have this information for the account contact on Communication Tab



Be sure you have this information on the account site details




Be sure you have this information on the site profile



Be sure you have this information for site contacts on Communication Tab





6. Review the Scoring formulas:

 

Navigator: Setup and Maintenance > All Tasks > Manage Collections Scoring

 

 

 

 

 

It is just for information purpose



Click on the Vonage Scoring Formula to see the details


 

 

 

        
   
  

7. Setup/review the Customer Collections Information

Navigator: Receivables > Collections > Customer

 

 

 

 

 

 

Be sure you have this information at Account profile



Be sure you have this information at Account Contact Tab



Be sure you have this information at Account Communication Tab


Be sure you have this information at Site profile



Be sure you have this information at site Contact Tab



 Process

  1. Create Transaction
  

The idea is to have or to be sure you have at least one delinquency entry.

In this example, enter an old transaction 10-Dec-2020 as today’s date

is 24-AUG-2022.


 

Be sure you have the transaction completed

 

 

 

 

 

 

 

Now, you need to run some processes

 

 

 

 

 

 

 

9. Run Refresh Receivables Transactions for Customer Account XY Summaries

Navigator: Tools > Scheduled Processes


Run Process Receivables Transactions for Customer Account XY Summaries

Navigator: Tools > Scheduled Processes


10. Run Collections Scoring

 

Navigator: Tools > Scheduled Processes


It is not Mandatory



11. Run Collections Delinquency Management

Navigator: Tools > Scheduled Processes



Run Update Collections Summary Data

Navigator: Tools > Scheduled Processes



12. Run Validate Customer Dunning Setup Report

 

 

 

 

 

Navigator: Tools > Scheduled Processes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

This report is to see any setup issue on the customer that you want to generate the dunning letters





If you have an error here, you need to fix all the errors first and then continue. Do not continue

if you have an error on this report

 

 

 

Example of one report with errors:


13. Review the collections information:

 

Navigator: Receivables > Collections > Customer

 

 

 

 

 

 

Search by customer and go to Transactions Tab


14. Manage Statement Cycles

 

 

 

 

 

Navigator: Setup and Maintenance > All Tasks > Manage Statement Cycles


AC-001


AC-002




AC-003







AC-004


System Test Script - Oracle ERP Cloud - R13 - Receivables

Generate Dunning Letters for delinquent transaction

 

Overview

Test Script Specification

Software / Release

22B

Test Script ID #

2

Pilot / SIT# / UAT#

Test

Test Script Name

Create Customer Statements


  
       

    AC-001


AC-002


AC-003

 







AC-004

 


 

 

 

 

 

 

Comments

Popular posts from this blog

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management  

Finance All Modules Process Flows

  To- Be Process Flow General Ledger Manual Journal Approval Process Flow Journal Management Invoice Process Flow for Equipment Orders Payment Receiving Through Lock Box Process Flow Collections Overview Process Flow Process Flow to Handle Delinquent Customer Collections Process Flow Payable Invoice (PO Matched) workflow process   Payable Invoice (Non PO Matched) Workflow Process Payment Batch Process  IDR Process Flow To-Be Process Flow Bank Reconciliation - Payment Payables to Fixed Assets Flow Process Flow - Transfer Assets Process Flow –Reclassification (Change Category) Process Flow – Retire Asset Process Flow – Reinstate Asset Process Flow – Impairment Process flow- Depreciate Assets CORP Book to Tax Book TO-Be Process Flow – General Ledger Manual Journal Approval Process Flow   Journal Management