Adagio

The Vendor Transactions can contain the information we're looking for:

It can be accessed by selecting Vendor Transactions from the Reports | Transaction and Analysis

Reports menu.

Select the types of transactions you want included in the report. Include All types.

Select Detail by document in Format

In Transactions from, select the date 4 years previous to today's date and in to, select today's date

Sort by Vendor Name.

Leave Sub and ph fields blank

Select G/L disbursement details in the Included in Report section

Print destination should be file

Run the report, it should create a file, CSV or Text is preferred if the option is given. In some versions a PDF or Excel file is also an option, both work, however in some systems the excel file does NOT contain the distribution of the invoice we require and sometimes Excel limits to 16384 lines and as a result a lot of transactions are not stored in the Excel file. If this is the case it is recommended to split the export by year, or even half year depending on the amount of transactions, to make sure that each Excel file has less than 16384 lines.