Apparently Ian Grieve is holed up in a cave somewhere writing SQL ’cause he’s pumping it out like there’s no tomorrow. His latest is a SQL View To Allow Customer/Item Link In SmartList Builder
SQL View To Allow Customer/Item Link In SmartList Builder
Archived post from 2015. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.