Dynamics GP - Get Serial Numbers for current stock in a location

select * from iv30400 where itemnmbr in (select itemnmbr from iv00102 where locncode = 'F-S' and QTYONHND <> 0)