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.2. 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=-

SQL query / Formula for Reorder Point?

Aug 28, 2005 1 Replies

Rate this thread:

hitman 20 years ago

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

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

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=-

Vote

Evan Culver 20 years ago

UPDATE Item SET RestockLevel=(Quantity - QuantityCommitted)

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

- Evan Culver New West Technologies

hitman wrote:

Vote

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required