Skip to Content
0
Former Member
Nov 15, 2012 at 08:37 AM

Logic for to get the Previous date Quantity

939 Views

Dear Experts,

We have developed one stock ageing report,There when ever you check it is showing present stock.

Ex:- if i am checking for one material 10 the present stock is 1598.383 TO as on date 15.11.2012

If i check the previous months date i.e 01.10.2012 that time also it is showing the same quantity 1598.383.,From 01.10.2012 to till date some receipts & Issues also done for the same material.

Present the quantity is picking from the MBEW table.

If i check MB5B there i can get the stock on date quantity,how can use the same logic to my issue.

I have checked the sdn but i haven't get the useful answer.

Please do needful to get the previous date quantity from the tables.

Regards,

Bhaskar