LeasePak Utilities

240 Lease Accruals

240 Lease Accruals

The utility allows the users to accrue multiple leases up to the current date using an input file (holding lease numbers to accrue) and generate report files mentioning all the exceptions and processing results similar to Accruals [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. Every single line in the input file should consist of a valid lease number. 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.
• 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

         0987654321

         .

         .

         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 allows the user to employ an input file to accrue multiple leases
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 lease accruals up to the current date in the same way the Accrual [U0301] update does. It will also apply the rules applied to Accruals [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 four reports in the user's home directory:

• lp_util_###_a.rpt: Precomputed Income Accrual Register   
• lp_util_###_b.rpt: Simple Interest Accrual Register
• lp_util_###_c.rpt: Operating Lease Accrual Register
• lp_util_###_d.rpt: Accrual messages and exception report.

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

These report files will be similar to those generated by the Accruals [U0301] update except one difference. And that is the accrual register reports generated by this utility will not contain PCRO in their headers rather lease level data will be generated. It will also not generate office totals for a single lease because the program is processing individual lease which may or may not belong to one office.

The accrual messages and exception report will consist of two columns only. The first column will hold Lease Number whereas the other column will hold Exception Message. The messages will include the following:

• Lease does not exist: If the lease does not exist in database for the specified number.
• Invalid lease number: If an invalid lease number is found in the input file as mentioned above.
• Anyother message generated by the main accrual reversal program.