Find all Inventory Items with Current Balance is Less Than 1 To Reorder, – IBM Maximo

Its a simple trick to query all those record whose current balance is less or equal to 0. Its a good one to see whether we should run Reorder or not. 

Create a Save a Query with just a simple step.

1. Click on where Clause in Advanced search button, and paste given code in it and then press Save Query Button, Enter Name (for example CURR BALANCE), Description and hit Save.
2. Now Newly created query is displayed in your Action Menu. Just click on query name (CURR BALANCE in my case). 

inventoryid in (select inventory.inventoryid

from inventory

inner join invbalances

on inventory.siteid = invbalances.siteid

and inventory.itemnum = invbalances.itemnum

and inventory.itemsetid = invbalances.itemsetid

and inventory.location = invbalances.location

and invbalances.curbal < 1)