Summarize Approved Invoices by University Account Number and Date Range

This is used by Cornell Accounting. 

For Cornell, this report summarizes invoices by vouchers for a specific date range. Data elements needed invoice ID, invoice number, invoice amount, voucher ID, voucher status (paid), voucher number, and ledger. Need to bring in the transactions derived table. Important to keep transaction amount with currency in case international currencies used. Verification for invoice control - standard Library Accounting Voucher

Also, provide a summary listing of pending invoices at any point in time; used to accrue invoices that have not yet been approved (voucher status = awaiting payment). In-app doesn't provide by group and by account number.