LeasePak Utilities

235 AFM – Create asset level payment schedules

Creates payment schedules for assets attached to Asset Focus applications and leases. The utility requires a portfolio number from the user. The utility searches the given portfolio for the Asset Focus applications and leases to generates the payment schedules for their assets.

The utility also accepts inputs from external file. In order to do so, users need to create an input file containing the list of applications and leases to process in the data directory. Save the file with the name p[n]_afmcnrvt.dat, where n is the portfolio number. After prompting the user for a portfolio number, the utility searches the data directory in the user's environment for the presence of a data file. If found, it prompts the user whether they would like use the data in it for processing.

The input file must contain the data to process in the following format:

<lease>Lease number
<lease>Lease number

<app>Application number
<app>Application number

Example:

<app>64
<app>65

<lease>67
<lease>68

It is important that the data must follow the recommended format to avoid errors. Keep the following points in mind when creating the input file.

1. Although new line characters are supported, they are not necessary. The 235 utility skips any blank lines when reading the file.
2. The <app> and <lease> markers in the file are case sensitive and should be provided as demonstrated in the above example given.
3. Do not insert any extra spaces after or before the <app> and <lease> markers as they will result in an error.
4. Enter valid application and lease numbers only. LeasePak verifies all entries in the input file to ensure the applications and leases listed are valid and belong to the portfolio specified by the user. The utility will skip any invalid entries and will report them in the exception report for the job.
5. The order of <app> and <lease> entries may occur in any order in the file.
6. The utility will skip any duplicate entries in the file.

If the file specified is not in correct format, the utility will re-prompt whether the user wants to process through file or not. This will continue until either an input file with correct format is made available or the user selects not to use this option.

Audit Report
LeasePak generates an audit report, lp_util_235.LOG for the job. The report provides information on the selected processing method and any exceptions encountered. The generated report is available in the home directory of the LeasePak user executing the job. LeasePak creates a report for every job and hence will overwrite any existing report in the directory.