AP Prepayment recociliation with GL Balance

Hi All,

We are trying to  reconcile AP Prepayment total with GL Account. I wrote  a query below and the total does not match with the GL Balance (Prepayment a/c).

Is there any standard report(s) available for reconciliation or can some one give input onto how to do the reconciliation.

Thanks

Regards

Subramani

----Query-

 select invoice_num
     ,to_char(invoice_date) inv_date
  ,pv.segment1 vendor_num
  ,pv.vendor_name
      ,invoice_amount amount
   ,duepayment damount
from ap_invoices_all aia,
     (select invoice_id,sum(nvl(amount,0)) Duepayment
    from ap_invoice_distributions_all aid
      where 1=1
     --invoice_id = 13438
        and REVERSAL_FLAG is NULL