cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong MAP

Former Member
0 Kudos

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 .

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member318507
Active Participant
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Hussain,

Actually specking MAP Rs.120 is false representation.Actual MAP must be Rs.30.Is it nessary to create new vt type for reversal of good issue.This is because when we do reversal of goods issue it takes latest MAP. aBOVE PROBELM IS ONLY DUE to that.Please give solution.

Former Member
0 Kudos

can any body hv solution for above problem