Victoria Yudin has a new SQL view for Dynamics GP SOP line items with serial numbers and comments
Dynamics GP SOP line items with serial numbers and comments | Victoria Yudin
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.