Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See this blog post: How to populate a sparsely populated field
Hello,
Thanks for the reply.But unfortunately in my case, there's no date.
I have tried with possible solutions but couldn't achieve yet.
Kindly see the attachment and revert back.
Thank You!! !