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

step image

First, log into the UGA Financial Management System.

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

2. Step 2

step image

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

step image

The Extract Dunning Letter Info search page is displayed.

Click the Add a New Value tab.

4. Step 4

step image

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

step image
Click the Add button.

6. Step 6

step image

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

step image

Enter the appropriate date into the As of Date field.

8. Step 8

step image

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

step image

Enter the appropriate information into the SetID field.  

Example shown here: "UGA01".

10. Step 10

step image

Enter the appropriate Business Unit into the Unit field.  

Example shown here: "66001".

11. Step 11

step image

Enter the appropriate information into the Customer ID field.  

Example shown here: "100242".

12. Step 12

step image

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

step image

The Dunning Group should be All Groups.

14. Step 14

step image

You should always select the Use Severest Dunning Letter option.

15. Step 15

step image

Click the Save button.

16. Step 16

step image

Click the Run button.

17. Step 17

step image

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

18. Step 18

step image

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

19. Step 19

step image

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

20. Step 20

step image

Click the OK button.

21. Step 21

step image

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

step image

Click the Process Monitor link.

23. Step 23

step image

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

24. Step 24

step image

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

step image

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

step image

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

28. Step 28

step image

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

step image

In the Actions section, click the Message Log link.

30. Step 30

step image

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

step image

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

Print Article

Details

Article ID: 148586
Created
Sat 9/24/22 10:48 PM
Modified
Sun 1/28/24 5:40 PM