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.
lbarnesJul 12, 2021Hello 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.
jhoborJul 13, 2021I 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
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.
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