cancel
Showing results for 
Search instead for 
Did you mean: 

Different amount in local currency when MR8M than MIRO

Former Member
0 Kudos

Hi experts,

I am an FI consultant but have some trouble investigating a peculiar case. We have used a PO in USD during MIRO and the amount in local currency was wrong because of the exchange rate. We immediately used MR8M to reverse that invoice so we can change the exchange rate and post it anew correctly. The strange thing is that when we reversed the MIRO document, a different amount was posted on the vendor account. It is true it was a small amount but considering that it should have been a mirroring image of the original invoice, even the key users are surprised and demand an explanation and a solution so that it would not happen again.

Exchange rate USD/EUR is in both cases /0.72770

MIRO:

Vendor - 54,490.00 USD = 39,652.16 EUR

MR8M

Vendor - 54,490.00 USD = 39,652.37 EUR

Difference                                 0.21 EUR

Where might the wrong calculation come from?

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member233510
Active Contributor
0 Kudos

Please check the SAP note 106094 (Dealing with minor differences).

Former Member
0 Kudos

Hi Ignatius,

This is not the case either, I had only one line item, except vendor. And another puzzling thing, why posting with MIRO gives 39,652.16 EUR instead when doing MR8M, which should reverse the same amount  from the initial invoice, is 39,652.37 EUR.


No rounding configuration has been maintained for LIV.

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

Share the  detailed screens

1. PO with PO creation date

2. PO history

3. PO with Exchange Rate Type and Exchange Rate value

4. OB08 with Exchange Rate Type/Exchange Rate Types

5. Exchange Rate Type is assigned  to document type WE

6. MIRO screen with posting date(invoice) and document date

7. Exchange Rate Type is assigned  to document type RE

8. MR8M screen with posting date and document date

Regards,

Biju K

Former Member
0 Kudos

1. PO with PO creation date

3. PO with Exchange Rate Type and Exchange Rate value


2. PO history

4. OB08 with Exchange Rate Type/Exchange Rate Types

5. Exchange Rate Type is assigned  to document type WE - we don't have GRs

6. MIRO screen with posting date(invoice) and document date

7. Exchange Rate Type is assigned  to document type 1A (in our case)

8. MR8M screen with posting date and document date

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

You are creating PO on 02.06.2015 but allowing invoice posting on 01.06.2015!

Your invoice posted(52008324) and cancelled(52008321) on 25.06.2015 which are correct
But invoice posted (52007766) and cancelled(52008325) on 01.06.2015 which are wrong- You are saying!

Your PO screen and MIRO screen currency is USD- what is your company code curency and why exchange rate with ratio not showing in PO screen?

What is your Exchange Rate  in May, June and July months of 2015?

While invoice posted 52007766 with  39,652.37 EUR and invoice cancelled 52008325 with 39,652.16 EUR - Is the invoice document  52007766 posted before Exchange Rate maintaioned before for June 2015(which is with value from May2015) Where as invoice cancelled 52008325 with value 39,652.16 EUR taking Exchange Rate maintaioned from value in June 2015.

Regards,

Biju K

Former Member
0 Kudos

Business allows predated posting, if in the same month.

The invoice(52008324) and cancelled(52008321) on 25.06.2015 were trials to correct the difference, with no luck though.

The invoice(52007766) and cancelled(52008325) on 01.06.2015 are the wrong ones indeed.

I tried several other times to replicate this case but with no luck, all other times (invoices and cancellations) have been translated to 39,652.16 EUR.

Our company code currency is EUR, and the exchange rate in PO was showing 1.0000 because during PO creation, they changed the currency to USD in a later step but nonetheless, if the flag Fixed exch. rate is not there, the one from OB08 is used.

The exchange rates in May, June and July were the same because of a misunderstanding from the initial go-live, in which they were always updating the M exchange rate type on a monthly basis when in the currency ratio only the USD/EUR had an alternative exchange rate type EURX and that was never updated (=1.37420 from go-live to somewhere beginning of July).

The most I could figure is that, the indirect exchange rate from EURX is somehow altered during FI document post:

54,490.00 USD * 0.72770 = 39,652.37 EUR

while

54,490.00 USD / 1.37420 = 39,652.16 EUR

this is where the problem is and I don't know why the system considers suitable a multiplication with direct rate instead of a division with indirect rate??

former_member183424
Active Contributor
0 Kudos

As per your exchange rate , you can see the cancellation amount is the correct one. What is the exchange rate you can see for both document in RBKP table ?

See the posting logic for exchange rate in this KBA 1846299 - Reversal of invoice using MR8M to the correct accounts posting logic is not the same for M... , along with there are many OSS note/KBA exist in service market place for exchange rate difference.

Also check this OSS note is applicable for your case 1846299 - Reversal of invoice using MR8M to the correct accounts posting logic is not the same for M...

Former Member
0 Kudos

In RBKP, I see the same exchange rate type for invoice and cancellation.

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

Did you post MIRO and MR8M in same date- How frequent you maintain the Exchange Rate(OB08)

:- daily or monthly!

In general, Exchange Rate Type is M but check any other Exchange Rate Type assigned to to document type RE in t.code:OBA7

Regards,

Biju K

Former Member
0 Kudos

Hi Bijay,

Unfortunately, the posting date was identical so no luck with this. The only thing different was the entry date but this has no impact.

We update the exchange rates once a month. Only that in our case, the exchange rate type M had, for only USD/EUR parity, an alternate exchange rate type EURX. And that is why we had to reverse the initial invoice and we got this difference.

No alternate exchange rate type was set in the document type for foreign currency posting.

Will explore next answers.

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

Which Exchange Rate Type is assigned  to document type RE in t.code:OBA7 ?

Check how How Exchange Rate settings for your Company Code

SPRO -- > Material Management -- > Logistics Invoice Verification -- > Incoming Invoice -- > Configure How Exchange Rate Differences Are Treated

Regards,

Biju K

Former Member
0 Kudos

In OBA7, we have not maintained a specific exchange rate type for foreign currency documents. It is blank, so the default should always be M or for any specific cases, like ours with USD/EUR, the alternate EURX.

Also, no special treatment in SPRO, related to "Configure how Exchange rate Differences are treated". We have the company codes there, the company code currency and all other fields or radio buttons are blank or deactivated.