I had following situation:
1.GR QTY =100 @ Rate Rs.20/Unit MAP = Rs.20/Unit Total Inventory value = Rs.2000
2.GI QTY =100 MAP = Rs.20/Unit
3.New GR Qty =30 @Rate:Rs.30/Unit MAP = Rs.30/Unit
So stock in hand = 10 Unit Total Inventory value = Rs.300
Now I had done return delivery to vendor Mvt Type 122 w.r.t. Material Document generated @ first GR . Qty returned = 9units
So Value of stock remains ( 1030 -920 ) = 300-180 = Rs. 120
Now stock in Hand = 1 Unit While MAP = Rs. 120 Which gives erroneous pictyre about MAP.
How to get correct MAP .