U04 End of Period

U0411 Sequential Updates

For more information about End of Period,
refer to U04 End of Period Overview.

Sequential Updates: This EOP module runs as the first stage of Sequential Updates.

These are the three stages of Sequential Updates:

• U0411 Sequential Updates – This first stage also runs the various other EOP modules that run as part of Sequential Updates
• U0412 Sequential Updates Post-Processor
• U0413 Sequential Updates Post-Merge

The Sequential Updates module combines many different modules, all of which require a sequential read through LeasePak's data files in order to complete their functions. In other words, each module must process all rls Lease records and all req Asset records in the portfolio.

LeasePak will track the lease payment history in the RLS and the RHS for a total of twenty-four months when the Credit Bureau Interface is purchased.

When Sequential updates is active and all Portfolio are submitted to End of Period, the Deficiency Portfolio must contain leases. If no leases are present, EOP will fail. LeasePak will allow the Deficiency portfolio to run EOP independently with the Sequential updates active.

Some of these individual modules execute as part of the End of Day process and some as part of End of Month.

Grouping individual modules into Sequential Updates is done to reduce processing time for End of Period by limiting the number of "passes" through the database. That is, instead of reading through the database up to 14 times for each of the 14 individual functions that may be required, a single pass through the database is performed with up to 14 functions performed on each record as accessed.

Additional performance improvement may be obtained through the multi-process count parameter. The portfolio is segmented into a number of parts equal to the multi-process count, thereby allowing simultaneous processing on each part. Refer to the End of Period Multi-Process Count on the first screen of the End of Period Customizations option of U0212 Portfolio. This method may not always enhance performance, however. Contact your NETSOL representative for assistance in determining whether this method should be used.

When EOP runs, Sequential Updates generates an account balances XML data file that can be found in the $udata directory with file name p#_account_balances.xml (where p # is the portfolio number). The account balances includes gross receivable balances, net outstanding balances, and gross outstanding balances selected from U0212 Portfolio→Calculation Customizations. Each EOP the xml file will be replaced with a new file if one already exists. The account balances XML data file will consist of the following elements: