It looks like the closest to what we need is the 'Supplier Balances' report.  This has everything in there including the payments but can be output as a spreadsheet for further processing.

I'm looking for a transaction report which shows all the supplier transactions in a single report.  Ideally it would have columns showing net, vat and gross amounts for the transactions.

Does anyone have such a report or any SQL which will produce this sort of report?

Thanks,

Kevin B