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

MIRO posting with PRD Price difference account Due to Rounding

HI Experts,

Facing an issue in MIRO transaction, here system is posting Price difference account with 0.01 Paisa for few Purchase Orders.

MIGO screenshot

MIRO Screenshot


Any one faced this kind of issue. Please let me know how we can fix this discrepancy..

Reg,

Raj.

MIGO.JPG (68.3 kB)
MIRO.JPG (70.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

10 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 10, 2015 at 09:03 AM

    Dear Jurgen,

    How can I stop rounding effect? Is it advisable to stop rounding?

    Below are P.O. conditions screenshot and MIRO screenshots.

    P.O. Conditions

    MIRO Screenshots:

    MIRO Simulations:

    Please advice.

    Thanks & Regards,

    Biraj


    Add a comment
    10|10000 characters needed characters exceeded

    • You have excise in your conditions which is 160387.06 per 9000

      now you do a partial receipt of 3500, hence this excise is proportioned to the receipt,

      calculation: 160387.06 mult 3500 div 9000 = 62372.7455555556

      since the value field allows only 2 decimals, this value of 62372.7455555556 is rounded to 62372,75

      so the final total is: 427000 plus 62372.75 = 489372.75

      And the invoice from your supplier is 489372.74

      Hence you have 0.01 difference.

  • Posted on Mar 05, 2015 at 12:28 PM

    Hi,

    There are lot of reasons for PRD entry getting in MIRO.

    In MIGO, if you are getting price difference account means, you are maintained price control as "S" for material and you have maintained price was not matching with PO price.

    See below link you will get idea and solution..

    http://scn.sap.com/thread/385228

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      As explained by Devarapalli and from print screens there is no issue and no action required - price difference occured from standard price, and small rounding difference from vendor invoice - no further action required fro business process.

  • Posted on Mar 09, 2015 at 12:22 PM

    I would say it is just caused by a rounding effect since the bottom up calculation (from item) does not equal with the entered value in the MIRO header.

    If you would post your PO condition screen and tell what you entered in MIRO, then it would be possible to show you the calculation

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 09, 2015 at 01:02 PM

    Hi all ;

    Can you share scren-shoot of Miro simulation ? In there , the reason will be seen.

    Also check logic of standard price and moving average price in good receipt process. The document can be beneficial for you --> Planned & unplanned delivery costs in mm

    Regards.

    M.Ozgur Unal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 11, 2015 at 11:25 AM

    Dear Jurgen,

    Thank you for your support. But here can you tell me one thing, why in MIRO system do not pick value as 489372.75??? In MIRO why system is not rounding just like MIGO?

    How to avoid 0.01 INR difference in such rounding effect scenario?

    Thanks & Regards,

    Biraj Adeshara


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 05, 2015 at 12:10 PM

    Hi Biraj,

    Please check price control of material, whether it is "S" or "V"?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 05, 2015 at 12:20 PM

    What is the PO quantity and price?

    What is the value on the invoice from your vendor and what did you actually enter in MIRO?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 09, 2015 at 12:07 PM

    Dear All,

    for above material code, Price control is S. But in one more test case where Price control is V and hitting 0.01 INR in BSX account key. Can anybody tell me the reason?

    Let me brief you here my entries. P.O. quantity is 9000. First time MIGO quantity is 3500 and MIRO is posted for the same. Here system is hitting 0.01 INR in BSX account key.

    Now, I am doing MIGO for remaining 5500 quantity and MIRO for the same quantity then system is not hitting 0.01 INR. so why system is behaving different for remaining full quantity. Why for second entries with full quantity, system is not posting in 0.01 INR? Please find the screenshot for first MIGO and MIRO and second MIGO and MIRO.

    MIGO entry with 3500 Quantity:

    MIRO entry with 3500 Quantity:

    MIGO with remaining 5500 Quantity:

    MIRO with remaining 5500 Quantity:

    This issues are coming live server so above test case I have created in Quality server.

    Also I have observed, when Planned delivery cost is involved it is giving this kind of entries.

    Also I created one more test case, and in that I have not done partial GRN and Partial MIRO. I have done full quantity GRN and full Quantity MIRO. then in this case, system is not hitting 0.01 INR in BSX account key during MIRO. WHY???

    Kindly help me out to find the reason of posting 0.01 INR in BSX account key.


    MIGO1.JPG (91.0 kB)
    MIRO1.JPG (89.1 kB)
    MIGO2.JPG (89.3 kB)
    MIRO2.JPG (80.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Biraj,

      In the first invoice posting, you have not completely credited to vendor a/c. Here you have left the balance 0.01. Due to this it posted to inventory A/c. In second invoice posting. you completed charged to vendor a/c, due to this it did not have any posting for inventory a/c. However, have you assigned small difference GL account for the transaction key "DIF" in OBYC? If you define this, then what ever small difference will charge to this account instead of inventory a/c.

      Regards,

      Mukthar

  • Posted on Mar 10, 2015 at 08:47 AM

    Hi,

    Hope this entry because of rounding profile activated for this. Because of this 0.59 it is took like 0.60 ...but actually is 0.59 ... so 0.01 is posted to difference (Rounding off).

    check rounding off activated or not from FI side.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 11, 2015 at 02:05 PM

    Dear Jurgen,

    I think in MIRO screen, if Tax code amount will calculate as 62372,75 then system will calculate without 0.01 INR difference.


    tax code.JPG (26.5 kB)
    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.