subsitute summary payables posted invoice register

 HI 

Is there any other report we can run as substitute of payables posted invoice register.  (For a specific period).

We need the totals (debit-credit) Accounted Amount for reconciliation.

Or is there a query i can use to pull up debit and credit amounts for previous period.