Why Stock Balance Quantity In Search Windows Different To Stock Inquiry?

Created by Faradyana Azman, Modified on Fri, 18 Dec, 2020 at 3:10 PM by Faradyana Azman

In the search stock windows, the below stock balance is 42.

When inquiry stock, the balance shows 41.

Causes: Missing a script during the cross upgrade process from old version.

Solution: Please execute the below script from the QNE management tools. After that resave the last transaction for the item to refresh the stock balance in search windows.

ALTER TRIGGER UPDATESTOCKBALANCEAFTERUPDATE ACTIVE;