Deposit Reports > Deposit Reports - Numerical Order

Availability

This report program is run daily in the afterhours processing. The report does not necessarily need to be printed or sent to the Report Warehouse; the program just needs to be run. The actual letters will be mail-merged and printed from Microsoft® Word each day by your institution.

Purpose

The Event Letter Generation Report shows the afterhours events your institution chooses to utilize. Your institution determines which events will be reported on the Deposit Event Setup screen (function 35/36) in GOLD Services (Application 8). On that screen, select the events by checkmarking the fields next to them. For several events, certain run options will also need to be specified. Currently, there are 20 deposit events available; for more information about specific events, please see chapter 6.2 in the GOLD EventLetters manual.

An option is available added that will split out the “No Mail” letters to their own event. The system will add 100 to the original event number, and all “No Mail” letters will appear for that event (for example, no mail 1040 events will become 1140). These new events will need to be attached to a letter before they can be printed. If your institution would like to use this feature, you will need to tie the appropriate event numbers to your event letters, then submit a work order to have the option turned on.

If this option is not utilized, the “No Mail” letters will be intermingled with the letters to be mailed, but will still indicate the “No Mail” status.

Detail Lines show the following information:

•Event Number

•Letter Number

•Account Number

•Office

•Box Number

•Household Number

•Plan Number

•Description

The following sort fields are available:

80 - Event Number

81 - Letter Number

82 - Office Number

83 - Account Number

84 - Safe Deposit Box Office

85 - Safe Deposit Box Number

GOLDPoint Systems Only:

To sort by:	add to critical:
80	2
81	2
82	2
83	5
84	2
85	3

For no sorts, the Critical From must be 1 to 4.

Input Records should include DM, MN, DX, TG, SB.

Misc Parm must be set to “report” to produce the report. If left blank, it will only generate the event letters.

If Misc Opts 1 is set to “Y,” the program will split “No Mail” letters into separate events using event numbers plus 100.

A daily and next-day report must be set up.

Report Column Information

See FPSDR500 Example for an example of this report.

Event Number	This is the system-defined event number that was processed for the account listed.
Letter Number	This is the letter number for the event that was processed for the account listed. It may be a product code, or some other type of indicator to specify particular account types within the event.
Account Number	This is the office number (DMACTO), account number (DMACTA), and the check digit (DMCKDG) for the account processing the event.
Office	This is the office number for the safe deposit box, if this is an event for a safe deposit box billing or escheatment.
Box Number	This is the safe deposit box number, if this is an event for a safe deposit box rental or escheatment.
Household Number	This is the account owner’s household number (MNHHLD). It is taken from the CIF System.
Plan Number	This is the retirement plan number (DMPLAN) if the account is a retirement account and is processing a retirement event.
Description	This is the system-defined description of the event being processed for the account listed.

Event Letter Generation Report (FPSDR500)

Event Letter Generation Report (FPSDR500)