Error in MIRO - Moving Average price for the Material is negative?

[Former Member]

Hi,

We have created a Purchase Order where in we wrongly entered the CHA Charges as 3,309.00 USD, which was actually 3,309.00 INR.

We did the Goods Receipt.

While doing the MIRO for CHA with actual amount i.e. 3,309.00 INR, the system is giving the following message:

Moving Average price for the Material is negative.

What is the solution/ way around to rectify the same.

Regards,

[Former Member · Accepted solution]

Follow as below

1. issue the remaining goods to cost center using 201 mov type - MB1A

2.Now post the invoice in MIRO

3. Now cancel the goods issue document

this is the SAP recommends

[Former Member]

hi,

i think this is due to price change while knocking off from PO and GRN.............

so first check have they change price in PO after posting GRN.

If yes in this you need to empty the stock and do MIRO.

Regards,

Rajendra D. Sawant.

[Former Member]

Hi,

Can we follow the following steps as suggested by Raja Ramasamy

1. Issue all the Materials to Cost Center

2. Do the MIRO

3. Reverse the Good Issue (Step 1)

Is there any Issue in doing the above?

Regards,

[Former Member]

Simulate the same scenario in testing environment and do as per the above suggestions .Then implement in production.I dont think any problem will come

[Former Member]

Hi,

What Raja said, for this you have to do teh setting for price difference(PRD) as mentioned before. As the difference in price has to go to some account as per accounting rule.

as in GR you have the accounting entry:

Stock A/c Dr

GR/IR clrng A/c Cr

Freight clearing A/c Cr (3309 USD)

In IV (MIRO)

If Stock is available,

Vendor A/c Cr

GR/IR A/c Dr

Freight Clearing Dr (3309 INR)

Stock A/c Cr (3309 USD X Exch.rate - 3309 INR)

If no Stock is available,

Vendor A/c Cr

GR/IR A/c Dr

Freight Clearing Dr (3309 INR)

Price difference A/c Cr (3309 USD X Exch.rate - 3309 INR)

I hope it clarified your querries.

Regards

[Former Member]

Hi,

Plz cancel the GR and check the moving average.

Mark for deletion for the line item in PO and make another line item with correct data and take the GR and IR.

[Former Member]

Hi,

Thanks for the reply.

Is there any alternate.

In our case, the Material has been sold out, hence we can't do the GR Reversal.

Regards,

[Former Member]

Hi,

Since the stock has been moved out, it is not able to update the material valuation due to difference of amount between GR & IR. Hence you are getting the error.

Best way as of now is to take the difference to price difference account (PRD) and carry out the adjustment of this price end of the period.

Regards

[Former Member]

Hi,

Thanks for the reply.

Is there any alternate.

Out of the 15 Qty of a Material, 8 Qty is sold out and we are left with 7 Qty, hence we can't do the GR Reversal of the Complete Document.

The system is giving the following message:

Deficit of BA Unrestricted-use 8 EA : FVG02999 1000 1000 1000002702

Regards,

[Former Member]

Hi,

Have you completed the billing for Sold Material. In not reverse the PGI, then reverse the GR. Then correct the PO and perform GR and the then the sales process. This is the best option.

Else you can do this but not advisable as its impact is unknown.

You set this material as "negative stock allowed"in the said plant and reverse the GR. then modify the PO and do the GR again. after completing the proces you can remove the "negative stock allowed" indicator.

Regards