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
Sybase users: 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.
Oracle users: this field is set to 'N' and not available.
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 | |||||||
| 7/09/03 | 6/25/03 | 4/13/03 | 22214722 | T18 | Sales/Use Tax | 1.50 | |
| 7/09/03 | 6/25/03 | 6/13/03 | 23927529 | T18 | Payment | 300.81 | |
| 7/09/03 | 6/25/03 | 7/13/03 | 24698652 | T18 | Payment | 30.08 | |
| 7/09/03 | 6/25/03 | 6/13/03 | 23927529 | T18 | Sales/Use Tax | 19.55 | |
| 7/09/03 | 6/25/03 | 5/13/03 | 23068962 | T18 | Sales/Use Tax | 19.55 | |
| 7/09/03 | 6/25/03 | 5/13/03 | 23068962 | T18 | Payment | 300.81 | |
| 030708W | 688.00 | ||||||
| TRACE REF:LPCC/030709900000002 | |||||||
| 7/09/03 | 7/8/03 | 2/13/03 | 20557192 | T18 | Late Charge | 15.04 | |
| 7/09/03 | 7/8/03 | 8/13/03 | 20557192 | T18 | Pre | 352.60 | |
| 7/09/03 | 7/8/03 | 5/13/03 | 23068962 | T18 | Late Charges | 15.04 | |
| 7/09/03 | 7/8/03 | 7/13/03 | 24698652 | T18 | Sales/Use Tax | 19.55 | |
| 7/09/03 | 7/8/03 | 6/13/03 | 23927529 | T18 | Late Charges | 15.04 | |
| 7/09/03 | 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 |
|---|---|---|---|---|---|---|---|
| 030626TEL | 672.30 | ||||||
| TRACE REF: LPCC/030709900000001 | |||||||
| 7/9/2003 | 6/25/2003 | 4/13/2003 | 22214722 | T18 | Sales/Use Tax | 1.50 | |
| 7/9/2003 | 6/25/2003 | 6/13/2003 | 23927529 | T18 | Payment | 300.81 | |
| 7/9/2003 | 6/25/2003 | 7/13/2003 | 24698652 | T18 | Payment | 30.08 | |
| 7/9/2003 | 6/25/2003 | 6/13/2003 | 23927529 | T18 | Sales/Use Tax | 19.55 | |
| 7/9/2003 | 6/25/2003 | 5/13/2003 | 23068962 | T18 | Sales/Use Tax | 19.55 | |
| 7/9/2003 | 6/25/2003 | 5/13/2003 | 23068962 | T18 | Payment | 300.81 | |
| TRACE REF: LPBR/030709900000001 | |||||||
| 7/10/2003 | 6/25/2003 | 4/13/2003 | 22214722 | T19 | Sales/Use Tax Reversal | -1.50 | |
| 7/10/2003 | 6/25/2003 | 6/13/2003 | 23927529 | T19 | Payment Reversal | -300.81 | |
| 7/10/2003 | 6/25/2003 | 7/13/2003 | 24698652 | T19 | Payment Reversal | -30.08 | |
| 7/10/2003 | 6/25/2003 | 6/13/2003 | 23927529 | T19 | Sales/Use Tax Reversal | -19.55 | |
| 7/10/2003 | 6/25/2003 | 5/13/2003 | 23068962 | T19 | Sales/Use Tax Reversal | -19.55 | |
| 7/10/2003 | 6/25/2003 | 5/13/2003 | 23068962 | T19 | Payment Reversal | -300.81 | |
| 030708W | 688.00 | ||||||
| TRACE REF: LBBP/030709900000002 | |||||||
| 7/10/2003 | 7/8/2003 | 2/13/2003 | 20557192 | T19 | Late Charges | 15.04 | |
| 7/10/2003 | 7/8/2003 | 4/13/2003 | 22214722 | T19 | Sales/Use Tax | 1.50 | |
| 7/10/2003 | 7/8/2003 | 5/13/2003 | 23068962 | T19 | Payment | 300.81 | |
| 7/10/2003 | 7/8/2003 | 5/13/2003 | 23068962 | T19 | Sales/Use Tax | 19.55 | |
| 7/10/2003 | 7/8/2003 | 5/13/2003 | 23068962 | T19 | Late Charges | 15.04 | |
| 7/10/2003 | 7/8/2003 | 6/13/2003 | 23927529 | T19 | Payment | 300.81 | |
| 7/10/2003 | 7/8/2003 | 6/13/2003 | 23927529 | T19 | Sales/Use | 19.55 | |
| 7/10/2003 | 7/8/2003 | 6/13/2003 | 23927529 | T19 | Late Charges | 15.04 | |
| 7/10/2003 | 7/8/2003 | 7/13/2003 | 24698652 | T19 | Payment | 0.66 | |
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 |
|---|---|---|---|---|---|---|---|
| 6585 | 385.03 | ||||||
| TRACE REF:LBBP/03041807040672572827 | |||||||
| 4/18/2003 | 4/18/2003 | 5/11/2003 | 23013675 | EOP | Payment | 17.78 | |
| TRACE REF: LPRR/03041807040672572827 | |||||||
| 6/17/2003 | 4/18/2003 | 4/11/2003 | 22156579 | T18 | Sales/Use Tax | 29.34 | |
| TRACE REF: LBBP/03041807040672572827 | |||||||
| 4/18/2003 | 4/18/2003 | 4/11/2003 | 22156579 | EOP | Sales/Use Tax | 29.34 | |
| TRACE REF: LPRR/03041807040672572827 | |||||||
| 6/17/2003 | 4/18/2003 | 4/11/2003 | 22156579 | T18 | Payment | 355.69 | |
| TRACE REF: LBBP/03041807040672572827 | |||||||
| 4/18/2003 | 4/18/2003 | 4/11/2003 | 22156579 | EOP | Payment | 337.91 | |
| TRACE REF: LBBR/03041807040672572827 | |||||||
| 6/17/2003 | 4/18/2003 | 4/11/2003 | 22156579 | T18 | Sales/Use Tax | -29.34 | |
| 6/17/2003 | 4/18/2003 | 5/11/2003 | 23013675 | T18 | Payment Reversal | -17.78 | |
| 6/17/2003 | 4/18/2003 | 4/11/2003 | 22156579 | T18 | Payment Reversal | -337.91 | |
| 1135 | 40.00 | ||||||
| TRACE REF: LPRR/03061690000100000075 | |||||||
| 6/17/2003 | 6/13/2003 | 5/11/2003 | 23013675 | T18 | PMT Extension Fees | 40.00 | |
| TRACE REF: LPCC/03061690000100000075 | |||||||
| 6/16/03 | 6/16/2003 | 108547 | T18 | Suspense | 40.00 | ||
| TRACE REF: LPPA/03061690000100000075 | |||||||
| 6/17/2003 | 6/13/2003 | 108547 | T18 | Suspense Reversal | -40.00 | ||
| 6613 | 305.03 | ||||||
| TRACE REF: LPCC/0307099000060000000 | |||||||
| 7/9/2003 | 6/13/2003 | 6/11/2003 | 24657351 | T18 | Payment | 305.00 | |
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 |
|---|---|---|---|---|---|---|---|
| 1135 | 40.00 | ||||||
| TRACE REF: LPBR/03061690000100000075 | |||||||
| 7/10/2003 | 6/13/2003 | 5/11/2003 | 23013675 | T19 | Payment Extension Fees | -40.00 | |
| TRACE REF: LPRR/03061690000100000075 | |||||||
| 6/17/2003 | 6/13/2003 | 5/11/2003 | 23013675 | T18 | Payment Extension Fees | 40.00 | |
| TRACE REF: LPCC/03061690000100000075 | |||||||
| 6/16/2003 | 6/13/2003 | 108547 | T18 | Suspense | 40.00 | ||
| TRACE REF: LPPA/03061690000100000075 | |||||||
| 6/17/2003 | 6/13/2003 | 108547 | T18 | Suspense Reversal | -40.00 | ||
| 6613 | 305.03 | ||||||
| TRACE REF: LPBP/03070990000600000001 | |||||||
| 7/10/2003 | 6/13/2003 | 5/11/2003 | 23013675 | T18 | Payment Extension Fees | 40.00 | |
| TRACE REF: LBP/03070990000600000001 | |||||||
| 7/10/2003 | 6/13/2003 | 6/11/2003 | 24657351 | T19 | Payment | 265.03 | |
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 |
|---|---|---|---|---|---|---|---|
| 030525TEL | 661.42 | ||||||
| TRACE REF: LBBP/03052409800947294976 | |||||||
| 5/24/2003 | 5/24/2003 | 5/28/2003 | 23482434 | EOP | Payment | 25.00 | |
| TRACE REF: LPRR/03052409800947294976 | |||||||
| 7/9/2003 | 5/24/2003 | 4/28/2003 | 22303003 | T18 | Payment | 633.23 | |
| 7/9/2003 | 5/24/2003 | 109259 | T18 | Suspense | 25.00 | ||
| TRACE REF: LPPA/03052409800947294976 | |||||||
| 7/9/2003 | 5/24/2003 | 5/28/2003 | 24993596 | T18 | Payment Extension Fees | 25.00 | |
| TRACE REF: LPRR/03052409800947294976 | |||||||
| 7/9/2003 | 5/24/2003 | 4/28/2003 | 22303003 | T18 | Sales/Use Tax | 3.19 | |
| TRACE REF: LBBP/03052409800947294976 | |||||||
| 5/24/2003 | 5/24/2003 | 4/28/2003 | 22303003 | EOP | Sales/Use Tax | 3.19 | |
| 5/24/2003 | 5/24/2003 | 4/28/2003 | 22303003 | EOP | Payment | 633.23 | |
| TRACE REF: LPPA/03052409800947294976 | |||||||
| 7/9/2003 | 5/24/2003 | 109259 | T18 | Suspense | -25.00 | ||
| TRACE REF: LPBR/03052409800947294976 | |||||||
| 7/9/2003 | 5/24/2003 | 5/28/2003 | 23482434 | T18 | Payment Reversal | -25.00 | |
| 7/9/2003 | 5/24/2003 | 4/28/2003 | 22303003 | T18 | Sales/Use Tax Reversal | -3.19 | |
| 7/9/2003 | 5/24/2003 | 4/28/2003 | 22303003 | T18 | Payment Reversal | -633.23 | |
| 65987 | 636.43 | ||||||
| TRACE REF: LPCC/03070990000800000001 | |||||||
| 7/9/2003 | 7/2/2003 | 6/28/2003 | 24993597 | T18 | Payment | 633.23 | |
| 7/9/2003 | 7/2/2003 | 6/28/2003 | 24993597 | T18 | Sales/Use Tax | 3.19 | |
Security Deposit Held in Payoff/Termination
If the security deposit for the lease was held in suspense during payoff or termination, the report will display something similar to the following:
Run date: 2/03/ Time: 9:24am QA TEST PORTFOLIO Page 1
Report : R0926 Quality Assurance LEASEPAK UX -
User ID : WINGSL CASH CONTROL PAYMENT HISTORY
Lessee NAME: BOB DURHAM SELECTED Lease: 2
CHECK APPLIED EFFECTIVE DUE INVOICE NUMBER OPR TRANSACTION AMOUNT DAYS REVERSAL
NUMBER DATE DATE DATE /CREDIT MEMO TYPE LATE REASON
---------- --------- --------- -------- -------------- --- --------------------------------- -------------- ---- --------
1117 3,500.00
TRACE REF: LPSD/04020390000300000001
2/03/04 2/03/04 WSL SECURITY DEPOSIT -3,500.00 0 TRAN
2/03/04 2/03/04 221 WSL SUSPENSE 3,500.00
For more information about placing the security deposit in suspense during payoff or termination, refer to Holding Security Deposit in Payoff/Term (P/T/B/N) in Portfolio [U0212], Payoff Customizations.
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.