Mohammad Daoud ran up against an odd inventory scenario that reconcile wouldn’t fix so he built his own fix in Inventory Reset - Average Item receipt QTY on hand does not equal IV QTY on hand.
His script has been added to the giant pile of SQL Scripts.