Mohammad Daoud delivers SQL code to help with Mismatched Inventory Quantities
Mohammad R. Daoud: Mismatched Inventory Quantities
Archived post from 2012. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.