2 Replies Latest reply: Dec 5, 2014 7:38 AM by Kavita Vishwakarma RSS

    values should be same, if there is no value in change for missing months.

    Kavita Vishwakarma

      Please help me with the solution where the where stock should be same for every month for material M001 till there is no movement in stock(QTY).

      In ex. there is no movement in stock from april month but still i want to see the previous updated stock till the current month as shown in table1:


      Year

      Month

      Material

      Qty

      Cost

      2014

      Aug

      M001

      2

      1204

      2014

      Sep

      M001

      2

      1204

      2014

      Oct

      M001

      2

      1204

      2014

      Nov

      M001

      2

      1204

      2014

      Dec

      M001

      2

      1204

      but i am getting output as table 2 .when i select material M001 it show only Aug data for 2014 which is 2.i have tried peek and previous function. but still not getting correct output.


      Year

      Month

      Material

      Qty

      Cost

      2014

      Aug

      M001

      2

      1204



      Note:The values are not updated in the database itself.