6 Replies Latest reply: Oct 23, 2013 2:57 AM by Deviprasad Navik RSS

    calculation of openning qty from closing qty for next day?

      Hi All

       

      I am having a table which has details of material, their closing quantity and date.

      so daily this closing quantity is moving and I want to store their closing quantity as a opening quantity for next day.

      Can anybody provide any logic/approach.

       

      I have attached the sample data where input table is a having material, quantity and Date,

      Pls check output table where I have to show opening quantity from previous closing quantity.

       

      Thanks In advance