End of Period [U04]: Interactive Updates

This is part of the End of Period [U04] group. For an introduction to End of Period and links to all the End of Period documents, refer to End of Period [U04]: Overview.

 

 

Introduction

End of Period includes a group of interactive updates that can be used to submit, monitor, and administrate End of Period through the LeasePak client.

These updates can be accessed through the LeasePak Updates menu, End of Period option or by entering the updates' respective menu numbers into Fast Menu <F2>.

Option Descriptions

 

Submit [U0401]

The Submit update [U0401] is the first step in starting an End of Period (EOP) process. This update should be selected when the books for the day, month, and/or year are ready to be closed. The EOP process is executed separately for each portfolio, although all portfolios may be submitted at once through this update.

A normal EOP process is composed of several steps:

  1. EOP is submitted to a batch queue for later execution by a designated LeasePak operator at the close of the day, month and/or year, using the Submit update [U0401].

  2. Data files and other applicable files are backed up by a system operator.

  3. The administrator will usually have set EOP to begin processing after backups are completed. EOP automatically submits a batch job for each of the modules (updating/reporting) scheduled to perform. These batch jobs may be executed in parallel to better use the system's resources.

Notes:

Most LeasePak tracking modules should not be used while the EOP process [U0401] is executing, because EOP may change information about lessees, assets, and/or leases tracked. Accurate information would not be reflected in the tracking module used at the same time. The tracking module updates affected include:

U1101 Collection
U1601 Customer Service
U1201 Collateral
U1401 Maturing Lease

If tracking modules are purchased, all staff must exit the above updates before EOP begins executing. They may re-enter these updates when the EOP process is completed.

The Collection Initialization module, which is responsible for assigning and reassigning delinquent lessees to collectors, is not executed for each individual portfolio. It is executed once, after all submitted portfolios have completed processing. It is executed by the EOP End module [U0499] of the last portfolio to complete processing. If the Collection module is purchased, then portfolios may not be submitted for EOP with the Submit update [U0401] while the Collection Initialization module is executing. If the Collection Initialization module is going to be run during an EOP, then the End of Day Sequential Updates module [U0411] should be executed for all portfolios. Refer to the description of the EOP End module [U0499] for more information.

If the Batch Payments module is purchased and an input file of payments will be downloaded during EOP, a preliminary step is necessary before EOP is submitted. LEASE/UTIL 111 must be executed at the $ prompt from a supervisor's account. It may be executed before EOP begins, while users are still on the system. This utility sorts the payment input file by P/C/R/O so it can be efficiently processed by the EOP Batch Payment update [U0415]. It also creates a table of exception items that could not be processed.

The 1999 JULE Fund module will allow LeasePak the ability to accrue and invoice up to the actual month end when End of month is submitted prior to the actual month end date. LeasePak will allow a five day window to submit EOM.

 

This screen is used to select the portfolio(s) for which EOP is to be submitted. For convenience, all portfolios may be submitted at once. However, each portfolio is processed independently.

If the Multi-portfolio Security module is purchased, only users with unrestricted access may submit ALL. Users restricted to selected portfolios must submit EOP individually for each of the portfolios they may access. A message to that effect will display if ALL is selected.

If only one portfolio is available (i.e., the Multi-portfolio module is not purchased), that portfolio number displays and the user should press Return to continue.

 

This screen is used to select which EOP groups to submit. It appears if there are no updates in process for the portfolio(s) to be submitted. For every group in EOP (accruals, invoicing, end of day, month, and year), each portfolio to be submitted is displayed.

An EOP group is scheduled to execute if the NEXT DATE is on or before the current date. If any group is scheduled to execute, a default of Y is placed in the SUBMIT field. The user may change this to N if the group should not be submitted.

If Accruals and/or Invoicing were skipped for several days, the NEXT DATE shown is the first date they were skipped. When finally submitted, the accrual and/or invoicing process catches up all missed cycles as long as a full month has not passed. Scheduling accrual and invoicing cycles is controlled through the Predefined Cycles Customization option of the Portfolio update [U0212].

Field Descriptions

 

This screen is used to specify the submit status and the starting check numbers if cashier's checks and/or the check register are to be generated during this EOP process. More detail on statuses is found in the End of Period [U04]: Overview.

Field Descriptions

 

This screen is used to verify that these are the correct EOP jobs to submit.

Field Descriptions

 

Status Review [U0402]

The End of Period Status Review [U0402] shows the overall status of End of Period (EOP) process(es), separated by portfolio. This report may be used to monitor the status of any or all EOP processes while they are executing or to verify that EOP has completed. Information reported is:

 

This screen is used to select the portfolio(s) on which the End of Period Status Review should report.

Field Descriptions

 

End of Period Status Review

The End of Period Status Review [U0402] reports on End of Period modules and includes the following information:

 

Status Listing [U0403]

The End of Period Status Listing [U0403] shows current status for each module. It is useful when determining the impact of halting a module or skipping a failed module.

Information reported is:

 

This screen is used to select the portfolio on which the End of Period Status Listing should report.

Field Descriptions

 

This screen is used to select the module(s) on which to report.

Field Descriptions

 

End of Period Status Listing

The End of Period Status Listing [U0403] reports on End of Period modules and includes the following information:

 

Halt/Restart/Skip [U0404]

The Halt/Restart/Skip update [U0404] controls the End of Period batch queue. It may be used to:

If not performed properly, skipping modules may cause problems, including corrupted data. Therefore, before skipping a module, obtain a clear understanding of what the module does, especially analyzing any effects on its "children". For example, skipping an accrual cycle but continuing with the invoicing process causes the Invoicing update to invoice leases that have not been updated for the current billing month. In this case, both the accrual and invoicing processes should be skipped. Skipping other updates, such as the Vendor File Clean-up, does not have any adverse effect.

The Restart update [U0405] is a subset of the Halt/Restart/Skip update [U0404]. The Restart update [U0405] is designed for operators who may need to restart End of Period, but who are not responsible for determining whether modules may be halted or skipped. In general, security for users should be set so that neither of the 2 updates [U0404] or [U0405] is allowed, or only one is allowed, but not both.

For example, if there is a power failure while End of Period was executing, the End of Period process must be restarted after power is restored. This may be performed by any user with the security to enter the Restart update [U0405], and does not require the additional authority for the Halt/Restart/ Skip update [U0404]. However, if a module of End of Period failed due to another type of error, a supervisor or someone familiar with LeasePak and its processes would be needed to restart End of Period with the Halt/ Restart Skip update [U0404]. This person must determine whether the module should be restarted or skipped and recovered.

 

This screen is used to enter the portfolio of the module to be halted, restarted, or skipped.

 

This screen is used to specify the batch queue status changes (i.e., halting, restarting or skipping) for the End of Period modules of the portfolio selected. The name of the portfolio is displayed and should be verified as correct before making any changes.

Note: The CURRENT STATUS displayed for each module is valid only for the CURRENT STATUS AS OF date and time displayed in MM/DD/YY or DD/MM/YY format, depending on the Date Format Preference field in Security [U0706]. To view the up-to-the-minute status, cancel back to screen 1 of this update and re-enter this screen.

Field Descriptions

 

This screen is used to verify that the batch queue changes entered on the previous screen are correct.

Field Descriptions

 

Restart [U0405]

The Restart update [U0405] resubmits a stopped module (or modules) to the End of Period batch queue. A stopped module may have been stopped intentionally by a supervisor or may have failed due to some program error or external circumstance (e.g., power failure).

The Restart update [U0405] is a subset of the Halt/Restart/Skip update [U0404]. The Restart update [U0405] is designed for operators who may need to restart End of Period, but who are not responsible for determining whether modules may be halted or skipped. In general, security for users should be set so that neither of the 2 updates [U0404] or [U0405] is allowed, or only one is allowed, but not both.

For example, if there is a power failure while End of Period was executing, the End of Period process must be restarted after power is restored. This may be performed by any user with the security to enter the Restart update [U0405], and does not require the additional authority for the Halt/Restart/ Skip update [U0404]. However, if a module of End of Period failed due to another type of error, a supervisor or someone familiar with LeasePak and its processes would be needed to restart End of Period with the Halt/ Restart/Skip update [U0404]. This person must determine whether the module should be restarted or skipped and recovered.

 

This screen is used to enter the portfolio of the module to be restarted.

 

This screen is used to specify the End of Period modules to be restarted for the portfolio selected. The name of the portfolio is displayed and should be verified as correct before making any changes.

Field Descriptions

FAILED DUE TO ERROR
HALTED BY SUPERVISOR
POSTPONED - PARENT MODULE FAILED
POSTPONED - PARENT MODULE HALTED

A restart of all modules restarts all necessary End of Period modules to complete End of Period. This is often an easy and safe way to restart End of Period. However, failed modules may require a correction of some type before they can successfully finish.

 

This screen is used to verify that the list of modules to be restarted, as entered on the previous screen, is correct.

Field Descriptions

 

Print/View Reports [U0406]

The Print/View Reports update [U0406] offers immediate access to reports which reveal the results of End of Period processes. One portfolio's reports may be viewed or printed at a time.

When parameters are established for portfolios on the End of Period Customization option of the Portfolio update [U0212], the user designates which reports will print, how many copies, etc. The on-line Print/Review Reports update [U0406] allows a user to access a report not designated for printing on [U0212], or to view reports on line as soon as End of Period is complete.

Note: Considerable time may be required to run a requested report and display it on the screen.

 

The next screen is a menu of the reports or groups of reports which may be produced with this update.

Field Descriptions

Use the links above to learn more about these reports.

Use the links above to learn more about these reports.

 

This screen appears to require the user to enter a portfolio for the requested report(s). Only one portfolio's reports may be generated at a time through this interactive process. Use Help for a list of all portfolios.

 

Next appears a list of all reports that fall into the category selected (e.g., End of Day, End of Month).

To print or view all reports on the list for the selected portfolio, enter X in the ALL field at the top of the screen. An X will appear next to each report that will be produced.

If only one of the listed reports is desired, tab to that report and select it by entering X next to the report name.

If data for a report is not available from the most recent End of Period, the notation "<not found>" appears in the right-hand column on this screen. These reports may not be selected.

Press ENTER to print or view the report(s) selected. If multiple reports were selected for viewing, press ENTER or click the Done button to proceed to the next report.