Prepayments and open cash do not appear as line items on the aged creditors/aged accounts payable (detailed) report.
Although the total for the account is shown only the open invoices (and credit notes) are showing.
i.e. Where open cash the total does not agree with the detailed lines