on 07-28-2015 9:37 AM
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?
Please check the SAP note 106094 (Dealing with minor differences).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
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??
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.