1 Reply Latest reply: Dec 6, 2014 3:18 PM by santosh lal RSS

    Stock ageing

    Joe Kirwan

      Hi

       

      I have a stocktake file showing quantity in stock per item:

       

      ItemStockQty
      A5
      B10
      C7

       

      I have a file of Stock Received showing quantity received by date for each item

       

      DateItemRefQtyIn
      03-JanA54973
      05-FebA53462
      31-MarA53862
      05-MarB50293
      12-AprB54425
      15-MayB52897
      12-FebC54013
      08-MarC53341
      09-AprC52675

       

      I want to age the items in stock in the stocktake file by listing the Stock Received trasnactions that make up thw stocktake quantity ie by making a new table like so:

       

      DateItemRefQtyIn
      03-JanA54971
      05-FebA53462
      31-MarA53862
      12-AprB54423
      15-MayB52897
      12-FebC54011
      08-MarC53341
      09-AprC52675

       

      So, the stocktake quantity for A is made up of the full receipt on 31-Mar and 05-Feb, and 1 of the quantity of 3 received 03-Jan.