Cash Control Payment History [R0926]
The Cash Control Payment History Report is part of the Cash Control module and the Partial Deductions module, separately purchased modules of LeasePak. The report provides a trace reference code to show when and where the payment or payment reversal transactions were entered into the system.
The report will display all payment and payment reversal records for the lease based on the Check Payment Master (RPM) and the Check Payment Detail file (RPN). The trace reference number will consist of the Payment Origination code and the batch payment numbering system from the Cash Control [U0126] module.
The origination code along with the payment batch number will also be displayed in the Suspense Review Report [R0203], when the Cash Control module has been purchased.
Payment Origination
Payment Origination codes are based upon the cash transaction’s four digit code, in order to identify the source of the payment or payment reversal. LeasePak has hard-coded fifteen Payment Origination codes and additional codes may be user defined.
All of LeasePak’s batch programs will contain four-character default codes beginning with ‘LB’, as part of the origination code. The remaining two characters will be according to the LeasePak update as follows:
- LBBP BATCH PAYMENT
- LBPR BATCH PAYMENT REVERSAL
LeasePak payment and payment reversal updates will contain four-character default codes beginning with ‘LP’, as part of the origination code. The remaining two characters will be according to the LeasePak update as follows:
- LPAP ASSUMED PAYMENT
- LPBK BOOK LEASE
- LPBR PAYMENT NUMBER REVERSAL
- LPCC CASH CONTROL
- LPDD PAYMENT DUE DAY CHANGE
- LPLX LEASE EXTENSION
- LPPA PAYMENT
- LPPX PAYMENT EXTENSION
- LPRS PAYMENT RESCHEDULE
- LPSU SUSPENSE
- LPBR REBOOK
For Cash Control, LeasePak automatically assigns a unique 20-digit batch number to each check applied. It is later possible to display all the line item amounts paid by a check on the Cash Control Batch Number Payment Reversal update [U0102], even if they are from multiple leases and/or invoices.
The Batch number changes when a new check number is entered. Batch numbers assigned by LeasePak are made up of 20 digits:
6 digits for current date (YYMMDD)
6 digits for each payment session
8 digits for each check
For example, the trace reference for a payment made on a lease at the time of booking, will display as follows:
LPBK/98040390000800000001
The Cash Control Payment History report will display or hide all payment origination transactions based on the DISPLAY IN R0926 switch set in the Module Customizations option of the Portfolio [U0212] update.
Additionally, the Auto-Reapply Payment Reversal enhancement, allows non-IBL Batch Payment Reversals to be reapplied when a payment reversal is processed out of order. LeasePak will automatically reverse all payments with the effective date equal or greater than the effective date of the payment being reversed and automatically reapply the payments in order (oldest invoice due date first) and according to the payment hierarchy for all lease payments (non-IBL).
-
Payments are reapplied according to the payment hierarchy established in the Assessment Customization option of the Portfolio [U0212] update.
-
The RPN record will be deleted and replaced with the new record (current IBL behavior).
LeasePak reverses all the sub-sequent batches and then reapplies the total reversed amount from the batches to the most outstanding invoice first. The following rules apply:
-
If the batch number reversed is for a single lease with one or multiple invoices and the subsequent batches contain invoices for the same lease number and the effective date is equal to or greater, batch payments will be reversed and reapplied.
-
If the subsequent batch has a different lease number or multiple lease numbers, the batch is skipped.
-
If any of the subsequent batch numbers have cash received for security deposit or a deferral fee during a Payment Reschedule [U0104], the batch is skipped.
-
If multiple batches for the same lease and same effective date are reversed in Batch Payment Reversal [U0306] or Batch Payment Reversal [U0470], it will process each batch number at a time.
- If the order of reapplication is different from the original payment order-reversals will be made to all qualified, subsequent batches according to Payment Effective Date, and all invoices in the subsequent batches will be placed in outstanding status.
Payments are reapplied according to Invoice Due Date . Therefore, if the original payment in any batch applied to invoices that are not in order, i.e. payment not made to invoice with older due date first; the new payment order may be different from the original.
This enhancement shifts the batches upwards, moving the Batch Payment Effective Date. Because the amount from one subsequent batch may or may not be enough to cover the invoices from a previous batch; the final total number of batches may differ from original number of batches.
Note: If the batch number that is being reversed contains multiple lease numbers, LeasePak will display a warning message: “No reversal and reapply for multiple lease batch.”
Note: This enhancement will support “TMSA” Reversal Reason code. If the Reason Code is “T***” type code, it will be treated as a “TMSA” reason code. If “TMSA” is used, the auto reverse and reapply of batches will execute first. LeasePak will ask the user where to reapply the payment. This enhancement does not apply if the Reversal Reason code is “TRAN”.
Selection Screens
This screen is used to select the output of the report. Options will vary depending on output settings.
This screen is used to enter the lease number for which the report will default all transaction information.
Enter the lease number and click OK. The following screen will appear.
This screen is used to select the view in which the report will display the payment history for the lease selected.
Field Descriptions
- COMPANY (M) OR CUSTOMER (S)
OUTPUT
Enter ‘M’ for Company mode to be displayed, or enter ‘S’ for the Customer mode to be displayed. The LeasePak default value is ‘M’.The Company (M) mode will display all pertinent information trace information, applied date, invoice/credit memo or the operator initials.
The Customer (S) mode will only display the following information: regarding the trace information and transaction details of the lease
- SEND THE OUTPUT AS LETTER
Y/N
Select ‘Y’ for the Cash Control Payment History report to send the output file to the letter module, the data will be stored in both the RLT and the new MLT file.
The LeasePak default value is ‘N’, this will not send the output file as a letter.
Cash Control Payment History Report
The Cash Control Payment History Report provides the following information when
the Company (M) mode is selected in the second screen of the Cash Control Payment
History report.
- CHECK NUMBER
The check number for the lease is displayed.
- TRACE REFERENCE
The Trace Reference is displayed for the lease. The Payment Origination code associated with the lease is based on the transactions made to the lease in the following updates:
- New Lease [U0101]: Book Lease
- Payments [U0102]
- Payment Reschedule [U0104]
- Payment Extension [U0107]
- Lease Extension [U0108]
- Suspense [U0109]
- Rebook [U0116]
- Payment Due Day Change [U0118]
- Cash Control [U0126]
- Batch Payments [U0305]
- Assumed Payments [U0414]
- Batch Payments (EOP) [U0415]
- APPLIED DATE
The applied date of the transaction is displayed.
- EFFECTIVE DATE
The effective date of the transaction is displayed.
- DUE DATE
The payment due date is displayed.
- INVOICE/CREDIT MEMO NUMER
The invoice/credit memo number is displayed.
- OPERATOR INITIALS
The operator initials are displayed.
- TRANSACTION TYPE
The transaction type details are displayed.
- AMOUNT
The amount of the transaction is displayed.
- DAYS LATE
The total number of days late is displayed.
- REVERSAL REASON
The reversal reason code is displayed when the DISPLAY IN R0926 switch set in the Module Customizations option of the Portfolio [U0212] update is set to Y. If this switch is set to N, the Cash Payment History Report will not display the Reversal Reason Codes.
Customer Mode
This screen is displayed when the Customer mode (S) is selected to be displayed.
- CHECK NUMBER
The check number is for the lease is displayed.
- EFFECTIVE DATE
The effective date of the transaction is displayed.
- DUE DATE
The payment due date is displayed.
- TRANSACTION TYPE
The transaction type details are displayed.
- AMOUNT
The total amount of the transaction is displayed.
- DAYS LATE
The total number of days late is displayed.
- REVERSAL REASON
The reversal reason code is displayed when the DISPLAY IN R0926 switch set in the Module Customizations option of the Portfolio [U0212] update is set to Y. If this switch is set to N, the Cash Payment History Report will not display the Reversal Reason Codes.
Auto Reapply Payment
The following report examples display the various scenarios described for Auto Reapply Payment for Batch Reversals in this document and those described in Batch Payment Reversal [U0102].
Example 1
This report displays the original payment transaction.
Check #
Applied Date
Effective Date
Due Date
Invoice
OPR
Type
Amount
030626TEL
672.30
TRACE REF: LPCC/030709900000002
6/25/03
4/13/03
22214722
T18
Sales/Use Tax
1.50
6/25/03
6/13/03
23927529
T18
Payment
300.81
6/25/03
7/13/03
24698652
T18
Payment
30.08
6/25/03
6/13/03
23927529
T18
Sales/Use Tax
19.55
6/25/03
5/13/03
23068962
T18
Sales/Use Tax
19.55
6/25/03
5/13/03
23068962
T18
Payment
300.81
030708W
688.00
TRACE REF:LPCC/030709900000002
7/8/03
2/13/03
20557192
T18
Late Charge
15.04
7/8/03
8/13/03
20557192
T18
Pre
352.60
7/8/03
5/13/03
23068962
T18
Late Charges
15.04
7/8/03
7/13/03
24698652
T18
Sales/Use Tax
19.55
7/8/03
6/13/03
23927529
T18
Late Charges
15.04
7/8/03
7/13/03
24698652
T18
Payment
270.73
This report displays the reversal of the original batch record. If check #030626TEL is reversed by T19 on 7/10/03, only the reapplied batch will display the reapplied record.
Check #
Applied Date
Effective Date
Due Date
Invoice
OPR
Type
Amount
672.30
TRACE REF: LPCC/030709900000001
TRACE REF: LPBR/030709900000001
TRACE REF: LBBP/030709900000002
Example 2
This report displays the batch reversal for check #1135,also reversing check #6613,check #6585 will not change.
Check #
Applied Date
Effective Date
Due Date
Invoice
OPR
Type
Amount
385.03
TRACE REF:LBBP/03041807040672572827
TRACE REF: LPRR/03041807040672572827 TRACE REF: LBBP/03041807040672572827 TRACE REF: LPRR/03041807040672572827 TRACE REF: LBBP/03041807040672572827
TRACE REF: LBBR/03041807040672572827 TRACE REF: LPRR/03061690000100000075 TRACE REF: LPCC/03061690000100000075 TRACE REF: LPPA/03061690000100000075 6613 TRACE REF: LPCC/0307099000060000000 The reversal of checks #1135 and #6613 will appear reversed by operator T19 on 7/10/2003. Additionally, if check #6585 is reversed, the check totals for #1135 and #6613 will be applied to the most outstanding invoice.
Check #
Applied Date
Effective Date
Due Date
Invoice
OPR
Type
Amount
40.00
TRACE REF: LPBR/03061690000100000075
TRACE REF: LPRR/03061690000100000075 TRACE REF: LPCC/03061690000100000075 TRACE REF: LPPA/03061690000100000075 6613 TRACE REF: LPBP/03070990000600000001 TRACE REF: LBP/03070990000600000001
Example 3
This report displays a payment item or all items in check #030525TEL reversed. The entire check will be reversed including check #65987. The total amount reapplied is equal to the entire amount of check #030525TEL and check #65987 minus the amount of the reversal items. Payments will be reapplied to the most outstanding invoice first; invoice due 4/28/03, the new invoice with a 5/28/03 due day and then invoice due 5/28/03.
Check #
Applied Date
Effective Date
Due Date
Invoice
OPR
Type
Amount
661.42
TRACE REF: LBBP/03052409800947294976
TRACE REF: LPRR/03052409800947294976 TRACE REF: LPPA/03052409800947294976 TRACE REF: LPRR/03052409800947294976 TRACE REF: LBBP/03052409800947294976 TRACE REF: LPPA/03052409800947294976 TRACE REF: LPBR/03052409800947294976 65987 TRACE REF: LPCC/03070990000800000001
LeasePak Reference Guide
©
by McCue Systems Incorporated. All rights reserved.
The information contained in this document is the property of McCue Systems, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. McCue Systems, Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of McCue Systems, Inc. is prohibited.