Cancelled invoices in Trial Balance
I am having a problem with cancelled prepayments in the trial balance. I payed a prepayment on 01-Sep-2010 and cancelled the payment and the prepayment today (7-sep-2010) but with a cancelled date of 01-Sep-2010. When I run the Trial Balance with "as of date" 01-Sep-2010 it appears the cancelled prepayment with cancelled date 7-sep-2010, a status of not payed and a remaining amount equal to the total of the prepayment.
How does this work?
How can I make the prepayment not appear on the Trial Balance or make it appear with a remaining amount of 0 in the Trial Balance as of 01-Sep-2010?