Confirm that he warehouse is "PT419 " - note there is a space after the warehouse. So not an ln baan user so I do not know if it is right or left justified. So once you confirm the warehouse is correct - run your query without whwmd215.qhnd <> 0 and make sure you get records. I assume that is quantity on hand and I am assuming there is at least one record in that warehouse where the quantity on hand is greater than 0. Not really sure you would have a negative on hand quantity but anything is possible with baan.
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.
systems provided free by Baan Board
Play the Google game and help Baanboard get better rankings. Do your part. Click here
to find how.