LeasePak Utilities

237 Create Check Disbursal File

Creates an extract file of all pieces of information that appears on the U0117 Cashier's Check Register including both checks and reversals for any checks that have been voided since they were initially disbursed. It produces an XML file which can further be transformed into an appropriate format and used for different purposes.

The utility should run after the EOP is completed and U0117 Cashier's Check Disbursal is done for the day. It can also be scheduled to run by using EOP Suite.

Below is an example of using this utility:

This utility option will create an XML file with all of the checks printed for a given day and any checks that were voided that day. 
Do you wish to continue (Y/N)?

Enter 'Y' to proceed. The program will display:

Client Password?

Enter the correct LeasePak client string password to proceed. The program will display:

Enter the check print date (YYMMDD), <RETURN>  to exit 

Enter a valid date in the YYMMDD format for the utility to continue. An invalid date will result in the message "Invalid date" and return the user to the same input request.
You can also enter a future date. The utility will then accept the date and generate a file with no records because no rck records will exist for the date yet.
Upon entering a valid date, the program will start extracting the required information from rck table and display the following message on completion:

Generating check file for date = YYMMDD
nn.. checks extracted in XML file

where YYMMDD is the date entered in the previous prompt and nn.. is the number of check records extracted in that final output file.

The utility will select all rck records that meet the following rules:

• s_status_c = “P” and d_printed_s = input check print date

or

• s_status_c = “V” and d_dis_s = input check print date and d_dis_s <> d_printed_s and d_printed_s is not null

Each selected record will consist of the following pieces of information from the rck record.

Portfolio	rck.por_s
Company	If rck.dck_flag_c = 0 use rck.lse_pcro_s to populate this field.  The value will either come from this field if populated with the PCRO or if populated with the lease number from looking up the lease number in rls for the PCRO. Else blank
Region	Same as Company
Office	Same as Company
Lease	If rck.lse_pcro_s is populated with a lease number, use that, otherwise leave blank.
Lessee Number	If rck.lse_pcro_s is populated with a lease number, use that to look up the rls.les_s, otherwise leave blank.
Lessee Name	If the Lessee Number above is populated, use that to look up the ral.nam_long_s, otherwise leave blank.
Bank Account	rck.bank_s
GL Account	rzga.number_s where rck PCRO and bank_s equals rzga PCRO and unique_l
Bank Check Number	rck.client_chk_s
LP Check Number	rck.chk_s
Status	rck.s_status_c       P – Paid       V – Void
Asset	rck.unit_s
Serial Number	req.id_s if the rck.unit_s is not blank, lookup id_s using the unit_s, otherwise leave blank
Manufacturer	req.mnf_s if the rck.unit_s is not blank, lookup mnf_s using the unit_s, otherwise leave blank
Model	req.mdl_s if the rck.unit_s is not blank, lookup mdl_s using the unit_s, otherwise leave blank
Payee Type	rck.dck_flag_c       0 – Lessee       1 – Customer       2 – Vendor       3 – Broker or Investor       4 – Investor Settlement
Client ID	If rck.dck_flag_c > 0 then rck.dck_seg3_s else If the first 10 characters of rck.dck_seg3_s concatenated with rck.dck_seg4_s is not null, use that value (which is the lease number) to look up the lessee (rls.les_s where rls.lse_s = the lease number) else Blank/Null
Payee Name	rck.nam_s
Payee Address	rck.add_s
Payee Address 2	rck.add2_s
Payee City	rck.cty_s
Payee State	rck.st_s
Payee Zip	rck.zip_s
Source of Check	rck.cash_check_typ_s
Reference	rck.ref_s
Date Printed	rck.d_printed_s
Date Disbursed	rck.d_dis_s
Amount	rck.amt_d

The program will not use the U0712 Custom General switch 'Consolidate A/P Checks'. There is no check consolidation in the output file.

The utility will extract the required information from rck table to an XML file called "lp_util_###_YYMMDD.xml" in the directory the utility was run from. The ### in the file name represents the number of the utility and YYMMDD is the print date for which the utility was run.

For accurate results, no additional runs of U0117 Cashier's Check Disbursal should take place (either interactively or through EOP) once this utility is run and no one should void any checks. If the utility is run more than once for the same day, the program will overwrite the previous XML file.

LeasePak allows the user to run this utility in the past date, but this should only be used to recreate a file that was lost or to check that it was complete.