Skip to Content
author's profile photo Former Member
Former Member

issue with MIRO accounting document with differnt exchange rate picking

Hi

I have issue with MIRO Accounting - it posting with EUR (document Currency) and Local currency is GBP

Its posted for Multiple materials ( where P O is multiple items and partial GR and partial IR are done)

Exchange rate is EUR TO GBP -79,39659 in Accounting document header ( Translation date 01.07.2016 and OB08 also same on 01.07.2016) )

In PO Tab:Delivery /Invoice --> Exc Rate= 78,55460 ( PO was Created on 20.05.2016)


Problem

  1. 1.when IR posted - Cost line item gets posted with 0.00 in Document currency and Company code Currency shows balance - where this balance comes and how document currency shows 0.00
  2. 2. how systems takes different Translation rate for one document

Find the below Accounting entry


Posting Key Account Line item EUR GBP Translation 31 Vendor 2 12.122,34 9.624,72 79.39659 86 GR/IR 3 6.061,17 4.812,36 79.39659 86 GR/IR 4 2.161,69 1.701,75 78.72313 81 Cost 5 "0.00 14,56 86 GR/IR 6 79.982,53 63.503,40 79.39659 86 GR/IR 7 2.161,69 1.716,31 79.39668 86 GR/IR 8 6.515,58 5.159,43 79.18604 81 cost 9 0.00 13,72 86 GR/IR 10 6.515,58 5.173,15 79.39662 86 GR/IR 11 9.773,37 7.696,79 78.75268 81 Cost 12 0.00 62,93 86 GR/IR 13 3.257,79 2.586,57 79.39646 40 Taxaccount 28.281,38 22.454,45


Cost - means while PO creation we do assign the cost element with cost center and Business are ( item details- Account assignment tab)

Please help me to solve this issue


Regards

Rana


Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 21, 2016 at 11:41 AM

    Dear Rana,

    Hoping It is a standard behavior.

    If the exchange rate is different between GRN posting and Invoice posting date (provided fixed exchange rate is not ticked) then the difference exchange rate amount gets posted to different account (which might be your inventory G/L reference to Import).

    Please verify.

    Sample calculation for your reference. Difference 1455.811

    79.396592,161.69171630.814678.723132,161.69170175.0029
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vjay SAP

      I checked in system

      Good receipt and Invoice receipt are posted same date : 01 .07.2016 and both are having

      exchange rate : in header level of document :79,39659

      in PO - Delivery/Invoice tab - Exhange rate : 78,55460 but not checked - Exchange rate Fixed

      Would please explain how it works - what could be the issue in my case

      Regards

      Rana

  • Posted on Jul 25, 2016 at 08:51 AM

    Hi,

    PO exchange rate picking from OB08 with a exchange rate type but cross check do you have another exchange rate type assigned to RE( for invoice) document type which causes your concern during invoice document posting.

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Your local currency is GBP and foreign currency is EUR.

      Your value is "ZERO" in invoice posting with EUR where as GBP currency has some value resulting

      GR/IR clearing posted with EUR in goods receipt document and the same value in EUR posted with invoice posting document.

      As result of exchange rate difference between goods receipt and invoice receipt posting date causing your concern Refer SAP Note:- 2171162

      Regards,

      Biju K

  • Posted on Jul 25, 2016 at 10:48 AM

    Hi Rana,

    In standard, there is a possibility for separate posting line for exchange rate difference with zero value. Please check SAP note 331910 - MR1M, MIRO: Postings in foreign currency/local currency (Read section : Exchange rate rounding differences).

    BR, Rosh.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.