Generating Dunning Letters

Purpose: Generate dunning letters using ctcLink.

Audience: Accounts Receivable staff

You must have at least one of these local college managed security roles:

  • ZZ AR Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Generating Dunning Letters

Dunning letters are used to communicate information to customers such as their account balance, items in their account, and the age of the items in their account.

To generate dunning letters for specific customers, you need to run a single, two-step process that uses Structured Query Reports (SQR) and BI Publisher.  SQR retrieves data from customer and item records, and BI Publisher organizes that data into letters.

Navigation:   Accounts Receivable > Customer Interactions > Dunning Letters  > Extract Dunning Letter Info

  1. The Extract Dunning Letter Info run control ID search page displays. It defaults to the Find an Existing Value tab.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_DUNNING_JH1 (Institution Code, Dunning Letter, ID).
  3. This QRG assumes you already have an existing run control ID. Enter it into the Run Control ID field.
  4. Select Search.
  5. The Dunning Letters Parameters page displays. Use it to enter the request parameters. These parameters will be used to define the processing rules and data to be included when the process is run.
  6. Enter Customer ID.
  7. Enter Correspondence Customer.
  8. Select Run.
  9. The Process Scheduler Request page displays. Use it to enter or update parameters, such as server name and process output format.

You must select a Server Name to identify the server on which the process will run.  If you use the same Run Control ID for subsequent processes, the server name that you last used will default in this field.

  1. Select the AR Dunning option.
  2. Use the Type list to select the type of output you want to generate for this job. Your four choices are:
    • File
    • Printer
    • Email
    • Web
  3. Use the Format list to define the output format for the report.  The values are dependent upon the Process Type for the process you have selected.
  4. Select OK.
  5. The Process Scheduler Request page disappears, and the updated Dunning Letters Parameters page displays.  Note the Process Instance number.
  6. Select Process Monitor.  Refer to the Process Monitor QRG for instructions.
  7. Use the Process List tab to view the status of submitted process requests.
  8. The initial status of the process is Queued.  The process is finished when the status is Success.
  9. Continue to select the Refresh button until the status is Success.
  10. The Run Status is now Success.

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

View Tutorial via Panopto

View the external link to Generating Dunning Letters. This link will open in a new tab/window.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.