Re - order Level "Simon Glencross" <simon.glencross[ at ]sg.consultancy.co.uk> 24.09.2006 14:34:17 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...

RE: Re - order Level Barry Gilbert 24.09.2006 14:56:01 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 "Simon Glencross" wrote: [Quoted Text] > 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... > > >

RE: Re - order Level TonyT 24.09.2006 17:12:01 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. "Simon Glencross" wrote: [Quoted Text] > 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... > > >