The items do not show up as being in stock, but they do show as being on order for that location.
You can also report all open S/R lines with CR or Excel reports using a query like this:
Code:SELECT i.bkar_inv_sonum, l.bkar_invl_asd, i.bkar_inv_cuscod, i.bkar_inv_cusnme, l.bkar_invl_pcode, l.bkar_invl_pdesc, l.bkar_invl_ooqty
FROM ISSRINV i INNER JOIN ISSRINVL l
ON i.bkar_inv_sonum = l.bkar_invl_invnm
WHERE i.bkar_inv_invcd = 'S'
AND l.bkar_invl_ooqty > 0
AND l.bkar_invl_um_ln_1 BETWEEN '1' AND '99'
ORDER BY i.bkar_inv_sonum
We use this to create a report that shows S/R#, Date In, Customer #, Customer Name, Product #, Product Name, and Qty