QtyOnWO doesn't match open WOs

SOLVED

I've got an item showing QtyOnWO as -42, but don't have any open WOs or pending transactions.

I seem to remember that there was a SQL SP to clean up this kind of situation.

Any suggestions?

thanks

  • 0
    verified answer

    There is a generic fix for this called spDF_RecalcQtyOnWO.  You may wish to contact your reseller or Sage support to see how to get this.  I have reason to believe that at least one cause of this issue has be resolved in the upcoming v2015 release of Sage 500 :)