Help on GR/IR GL Account Clearing

[Former Member]

Hi Experts,

We are having problem with clearing GR/IR Account.

Following is the scenario;

PO -  Item 10 -  MXN 4700 (Amt in LC USD 3500) &

Item 20 -  MXN 2300 (Amt in LC USD 175)

Entries at GR 

Debit GL (Exp)  - MXN 4700 (Amt in LC USD 3500)

Credit  GL 3XX GR/IR - MXN 4700 (Amt in LC USD 3500)

Debit GL 5XX (Exp)  - MXN 2300 (Amt in LC USD 175)

Credit  GL GR/IR - MXN 2300 (Amt in LC USD 175)

MIRO

When we look at MIRO header level there was no change but when look amounting document following entries were generated     Vendor -  Account  MXN 7920 ( USD 580)

Debit GR/IR  3XX A/c  MXN 8000 (USD 590)

     Credit GL 5XX (exp) MXN 3300 ( USD 245)

Debit GR/IR  3XX A/c  MXN 2300

Vat output A/c  MXN 1120

VAT withholding MXN 200

Exchange real account is "0"

The difference in GR/Ir account not able clear.

Credit  GL 3XX GR/IR - MXN 4700 (USD 350)

Debit GR/IR  3XX A/c  MXN 8000 (USD 590)

. We have no idea how this happened. I would like to understand how this occurred as well, so we can avoid this happening again.

Pls note we tried MR11 but document didn’t get picked up.

Any help will be highly appreciated.

Thanks in advance.

Sanjay

[Former Member · Accepted solution]

Hi Sanjya,

Check the price and quantity which received in GR and invoice quantity and price in IR, I think you will get some clue about the variance.

Regards,

Mohammed

[Former Member · Accepted solution]

Hi Mohammed,

Thank you for your reply. I did check quantity and price but I don't find any differences.

Thanks

[vivek_srivastava12 · Accepted solution]

Hi Sanjya,

May I know why there is "Credit GL 5XX (exp) MXN 3300 ( USD 245)"?

At the time of MIRO

GR/IR 8000 = 4700 from GR + Debit of above Expense 3300

Hope it is clear.

br,Vivek

[Former Member · Accepted solution]

Hi Vivek,

That's the issue I m trying to figure it out. Used says he has no idea how this adjusted. I checked at MIRO but couldn't find it. I tried to replicate but when I post I m getting the correct entries.

Thanks

[Former Member]

Hi Sanjay BM,

I think, Transaction-MR11 may help you in this situation,

could you please check with this transaction and let me know the results.

Thanks

Rao

[Former Member]

Hi Rao,

I tried MR11 but this document doesn't get selected.

Thanks

[milind_joshi7]

Hi Sanjya BM,

There is a Check from PO.

Please check the following things as basic data.

1. Line Item of PO 10 and 20 Qty and Amount for GR as well as IR.

2. Amount Currency is Local or Document Currency ( as you Involve in Entry Echange Real account) I feel if the local currency is USD then system will not fetch this account for Entries.

Please check and confirm.

Regards

Milind Joshi

9823211143

[Former Member]

Hi Sanjya,

Could you please let us know why there is a big difference in exchange rates from MXN to USD for line item 10 and 20.

Item 10 -  MXN 4700 (Amt in LC USD 3500) &

Item 20 -  MXN 2300 (Amt in LC USD 175)

What is the result if you try posting MIRO separately for each line item.

Regards,

Ravi Kumar

[Former Member]

Hi Ravi,

USD is 350 not 3500

Item 10 -  MXN 4700 (Amt in LC USD 350).

Thanks