Re - order Level

[Simon Glencross]

I am trying to incorporate a re-order level function within a database I am
designing and need some suggestion / advice....

I have a function "Onhand" which gives me my current stock total.

I have added a new field in to tblproducts called reorderlevel which is
where the user can enter a number at which reordering should take place.

e.g. StockTotal= 10 reoderinglevel =10 item ??????? needs to be reordered

Does anyone have any suggestions on this?

Thanks in advance...

 

[Barry Gilbert]

I think you'll need a report that shows all items that have fallen below the
reorder point. Base it on a query that joins the products table to the stock
balances table on the product number. In the criteria row, put a criterion
for the stock total field that says something like:
<= tblProducts.ReorderLevel

The query should show only those products whose stock is beloew the reorder
point.

Barry

 

[TonyT]

From a stock control point of view it would be more common to have a minimum
and maximum stock level whereby the part/component is only re-ordered when
the stock reaches or goes below the minimum amount, so if CurrentStockQty <=
MinStockLevel then OrderQty = MaxStockLevel - CurrentStockQty,

However having said all that more and more systems use History of useage and
weeks/days of stockholding allowing for Increased or Decreased 'weighting'
and bulk purchase quanities too.

TonyT.