Victoria Yudin has a new SQL view for sales quantities by customer by item by year
SQL view for sales quantities by customer by item by year | Victoria Yudin
SQL & DataPayables & ReceivablesSales, Purchasing & Inventory
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.