LeasePak Utilities

239 Lease Accrual Reversals

The utility allows the users to reverse lease accruals for multiple leases back to a given effective date using an input file and generate report files mentioning all the exceptions and processing results similar to Accrual Reversals [U0301] update. The High Volume module is also required to run this utility.

Input File

Users must first create an input file and place it in the $udata directory before running the utility. The input file format will consist of two values on each line separated by a comma (,).  The first value must be the lease number that is to be reversed. The second value must either be the effective date to which the accruals should be reversed or the letter "C" meaning to reverse to the commencement date of the lease.

When using effective date, it should be entered in YYMMDD format.

A valid lease number is a 10 character number formatted per the LeasePak lease number definition. Any inconsistency in the input file will be handled in the following ways:

• If the program encounters a lease number of less than 10 characters, it will shift the characters to right by adding spaces at the left until it reaches to 10 characters, referred to as "right aligning".
• Any lease number having more than 10 digits is considered an invalid lease number. The program will ignore invalid lease number, log an exception in the report file, and continue reading the next lease number.
• Any lease number having blank characters or characters not allowed to be part of a LeasePak lease number in between (except already right aligned lease numbers) is considered an invalid lease number. The program will ignore invalid lease number, log an exception in the report file, and continue reading the next lease number.
• If the input effective date is not a valid date or if the utility encounters a character other than the character "C", the utility will ignore the input file line item and log it as an exception in the report file and continue reading the next line.
• Any data found after 16 characters on one line will be discarded.
• The program will ignore empty lines in the input file.

Below is an example of the input file format:

----- INPUT FILE START -----

    1234567890,890301

    0987654321,C

    .

    .

    nnnnnnnnnn

    ------ INPUT FILE END ------

User Interface

After users log on the LeasePak server, start the LeasePak Utilities, and select the Lease Accruals utility, the program displays:

This utility allow the user to employ an input file to reverse lease accruals for multiple leases back to a given effective date
Do you wish to continue [Y/N]?

Enter Y to proceed. The program will display:

Client Password?

Enter the correct LeasePak client string password to proceed. The program will display:

The file needs to be located in the $udata directory.
Enter in the file name, <RETURN> to exit

Enter the input file name with extension placed in the $udata directory. An invalid file name will result in the message “Unable to locate the specified file <filename.ext> in $udata directory.” and return the user to the same input request. It will keep asking for a valid input file name until it finds the one in the mentioned directory. To exit from the utility at this point, leave in the file name input blank and press Enter.

On entering a valid input file name, the program will proceed to process the accrual reversals up to the given effective date in the same way the Accrual Reversals [U0301] update does. It will also apply the rules applied to Accrual Reversals [U0301] for calculating accrual period during processing. Any failure in processing a lease accrual will be logged in the report file as an exception. When done, the program will display:

Accrue Lease(s)...Done. 

Report Output

On successful completion, the program will generate following report in the user's home directory:

• lp_util_###.rpt   

where ### represents the utility number. In this case it will be 239.

These report file header will contain the operator name, run date, and time. There will be two columns in this report. The first column will hold Lease Number whereas the other column will hold Exception Message. The messages will include the following:

• Invalid lease number: If lease number found is not a valid LeasePak lease number.
• Error: Could not find lease: If lease number can not be found.
• Error: Lease is not active: If lease is in NP* or NC* status.
• Warning: Midterm adjustments have occurred on this lease: If rebook is not allowed on the lease.
• Lease portfolio <Portfolio_Number> not found: If lease portfolio does not exist
• Error: Effective date must be on or after the last payment effective date: For IBLs date must be after the effective date of the last payment processed for the loan.
• Error: Effective date must be on or after the last principal adjustment date: For IBLs date must be after the last principal adjustment date.
• Error: Accrual reversal date may not be before the suspended earnings effective date <suspended_earning_date>
• Lease accruals reversed successfully to <new_accrued_to_date>: On successful reversal of lease accruals.
• Any other message generated by the main accrual reversal program.