What Needs to be Ordered Today?

There is a ROP (Re-Order Point) column on parts file. You can set this column to the minimum quantity you have to stock in your inventory. A simple sql statement like the following can show the items that are below the ROP quantity and need to be ordered.

SELECT partnumber, description, onhand, rop, rop - onhand AS ordqty
FROM parts
WHERE onhand < rop AND inventory_accno_id IS NULL ORDER BY partnumber

You can run this sql statement in psql, phpPgAdmin or build a new report using our custom report template.

Leave a Reply