GR/IR account postings

[Former Member]

Hi SAPers.

I am testing a scenario here whereby,

I make a PO of 1500 MT with a net price of 1183 per unit.

then I do gr for 750,250 and 500 respectively.

then a different user does the MIRO but while doing MIRO for 500 he keys in 5000 instead of 500 in quantity.

My invoice price amount remains the same but my GR/IR  gets debited with 1,116,293.83,price diff cr 524,793.83 and vendor Cr 591500.

I am also able to pay the vendor the full amount for the 1500 MT as per the PO price.

Why was this possible and how can I resolve this?

Regards

JM

[former_member197616 · Accepted solution]

Hi,

Yes system will post the GRIR account as per the qty and invoice amount entered ..though the amount to go to the vendor is as the amount to get paid , the per unit price at invoices varies and this will come into the picture when you post the remaining GR . This is an unwanted situiation and gives scope for MR11 issue and the GL accounts clearing .

what you need to do .

Reverse the invoice posted wrongly without clearing it , and post the correct invoice with correct quantity as a corrective step .

As a preventive step check the tolerances / invoice blocks at OMR6 and activate the respective keys for the company code so that system will stop there itself without getting posted .

Regards,

[Former Member]

Thanks for your help experts.. I really appreciate. I have been able to provide better configurations to my system in testing phase.

Regards ,

Joe

[BijayKumarBarik]

Hi,

Why you allow invoice more than PO quantity and value with GR in place- You can restrict by  message setting as Error.

Refer thread which already discussed.

https://scn.sap.com/thread/1880679

Regards,

Biju K

[Former Member]

Patra

yeah I agree...

the scenario was triggered by internal audit so i am looking for all avenues of explanation since cancelling and reversing documents is one of the major issues they wish to minimize in the system.

I really appreciate your help. Please be free to avail me with any other ideas you may have since we would wish to tally the amounts penny for penny since payment was done in foreign currency ie 591500 especially price difference amount.

regards,

Joe

[former_member183424]

Anyway, you can restrict the change quantity..

Set the message "M8-504 Quantity invoiced greater than goods receipt quantity" as error from OMRM t-code...

Also with the message "M8-082 Price too high (tolerance limit of XXXX INR exceeded)"

[Former Member]

Patra,

my price control is V since the material is raw material. i think difference might be because of foreign currency valuation since PO and Invoice are in different periods and FI changed exchange rates.

[former_member183424]

Okay....

If your price control is V, then it will effect on Inventory account for material..

The the amount goes to price difference account, it means you haven't stock available in your material master-accounting 1 tab...

And also may your causes of different period for exchange rate...

But you can sure about that system is posted correct value...

System consider all possible things about the amount goes to price difference account...

You can cancel the Invoice receipt...

[former_member183424]

Firstly, You have done GR with price 1183 for 750 , 250 and 500, then your GR/IR amount will be debited as per 887250 , 295750 and 591500 and sum will be 1774500.

At the time of MIRO, user has wrongly posted 5000 instead of 500. Now your qty is 6000 and amount still Payment amount still 1774500.

Now your price different goes to 1774500/6000 = 295.75.

Your GR/IR will be debited 1774500+295.75 = 1774795.75.

And your vendor account will be credited 1774500.

But you have wrote something else amount...

Can you clarify this ??

And can you able to cancel the invoice and enter again  ?

[Former Member]

Patra,

The entries I showed were for the invoice of 500 mt only. Yes the full amount for the 1500 MT that I paid the vendor was 1774500. but my main concern is for the invoice for the gr of 500 only.

the entries i have shown here are from follow on documents for the invoice.

Since when I look at vendor open items for the particular invoice , systems shows only 591500 as open item..

I need to first understand this system behavior so that i make correct changes and rather than always reversing and entering invoices again. Also to make necessary measures to avoid such data entry mistakes.

Thanks for very helpful answer.

Regards.

[former_member183424]

Sorry I have done a little mistake in my previous comment..

The price difference will calculate like that

(Amount/quantity) X different quantity..

Here you price different will be (591500/5000) X (5000-500) = 532350.

But you have shown 524,793.83..

Now the question is what is your price control for material ?

V or S ?

[Former Member]

dev

Also realized that another user during testings made a credit memo against the invoice. so I have been able to account for the deficit in price difference account postings..

[Former Member]

Does your PO is having GR indicator ticked,then system will not allow more quantity then GR quantity.

[Former Member]

Patil,

GR field and Delivery indicators are checked.