Hi Carol,

Unfortunately, displaying the Qty On Hand field in the Item Inquiry grid vs. the Smart Finder Grids and vs. the Item Valuation Report gives inconsistent results. Here's what I believe is causing you grief:

<> The Item Valuation Report correctly reports items with negative quantities
<> The Item Inquiry grid showing Qty On Hand also correctly shows the items with negative quantities
<> However, if you launch the Smart Finder, add Qty On Hand to the grid and ask for Qty On Hand less than 0.00 it finds nothing

Reason: My findings indicate that the Smart Finder, though told to use "Qty On Hand" seems to be using "Qty on Hand 1".

Therefore, if you have a situation whereby the TOTAL quantity for some items are < 0 but the quantity on hand for Lot 1 for ALL items are => 0 - the Not-So-Smart Finder will find nothing.

If your user has GridView you could use that to get the results you want in grid form but I suspect you really wanted the Smart Finder to do it so that you could the Drill down to the inquiry windows to investigate the items further.

Not much we can do about that until Softrak gives us the fix - Let's hope they read this post :-)

Regards, Peter