LeasePak Utilities

232 Master G/L Reconciliation report

Provides a way for users to run the Master General Ledger Reconciliation Report [U0460] outside of End of Period. Below is an example of using this utility:

This utility runs the U0460 Master G/L Reconciliation report.

Note: to ensure accurate output for this report, NetSol recommends that the user run 
U0460 Master G/L Reconciliation normally through End of Period.

If users must run the report through this utility, post-EOP processes and/or individual 
users must not update certain LeasePak tables between the running of End of Period and 
the running of this report. These tables include the rls Lease and req Asset tables. 
Contact your NetSol representative for a complete list of tables affected.

Do you wish to continue (Y/N)?

Users will need to enter Y to continue. The program will display:

Client Password?

Users will need to enter their LeasePak client string password. The program will display:

Enter the portfolio number (<RETURN> to exit)>

Users will need to enter a valid portfolio. The utility will run the report for this portfolio. If the value of either ras.d_prev_cmplt_day_s or ras.t_prev_cmplt_day_s is NULL, the program will display:

End of Period has not yet populated the previous End of Period completion date and time. 
You will need to enter these manually.
Enter the previous End of Period completion date (YYMMDD) or <RETURN> to exit>

Users will need to enter the previous completion date in YYMMDD format. The program will display:

Enter the previous End of Period completion time (HHMMSS) or <RETURN> to exit>

Users will need to enter the previous completion time in HHMMSS format. If End of Period has already populated ras.d_prev_cmplt_day_s and ras.t_prev_cmplt_day_s, the program will display:

Previous End of Period completion date and time is <YYMMDD> <HHMMSS>.

where YYMMDD is the date and HHMMSS is the time. The program will continue:

Do you want to enter in a new date/time (Y/N), <RETURN> to exit>

If the user enters Y, the program will prompt for a date and then time as follows:

Enter in the previous EOP completion date (YYMMDD), <RETURN> to exit> 
Enter in the previous EOP completion time (HHMMSS), <RETURN> to exit> 

The user will either press Enter to exit the program after each or enter the appropriate date and time to continue. For "Do you want to enter in a new date/time", if the user enters N, the program will use the date and time from the previous end of period and continue without prompting for new values. The program will continue:

Enter in the multi-process count <1 - 40>, <0> to exit

The default value is always 1. Users with High Volume will be able to enter a value between 1 and 40. The program will display:

Generating the Master G/L Reconciliation report for:
Portfolio                         : nn

where nn is the portfolio number.

Using RTX records starting from: Mmm dd, yyyy, hh:mm__

where Mmm dd, yyyy is the date and hh:mm__ is the time (12-hour am/pm format).

Multi-Processing

If the users enter a value greater than 1 for the number of processes to use, the program will use the specified number of processes to traverse the LeasePak tables, collect the relevant data, and build the general ledger history scratch file, then use a single process to produce the Master G/L Reconciliation Red Alert and Imbalance reports.

Report Output

Once the report is complete, the program will display:

Processing complete. The Red Alert (lpu0460a.rpt) and Imbalance (lpu0460b.rpt) reports 
are in the directory from which the script was run.

and return users to the LeasePak Utilities menu. Users can view and print these reports interactively in LeasePak using R0929 Print/View User Reports.