Is there a dataspy we can run to see what parts are below the min qty? I didn't see anything available in the parts screen.
Thanks jhobor. I will give it a try!
I have an Inbox set up for "Parts At or Below Reorder Points", here is the select statement:
select count(1)
from r5parts where par_code in (select sto_part from r5stock where sto_qty <= sto_ordlev and sto_store ='AB-EL' and sto_ordlev != 0)
Then I have the inbox associated to the "All Parts" dataspy with a filter:
par_code in (select sto_part from r5stock where sto_qty <= sto_ordlev and sto_store ='AB-EL' and sto_ordlev != 0)
Hello Heather - This would require an “advanced" dataspy filter. Another option would be to run the generate requisitions screen for auto-generated reqs, and just preview the list and/or export it.