OTBI Report with Payments Disbursements and Invoices with Invoice distribution

Summary

OTBI Report with Payments Disbursements and Invoices with Invoice distribution

Content

I am trying to create a report that shows only the invoice expense account distributions along with the Payment Check Number and payment dates using the Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real Time subject areas.

As soon as I filter by Expense Account type the check # and payment dates drop off the report. It looks as though those fields are only tied to the 'CASH', 'CASH_CLEARING', and 'LIABILITY' account types. Is there a way to see these payment details for only the Expense account type?