Reporting subledger modules to GL with transaction detail

Summary:

We're looking for a report that provides information from subledgers into the GL in an Excel like format. For example, we need the project number, expenditure type, expenditure organization, task number to display in a report when these details are entered into the AP module and then posted to the GL. We understand we can drill into each line of the GL to see some of this information but that's time consuming and does not allow for analysis.

Content (please ensure you mask any confidential information):

Ideally we could ensure all project related details are included with a vendor invoice when processed in the AP module and/or each transaction in the GL has the associated PPM information but that's not the reality. We know there are transactions associated with certain cost centers that SHOULD have POET details included. We need to be able to identify what transactions may be missing this information. However, we also have many transactions where were project details should not be included. We want to see all transactions in one report.