Forum Discussion

Toppler's avatar
Toppler
Icon for Helper I rankHelper I
3 years ago

Material stock

Hello all,

I hope you can help me.

I would like to display a stock history for our products. I have all the material movements for this. Behind each movement is the stock after the booking. I would now like to have the final stock of each day. The following is an example:

I would like to visualise the whole thing to be able to show a nice progression.
In addition, I would like to display the final stock of the previous day if the material is not used on a particular day.

New data should be like this:  

13.02.2023 10efse0043 37
10.02.2023 10efse0043 0
09.02.2023 10efse0043 9

08.02.2023 10efse0043 10

07.02.2023 10efse0043 10

06.02.2023 10efse0043 10

 

I hope you can help me.
Many thanks and best regards

Tobi

Need Help

3 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    3 years ago

    Hello Toppler ,

     

    Try adding an index column for all the transactions and visualise it as well in the table, so it will show every movement  seperately.

     

    If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

     

    Follow me on Linkedin

    • Toppler's avatar
      Toppler
      Icon for Helper I rankHelper I
      3 years ago

      I still do not quite understand
      I only want to have the line with the latest date and time.

  • Toppler's avatar
    Toppler
    Icon for Helper I rankHelper I
    3 years ago

     

    hello all,
    Unfortunately, I haven't made any progress yet.
    the diagram illustrates my problem again
    on days when i have no consumption, it also shows me no stock.