Victoria expands on her previous SQL view and now gives us a SQL view for last sale date of item .
SQL view for last sale date of item | Victoria Yudin
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.