1. Home
  2. Point-Of-Sale Software
  3. SQL query / Formula for Reorder Point?

SQL query / Formula for Reorder Point?

Is it possible to issue an SQL command(s) that would:

  1. Set the Restock Level for all items to be equal to the current on-hand quantity for each item.

  1. Set the Reorder point for all items to be equal to 1/3 of that items Restock Level.

I'm currently doing this manually, or using a formula in excel when items are initially imported into the DB, but there are still several thousand that need to be retro-fitted like this...

Thanx in advance!

-=RFM=-

Reply to
hitman
Loading thread data ...

UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)

UPDATE Item SET ReorderPoint=ROUND(RestockLevel/3,0)

- Evan Culver New West Technologies

hitman wrote:

Reply to
Evan Culver

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.