Old applied Payments printing on statements
I printed the statement for a customer with statement date as : 31-MAR-2016.
I should not see the 4th record printed on the statement. 12777777 is an applied and cleared payment and was done in 2013. why is this printing.
any clues please?
thanks
| Invoice # | transaction type | Trx Date | due date | trans reference | trans amount | Amount due |
|---|---|---|---|---|---|---|
| 1 | Invoice | 02/01/2016 | 02/01/2016 | 1000.00 | ||
| 2 | Invoice | 03/01/2016 | 03/01/2016 | 1000.00 | 1000.00 | |
| 3 | Payment | 03/11/2016 | Misc. Manual Rect: 13888888 : 1000.00 | (1000.00) | ||
| Payment | 11/30/13 | Misc. Manual Rect: 12777777 : 780.00 | (17.22) | (17.22) |