QtyOnWO doesn't match open WOs

Question

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

Ramon M. · Accepted 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 :)

Sage 500

QtyOnWO doesn't match open WOs

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING