Hi Marion,

Adagio Payables stores statistical information on current year and last year transactions on the vendor records, but not for any years prior to last year.

If you keep transaction history for Payables longer than 2, 3 or more years before purging, then you could create a GridView inquiry on the History file to determine which desired transactions are in the appropriate year(s) and get the Top20 from that. This inquiry would be a lot slower to run and would depend on whether history information still exists and has not been purged.

If you have backups of your Payables data from prior years, or at least copies of the Top 20 vendor lists, you could run your GV inquiry on that and export the results of your Top 20 vendors from older years to an Excel spreadsheet. Then create a new GV view based on the Excel file and connect that into your current view as part of a workspace. Only if you wanted to combined current/last year results with older results.