If you service loans that have borrowers who pay with coupons (instead of billing statements or via the ACH System), you can order more coupons by performing a series of tasks, one of which includes running the Coupon Export from Event Manager.
The Coupon Export selects active loans that need new coupon books, creates a coupon export table, and generates an export file based on the export table. This event also updates the Next Coupon/Bill date in the Customer Service module.
Note: If you use NCP export events to create EDI export files to send to NCP, there are a few additional steps. Servicing Director uses the deluxe 128 character format for the NCP export.
To order coupons, you must perform the following main tasks:
1. Run the Coupon Export event to create the Export Table; Creating the export table is the first step to ordering more coupons. When you create an export table, you are including in a database table all loans for which you are ordering coupons. After you create the export table, you can convert it to an export file and then send it to the coupon vendor that you use to produce coupons. You can perform this step repeatedly until the table includes the correct information without affecting the next coupon date.
- Access the Event Manager Application.
- Under the Available Events list expand system administration.
- Expand Imports/Export.
- Select the coupon export and drag it to the scheduled instances list,select criteria:
- Select one of the following options:
- Create Export Table Using Current Date: If you select this option, Servicing Director uses the current transaction posting date through which to order more coupons
- Create Export Table: If you select this option, you must enter a date in the field to the right of the option. For example, you can enter June 1, 2005 and include in the export table all loans with a next coupon date of June 1, 2005 and before.
- Select OK.
- Select Run. Servicing Director creates the export table and notifies you when it is done.
Previewing the Coupons Ordered report is the second step in the coupon-ordering process. Previewing this report verifies that you are including in the export table only the loans for which you want to order more coupons. You can perform this step repeatedly until the table includes the correct information without affecting the next coupon date.
Previewing the Coupons Ordered Report:
- Select the Event Manager Application.
- Under available events expand Customer Service.
- Expand Reports.
- Select the coupons ordered report.
- Drag it to the scheduled instances.
- Select criteria.
- In the Instance Criteria screen select preview.
- Verify that the report contains only those loans that you want to order more coupons for
Note: If the report contains loans that you do not want to order more coupons for, or if it contains loans that you do want to order more coupons for that do not appear in the export table, determine why the loans are or do not appear in the export table.
- Select close the instance criteria screen reappears.
- Select Close.
Creating the Export File: Creating the Export File is the third step in the coupon-ordering process. When you create the export file, the Event Manager creates a file based on the export table you created, and then it updates the value in the Next Coupon Date field for each of the loans you are ordering coupons for.
- Access the Event Manager Application.
- Under the Available Events expand the system administration folder.
- Expand Imports/Exports.
- Select the Coupon Export and drag it to the scheduled instances.
- Select criteria.
- Select the Create Export File option, and then select ok. The windows import /export location screen appears.
- In the save in field, select the location where you want to store the export file before you send to the coupon vendor.
- Enter the name for the export file.
- Select Save.
- Select Run.
Servicing Director creates the export file and stores it in the specified location.
Sending the Export File to the Coupon Vendor Sending the export file to the coupon vendor is the final step in the coupon-ordering process. When you send the export file to the vendor, the vendor creates coupons for all loans that are included in the export file. Depending on the arrangement you have with the vendor, they might send you the coupons to verify or they might send them directly to the borrowers.
To send the export file to the coupon vendor
- Locate the export file that you created
Note: If you do not remember where you saved the export file to, search for the file in Explorer. An easy way to do this is to open Explorer, click Tools > Find from, select Files or Folders from the sub menu, type *.exp in the Named field, select My Computer from the Look In field, and then select Find Now - Decide how you are going to send it to the vendor and then send it. For example, if you are going to send it on disk through the U.S. Postal System, place the file on disk if you have not already done so. Alternatively, if you are going to send the file electronically (for example, via e-mail), open your e-mail system, and attach the file (as you would attach any file).
- If you receive the coupons from the vendor (instead of requesting the vendor send them directly to the borrowers), verify their contents before sending them to the borrowers.
ArticleNumber:
000051164