Steps to create issue
. Create a new Physical Inventory Line
. Enter Product A
. The Book Qty will be retrieved and displayed
. Enter the Count Qty
. Now change the Product to B
. Complete the transaction
. Product B is now updated with the difference between the Book Qty of Product A and the Count Qty entered.
The user can avoid this issue if they realise that the Book Qty for product B has not been retrieved when they changed the Product code. However there is no fail safe mecjhanism to alert the user to the fact that the result of their action will cause an error.
It would be preferable to take steps that prevent this from happening. One alternative is to alert the user whenever they change the Locator or Product that the book qty is no longer valid and requery the database to display the Book Qty for the new product as at the time of the change. Another alternative would be to prevent them from changing either the Product or Locator and force them to delete the line and reenter with the new product.