Victoria Yudin offers a SQL view to verify unposted SOP transaction totals in Dynamics GP
SQL view to verify unposted SOP transaction totals in Dynamics GP | Victoria Yudin
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.