Victoria Yudin gives us a SQL view for total payments to 1099 vendors in the prior year
SQL view for total payments to 1099 vendors in the prior year | Victoria Yudin
SQL & DataPayables & ReceivablesYear-End & 1099
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.