Use the function called IN_GetAssInventoryByWhsItem() to find the current inventory for any Item in Assistics for a given warehouse. The parameters are Warehouse, Item, and Pack,
example
SELECT dbo.IN_GetAssInventoryByWhsItem ('LCSF','85049','')
note that since this is a Purchased Product, the Pack is blank and should be specified as ''.