LeasePak Utilities

238 Forecasting Report Lease Detail

Generates all forecasting reports for a given or all portfolio(s) with output to a comma delimited csv file. Unlike the standard report files being produced by R0112 Forecasting Report process, the utility will:

• Organize data by lease and output in a comma delimited csv file.
• Give each lease's information separately instead of summarizing the data at PCRO level.
• Give the exact number without rounding the dollar amount up to the thousand of dollars.

The user must own Forecasting Report module to access this utility.

Below is an example of using this utility:

This utility option will generate all forecasting reports for a given portfolio and output lease level detail to csv files.
Do you wish to continue (Y/N)?

Enter Y to continue. The program will display:

Client Password?

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

Do you wish to run for all portfolios (Y/N), <RETURN> to exit?

Enter Y if you want to process all the portfolios together in the same way as the program processes R0112 for all portfolios with "ALL" check box selected. In this case, the program will skip the next coming prompt.

Enter N to proceed to the next prompt: The program will display:

Enter in the portfolio, <RETURN> to exit:

Enter a valid portfolio number. An invalid portfolio will result in the message “Invalid portfolio entered.” and return the user to the same input request. This prompt will be displayed if the user enters N to the previous prompt.

Enter Accrual Cycle <M> for Monthly, <W> for Weekly, <B> for Bi-weekly, <S> for Semi-monthly <RETURN> to exit:?

Enter one of the required option to process forecasting report

Generating forecasting files for portfolio: nn 

where nn is the portfolio number.
The system will display the above message with the actual portfolio number being processed when only one portfolio is selected to run the job.
The system will modify the above message to read as follows when the forecasting report is selected to run for all portfolios.

Generating forecasting files for all portfolios.

If the user enters a blank, or presses return in response to any of the above prompts, the program will exit the utility and return the user to the server command line.

All other report selection parameters for running the R0112 Forecasting Report will not be input but instead will default as follow:

Field	Default Value
Lease Type	blank
Vendor	blank
Investor	blank
Manufacture	blank
Model	blank
Number of Months to Runoff	360
Report on True Leases	Y
Report on Operating Leases	Y
Report on CSA's	Y
Leveraged	Y
Cash Report	Y
Earnings Report	Y
Balances Report	Y
Time Axis	H
State Sorting	N

The first line of each final csv file will contain a header line with the names of the data elements separated by commas as follows:

Report, Report Run Date, Year, Portfolio, Company, Region, Office, Lease, Mos Runoff, Due Day, Description, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Total

All of these data elements are found on the standard R0112 Forecasting Report except for the Lease and the Due Day. Furthermore, the conditions applied to the R0112 Forecasting Report will also apply to the output of this utility.

The system will not include the R0921 Month-to-Month Leases report in the output of this utility.

The system will generate Cash Runoff, Earnings Runoff, and Balances Runoff report files with names "lpr0112a.csv", "lpr0112b.csv", and "lpr0112c.csv" respectively and save them in the user's home directory. Upon running the utility multiple times, the system will overwrite the output files in the user's home directory if any remain as a result of prior running of the utility.

If user owns Vervent Custom Modules module, then the output report file name would be "p#_lpr0112a/b/c.rpt". Where # is portfolio number.