MIRO posting with PRD Price difference account Due to Rounding

[Former Member]

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.

[Former Member · Accepted solution]

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

[JL23 · Accepted solution]

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.

[Former Member]

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.

[JL23]

If your vendor invoice shows 489372.74 then you have to enter this amount in the amount field, as it is the amount which your vendor expects to get paid from you.

There is no calculation that will alter this amount

If you want overpay this 0.01 to your vendor to avoid that it posts as difference, then you can do it if your management gives you the permission to enter other amounts than the invoice shows.

[Former Member]

Dear Jurgen,

Thank you for your reply. One last query, this calculation of rounding is coming from configuration? or it is a standard behaviour of SAP? if it is configuration then I would like to know t-code for the same.

Thanks & Regards,

Biraj

[JL23]

it is standard commercial rounding - no customizing

[former_member1142460]

This message was moderated.

[Former Member]

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

[JL23]

I think the difference is not between SAPs MIGO and MIRO, it is more a difference between SAPs MIGO and your vendors invoicing system, isn't it?

SAP calculates 489372.75 while your vendor sent and invoice for 489372.74

[ravindra_devarapalli]

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.

[former_member183155]

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 -->

Regards.

M.Ozgur Unal

[JL23]

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 

[Former Member]

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.

[former_member183424]

It is depend on how you have entered the amount manually in MIRO header :

[former_member198650]

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

[ravindra_devarapalli]

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

[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.

[JL23]

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?

[kaushal_sharma]

Hi Biraj,

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