7 Replies Latest reply: Jan 10, 2018 4:30 PM by Haidar Haj Ali RSS

    Stock movement synthesis in table

    Haidar Haj Ali

      Hello,

       

      I have the following structure of table to log in the stock movement:

         

      MVTITEMSTOCKMVT DATE
      INITEM 1STOCK 101/01/2017
      INITEM 2STOCK 101/01/2017
      INITEM 3STOCK 201/01/2017
      OUTITEM 1STOCK 115/01/2017
      INITEM 1STOCK 215/01/2017
      INITEM 4STOCK 116/01/2017
      INITEM 5STOCK 116/01/2017
      INITEM 6STOCK 220/01/2017
      OUTITEM 5STOCK 128/01/2017

       

      And I need to display a table with the actual Items of my stocks, any idea ?

       

      So results of data above may be as following:

       

      STOCKITEM
      STOCK 1ITEM 2
      STOCK 1ITEM 4
      STOCK 2ITEM 3
      STOCK 2ITEM 1
      STOCK 2ITEM 6

       

      Thanks a lot for your help.