Loan Payment Due Processing Report
Overview of IL665
This Loan System report is run at least once a month to update the payment due status for each loan and to create the loan payment “buckets” that are viewed in the loan Payment History screen (available from Loan Inquiry.) You can run the report in review mode, which allows you to verify actions to be taken, or in update mode, which updates the affected loan records. This report is traditionally set up to run as part of your periodic job processing. To run the report:
- From the DDI Connect main menu, double-click Financial Services
- Double-click Loans
- Double-click Reports
- Double-click 665 Loan Payment Due Processing. The parameters screen will launch:
You have the following options:
| Field | Description |
|---|---|
| Base date | This is normally set to the current processing date and is used in a variety of ways. For example, loans with a recent payment dated after the Base Date will not be processed. |
| Update loans through | Specifies the cutoff for loan payment due dates: loans that are due after this date will not be processed. Normally, this date should be set to one week beyond the current process date to ensure that loans with weekly payment schedules are not processed more than once per week |
| Calculate prepaid/past due as of | Specifies the date used for calculating the loan’s prepaid / past due amount. Normally, this is set to the current processing date |
| Loan number | Leave blank to process all loans, or enter a number to process a specific loan |
| Loan payment codes | Allows you to process loans having certain payment frequencies, e.g. Monthly, Weekly, etc. This might be used, for example, to run IL665 daily for weekly and biweekly loans, and monthly for all other loans |
| Update loans and create payment due records | If this option is selected, the report will update all loans included in the parameters of the report |
| Review only - no data will be updated | If this option is selected, the system will display the actions to be taken, but will not update the loan records until the Update option is selected |
| Status of loans to process | Click the drop down to select which loans to run this process for. Your options are: All loans, Interest Only Loans or Regular loans |
NOTE: It is important that you run this process correctly if you are processing interest only loans. Within your Month End processing, you will want to run the report in the following order:
- IL665 - Regular Loans Only
- IL602 (post interest)
- IL665 - Interest Only Loans (This ensures that payment due records are created that include month-end interest posted)
Print Options
After clicking the Print Options button you will see the following options. Choose the desired options and click OK to return to the report parameters screen.
| Option | Description |
|---|---|
| Printer | Click the drop down arrow to select from a list of available printers. DDI Connect uses your default printer unless told otherwise |
| Format | Click the drop down arrow to select from a list of available formats. Select paper size, number of columns, and number of rows for printing. Each report has built-in format defaults. Select “Use Defaults” to use the built-in report defaults. The number of rows and columns controls the print size and amount of information per page |
| Memo | If you wish, you can add a memo to the output of the report. NOTE: It is recommended that Word documents be saved with the .docx extension |
| View Report | This option generates a pdf file that is displayed on the screen when the report is generated |
| Archive Report | If this option is selected, the system will archive the report in the DDI Connect report archives. For information on working with archived reports, please reference this page: Archived Report Viewer |
| Print Report | If selected, the system will generate the report output to your default printer. NOTE: You will also receive a pdf version of the report, displayed on your screen |
| Print via PDF | Prints directly to your printer. |
| This option allows you to send a .pdf attachment of the report to the indicated users' email addresses. When OK is clicked, a dialog box will open requesting a recipient | |
| Duplex/Top | Prints the report on both sides of the paper in landscape style. The printer must be capable of printing on both sides or an error will occur |
| Duplex/Side | Prints the report on both sides of the paper in portrait style. The printer must be capable of printing on both sides or an error will occur |
| Green bar | Adds shaded, horizontal bars to the report, making it easier to read across columns |
| No dialog | Selecting this option means that no ‘Report Completed’ dialog will display after the report has been generated |
| Extra copies | If you want extra copies of the report generated, type the number in this field |
Click Start. The system will now display a pdf report based on the parameters you selected. Click the icon below to view a sample of this report.
