The Writeoff utility is used to create a set of transactions that write off the pledge balances in a set of pledge transactions. The pledge transactions may be located in either the Dues table or the Giving table. The desired set of pledges are identified by creating appropriate criteria and running it using the Millennium Reporter. The utility is launched as part of the run of the criteria. It automatically uses the resulting generic export worktable and creates a linked Writeoff transaction for every qualifying transaction shown in the worktable. To qualify, a transaction must have a Type of: pledge, pledge potential, match pledge, match potential, or expectancy, and have a balance greater than zero.
This utility alters existing data and creates new data rows and is classified as a system administrator Utility.
Before you embark on the mechanics of using the Writeoff utility, you must make a determination as an institution as to the characteristics which will identify those pledges, match pledges, potential pledges, potential match pledges, or expectancies that you no longer expect to be fulfilled. These transactions must be definable using criteria statements in the Millennium Reporter. For example, you may want to select all pledges that were made in response to a particular solicitation, that are associated with a particular campaign or campaign year, or any other criteria that you want to construct that selects the specific transactions that you want to write off. The utility will verify that the selected rows are of the appropriate types (pledge, pledge potential, match pledge, match pledge potential, or expectancy) and that the amount/balance is greater than zero (they aren't paid off), but you may also want to include selection criteria that ensures that those are the only transactions in the worktable, for the sake of efficiency.
The key table in the criteria must be the Giving or the Dues tables. If you use criteria groups, the key table for each group must be either the Giving or Dues table. If you want, a single set of criteria could include a group that selects the desired Giving rows and a group that selects the desired Dues rows.
When the report criteria have been created and saved, and the report options are set for the Writeoff utility, you must save the report criteria and then you may run it. After setting the Run options, the system will automatically prompt you with a form used to enter the prototype data for the writeoff transactions you will be creating. All transactions will conform to the information that you enter on this form, though other data in the new writeoff row will be copied from the original pledge to which it is linked. The fields for which you may enter data as the prototype for the new transactions are:
For example, the Comment on each writeoff row that is created by the utility will contain the Comment information that you enter on the prototype form during the run of the utility. But each will contain a different amount - one that is equal to the balance amount on the pledge, match pledge or expectancy to which it is linked, and each will show the Account, Campaign, Solicitation, etc. from the original transaction.
The following instructions assume that you are familiar with the use of the Millennium Reporter.
Use the following steps to create a writeoff report using the Writeoff Utility:
The Output List should be set to Utilities.
The Salutation check box should be unchecked.
The Address option should be set to None.
Remove Spouses should be set to No.
The Worktable format should be set to Generic.
Choose the User ID for whom the criteria will be run. (Remember that this user must have Insert and Update permissions on the Giving and/or Dues table, and that user's security Views on any data tables referenced in the criteria will affect the selection results.
Select the Queue you want to use for the run of the report.
Set Format Names to No.
The Save Export option may be set as you want, although we suggest that you might want to save the file and print out a list of the Constituent ID's that were affected.
The Print Criteria option may be set as you want, although we suggest that you print and save the criteria in a notebook as a log.
You may set the run Priority as you want.
When all options are set as desired, click on OK. The system will present a Utility Options form.
Batch - Enter a valid Batch Number. Note that if you are using the utility to process both Gift and Dues writeoffs in the same run, the Batch Number you specify must be valid in both the Gift Batch Numbers and Dues Batch Numbers lookup tables. Also note that this form accepts any entry you type for this data. If you use a Batch Number that does not exist in the lookup table, the utility will give an error message.
Comment - Enter any free text comment you want.
Process Date - Use the calendar or type in a date using standard datetime data entry techniques.
Effective Date - Use the calendar or type in a date using standard datetime data entry techniques.