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 – […]