U04 End of Period

U0459 General Ledger Pool

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

General Ledger Pool: This EOP process requires the General Ledger Pool optional license module.

This module is an EOP process to update the General Ledger Pool (rgp table). Also, to initialize the values in RGP table when this EOP process runs first time. This EOP will process all the records saved in the RTX table since the last EOP completion for each lease. It will also process the RTX records created since the last EOP run completed without a lease number by processing each General Ledger (RGL). This EOP process produces a general ledger pool interface scratch file. To run this EOP user must turn on and initialize this module through U0212 End of Period Customizations. Initialization of this module can be determined by the General Ledger Pools initialization field.

NOTE: To run this EOP users must purchase Pool ID module.

Turned on in U0212 and initialized

Users can turn this process on through U0212 End of Period Customizations and initialize it. Once the process is turned on and initialized LeasePak will perform the following process:

This EOP will first process each lease from the RLS Lease table. For each lease this EOP selects all the transactions from general ledger RTX table which values are greater than the date and time when last general ledger pool run date and time stored on that specific lease’s record in RLS table.

Once this EOP selects all the records of RTX table, EOP calculates the amounts of change for each general ledger account and updates the RGPC general ledger pool accounts where the lease’s pool ID should be equal to the general ledger pool ID. If the pool ID does not exist in (RGP) General Ledger Pool table at the time of update LeasePak will create a new RGP record for the pool ID at the time of update. After processing when the general ledger pool accounts update completes it will assures that the lease has been updated for the current date and time to record the occurrence of the general ledger pool update. EOP process will proceed to the next lease for processing. If EOP breaks in the middle of the process, or restarted, no transactions will be stored to the general ledger pool account twice.

After processing each lease, EOP will process each RGL General Ledger record. This assures that the general ledger transactions without a lease number are also accounted for. In the same way lease numbers processed through RLS lease table. The process proceeds through each RGL and then update the last general ledger pool update fields on the RGP general ledger pool where the pool ID is blank.

While the EOP processes RGL records, it will select the blank lease number for given PCRO all transactions of table rtx greater than the last general ledger pool update run date and time. For selected transactions EOP will check for the assets if there are any asset number attached to a lease, EOP will use that asset level pool ID for transaction to a general ledger pool account, otherwise EOP will assume the pool ID blank. EOP will proceed in the same way it proceeded for lease transactions and updates the last general ledger pool update date and time on the RGP table with blank pool ID when processing for specific PCRO completes.

If the General Ledger Interface module is purchased, this process will end by creating a set of general ledger pool scratch files same as the current functionality of U1003 General Ledger Interface creates. The U1003 General Ledger Interface creates a scratch file for each portfolio by extracting data from the RGLC General Ledger Account table. See U1003 General Ledger Interface for more details.

This process will create a scratch file for every portfolio by extracting data from the new rgpc General Ledger Pool Account table. This new set of scratch files will consist of fixed width text records. Each record in the new scratch files will be of 128 bytes long. Following is the format of the new scratch file:

Name: DSGP_P??.DAT

where ?? is the number of the portfolio.

All fields are converted to a string format before being written to the file. The format is as follows:

Example

An example of a numeric signed value is 00000012649053+. The first fourteen characters are the dollar value, multiplied by 100. In this example, the actual dollar value is $126,490.53. The fifteenth character is either a plus (+) if the value is positive or a minus (-) if negative.

NOTE: To run this EOP user must purchase General Ledger Pool module.

Turned on in U0212 but not initialized

LeasePak will perform the following process if this EOP is turned on through U0212 End of Period Customizations but has not been previously initialized:

This process initializes the RGP General Ledger Pool and RGPC General Ledger Pool Accounts tables and populates the new RLS Lease fields for date and time of last general ledger pool update.

The initialization process creates RGP General Ledger Pool records in the same manner the RGL General Ledger records for the specific selected portfolio with a blank pool ID. It will set the and the date of last general ledger pool update equals to the date of previous EOD completion and time of last general ledger pool update equals to the time of previous EOD completion. Each (RGPC) general ledger pool account record must take on the same values of the (RGLC) general ledger account for the following fields: debit, credit, debit M-T-D, credit M-T-D, balance, and general ledger account type – credit or debit. Also the new General Ledger Pools Initialized flag will be turned on.

NOTE: If it is purchased, this module runs during End of Period. If it is skipped after partially running, the Zero Daily General Ledger Pool Accounts update should also be skipped. Otherwise, when the interface is later run, the current day’s totals may no longer be available for extract.