Creating a Dunning Letter Extract

   Overview   

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. In this article, you will use the Process Scheduler to run the Create Dunning Letters Extract process. Process Scheduler enables you to run reports while you are working on other tasks, which you can then access later when needed.

Basic Process Scheduler terms include:

  • Process Request: A single "run request" such as an SQR or PDF report.  
  • Run Control ID: A unique ID, associating each operator with his or her own run control table entries. Once defined, the same run control ID can be used to run subsequent Aging Summary by Unit reports. When creating a run control ID, it is recommended that the format contain the abbreviation for the module name, and the name of the process: AR_DUNNING_LTR_EXTRACT.
  • Process Instance: A unique number that identifies each process request. This value is automatically incremented and assigned to each request process when the process is submitted to run.

In this article, you will learn the steps to create a dunning letter extract.

1. Step 1

The Employee Self Service page is displayed with the Classic Home tile highlighted.

First, log into the UGA Financial Management System.

On the UGA Financials page, click the Classic Home tile.

2. Step 2

The Main Menu navigation page is displayed with the "Extract Dunning Letter Info" option highlighted.

To navigate to the Extract Dunning Letter Info page:

Main Menu > Accounts Receivable > Customer Interactions > Dunning Letters > Extract Dunning Letter Info

Click the Extract Dunning Letter Info menu.

3. Step 3

 The Extract Dunning Letter Info page is displayed with the Add a New Value tab highlighted.

The Extract Dunning Letter Info search page is displayed.

Click the Add a New Value tab.

4. Step 4

 The Extract Dunning Letter Info page is displayed with the Run Control ID field highlighted.

The Extract Dunning Letter Info page is displayed. You will use this page to enter the Run Control ID for creating dunning letters.

A Run Control ID is an identifier that uniquely identifies the process you are running. The Run Control ID defines parameters that are used when a process is run. This ensures that when a process runs in the background, the system does not prompt you for additional values.

Note: You can use the same Run Control UD for creating future dunning letter extracts, so you will want to enter an ID that is easily recognizable by you. One good option is to start with the initials of the module you are working in, followed by the name of the process.

Example shown here: "AR_DUNNING_LTR_EXTRACT" into the Run Control ID field.

5. Step 5

The Add button is highlighted.
Click the Add button.

6. Step 6

The Dunning Letters Parameters page is displayed with the Report Request Parameters section highlighted.

The Dunning Letters Parameters page is displayed. This page is used to enter the Report Request Parameters. These parameters will be used to define the processing rules and data to be included when the process is run.

Note: The Run Control ID you created is shown at the top of the page.

7. Step 7

The Dunning Letters Parameters page is displayed with the As of Date field highlighted.

Enter the appropriate date into the As of Date field.

8. Step 8

The Use System Date checkbox is highlighted.

If you click the Use System Date option, the As of Date will be set to the current system date. Generally, the system date is today’s date.

Example shown here: Use System Date option.

9. Step 9

The SetID field is highlighted.

Enter the appropriate information into the SetID field.  

Example shown here: "UGA01".

10. Step 10

The Unit field is highlighted.

Enter the appropriate Business Unit into the Unit field.  

Example shown here: "66001".

11. Step 11

The Customer ID field is highlighted.

Enter the appropriate information into the Customer ID field.  

Example shown here: "100242".

12. Step 12

The Correspondence Customer field is highlighted.

Enter the appropriate information into the Correspondence Customer field. Leaving the % sign in this field will save all correspondence customers.  

Example shown here: "%".

13. Step 13

The Dunning Group field with the value "All Groups" selected is highlighted.

The Dunning Group should be All Groups.

14. Step 14

The selected "Use Severest Dunning Letter" option and unselected "Use Modest Dunning Letter" option are highlighted.

You should always select the Use Severest Dunning Letter option.

15. Step 15

The Save button is highlighted.

Click the Save button.

16. Step 16

The Run button is highlighted.

Click the Run button.

17. Step 17

The Process Scheduler Request pop-up window is displayed and highlighted.

The Process Scheduler Request dialog box is displayed. This page is used to enter the process output format. 

18. Step 18

The Process Scheduler Request pop-up window is displayed with the Server Name field highlighted.

The Server Name field will default to the appropriate Server Name. Leave this field as it is.

19. Step 19

The AR Dunning checkbox is highlighted.

In the Process List section, click the Select checkbox next to AR Dunning.

20. Step 20

The OK button is highlighted.

Click the OK button.

21. Step 21

The Dunning Letters Parameters page is displayed with the Process Instance number highlighted.

The Process Instance number is displayed at the top of the page. This number helps you identify the process you have run when you check the run status. 

22. Step 22

The Dunning Letters Parameters page is displayed with the Process Monitor link highlighted.

Click the Process Monitor link.

23. Step 23

The Process List page is displayed and highlighted.

The Process List page is displayed. This page is used to view the status of the process request. 

24. Step 24

The Process List page is displayed with the Run Status value "Success" highlighted.

The current Run Status of the process is Queued. If the Run Status field displays Success , it means that the process is finished.

25. Step 25

The Refresh button is highlighted.

Click the Refresh button until the status is updated to Success.

Note: You may have to do this several times until the process has finished updating the transaction.

26. Step 26

step image

If the Run Status field displays Success, this confirms the dunning letter extract creation process has successfully completed. 

27. Step 27

The Details link is highlighted.

Click the Details link to view the detailed information about this process.

28. Step 28

The Process Detail pop-up window is displayed and highlighted.

The Process Detail dialog box is displayed.

You can view the detailed information about the selected process including Process, Run, and Data/Time. You can also update the status of the process and perform additional actions. 

29. Step 29

The Process Detail pop-up window is displayed and the Message Log link is highlighted.

In the Actions section, click the Message Log link.

30. Step 30

The Message Log pop-up window is displayed and highlighted.

The Message Log dialog box is displayed.

You can view the detailed information about each log time with the associated message text. The Explain button will provide more detailed information.

31. Step 31

The Message Log page is displayed with the "Dunning ID=13." message highlighted.

The Dunning ID is the assigned dunning letter number. You will need this Dunning ID number for searching and printing the letter.