on 10-13-2008 5:48 AM
Dear All,
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 .
Hi
If you need a immediate workaround then peform the below steps
Cancel this material document: (return delivery to vendor Mvt Type 122 w.r.t. Material Document generated @ first GR . Qty returned = 9units) -MIGO
Then perform the return delivery to vendor Mvt Type 122 w.r.t. Material Document generated @ second GR . Qty returned = 9units (ie document where GR @ 30) - MIGO
Hope this is resolve the MAP variation.
Regards,
Ravindran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
1 First GR = 100 pcs
2 Goods Issue = 100 pcs @ 20 = 2000
3 GR for 10 pcs @ 30 = 300
4. Goods return reference to Step 1 GR i.e 20 per peice.
5. The remaining stock is 1 pc and this 1 pc basing GR from step 3 i.e @ 30
This is the reason the system showing 1 pc as 120. The moving average price is automatically adjusted basing on the available quantity and stock value. If you have done material return reference to GR in step 3.
Regards,
Syed Hussain.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.