Victoria Yudin shows off a SQL view for Dynamics GP vendors with last activity date This is nice for cleaning out vendors.
SQL view for Dynamics GP vendors with last activity date | Victoria Yudin
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.