I'm trying to create a view in search in Item Maintenance that would have the system display the total quantity available by, in a new field, subtracting from IM_ItemWarehouse.QuantityOnHand, IM_ItemWarehouse.QuantityOnSalesOrder and IM_ItemWarehouse.QuantityOnWorkOrder. See:
However, I can confirm that the output of this calculation is always equal to the TotalQuantityOnHnad, and that IM_ItemWarehouse.QuantityOnSalesOrder and IM_ItemWarehouse.QuantityOnWorkOrder are always equal to zero.
How would I get a calculation for the total quantity available on hand as a value in search results?