title: How to calculate Inventory in Maximo Query
body: <p>I'm having a hard time calculating or getting the right values for the inventory in maximo.</p>
  
  <p>Required fields are:</p>
  
  <ol>
  <li>Item </li>
  <li>Description</li>
  <li>Default Bin</li>
  <li>Issue Unit</li>
  <li>Current Balance</li>
  <li>Hard Reserved Quantity Not Staged</li>
  <li>Hard Reserved Quantity Shipped</li>
  <li>Total Quantity Shipped</li>
  <li>Expired Quantity in Stock</li>
  <li>Quantity Available</li>
  <li>Quantity Currently Reserved</li>
  <li>Hard Reserved Quantity</li>
  <li>Soft Reserved Quantity</li>
  <li>Quantity Staged Quantity in Holding Location</li>
  </ol>
  
  <p>Missing fields:</p>
  
  <ol>
  <li>Hard Reserved Quantity Shipped</li>
  <li>Total Quantity Shipped</li>
  <li>Expired Quantity in Stock</li>
  <li>Quantity Available</li>
  <li>Quantity Currently Reserved</li>
  <li>Hard Reserved Quantity</li>
  <li>Soft Reserved Quantity</li>
  <li>Quantity Staged  Quantity in Holding Location</li>
  </ol>
  
  <p>here is my partial query: </p>
  
  <pre><code>select 
     inventory.orgid,
     inventory.siteid,
     inventory.location,
     inventory.itemnum,
     item.description,
     invbalances.binnum 
     (select sum(invbalances.curbal) from invbalances),
     (Sum (INVRESERVE.RESERVEDQTY)) - Sum (INVRESERVE.STAGEDQTY) as HardReservedQuantityNotStaged,
     Sum (INVRESERVE.SHIPPEDQTY) as HardReservedQuantityShipped 
  from inventory 
  inner join ITEM on item.itemnum = inventory.itemnum 
  left outer join INVBALANCES on item.itemnum = invbalances.itemnum 
  left outer join INVRESERVE on item.itemnum = invreserve.itemnum 
  left outer join ASSET on item.itemnum = asset.itemnum
  where inventory.itemnum = '11453'
  group by inventory.orgid, inventory.siteid, inventory.location,inventory.itemnum, item.description, invbalances.binnum
  </code></pre>
  
  <p>Can anyone help me how to get the values of the missing fields?</p>