AOI inXL has an option to pull ledger transactions from Dimensions or Financials in to Microsoft Excel. Once the data is extracted you can then use the data to do your own analysis/reporting using normal Excel functions.
To run a Transaction Enquiry, do the following:
In Excel, click on the ACCESS INXL option in the main menu bar
Click on Enquiry in the Transaction Enquiry menu section
In the Dataset field, select the source data connection you wish to use
For Period, select the From and To year/periods as required
In the Ledger field, select the source ledgers you wish to extract transactions from
In the Transaction field, select the types of transaction you wish to extract
Click Next
In the Transaction Enquiry - Filter by Codes, Categories and Sort Keys window, you can click the Nominal, Costing, Resources, Stock, Customer and Suppliers tabs to specify addition selection criteria a desired
Click Finish
A window will appear showing the number of transactions being selected and the results will be loaded in to a new sheet called TransEnquiry