Mahmoud AlSaadi provides a SQL Script for Reconciling Quantity on Hand
Dynamics GP Essentials: Reconciling Quantity on Hand – SQL Script
SQL & DataDevelopment & IntegrationGeneral Ledger & Financials
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.