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.

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.

Back to Utilities Menu

LeasePak  Documentation Suite

©  by NetSol Technologies Inc. All rights reserved.

The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.

Your document is loading...

This message should disappear within 5-15 seconds, depending on the size of the document and the speed of your connection to the Documentation Suite.

If you can still see this message after 20 seconds, try clicking the Refresh or Reload button on your Web browser.

If your document still does not load, refer to Document Load Troubleshooting for instructions on how to fix possible problems with either your Documentation Suite installation or Web browser setup.

If you do not have read access to the parent docsuite directory, you will not be able to load the Document Load Troubleshooting document. In this case, contact your network administrator for assistance.