David Musgrave has a great look at a SQL view that works in SQL Management Studio but doesn’t work in a SmartList Builder view. David shows us the cause and the fix.
SmartList Builder based on SQL View not returning data
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.