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
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
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 :)
*Community Hub is the new name for Sage City