Clearing/Addressing GR/IR item that has been paid

[Former Member]

Hi All,

I am soliciting input in trying to resolve an issue related to GR/IR clearing. The GR/IR account was not regularly cleared using MR11 or F.13. While trying to reduce the line items we have come across a few that have me puzzled. The following are the issues:

Scenario One

- Good receipt was completed - two line items 80 and 20- for 100 quantity amounting to 295.00.

- Invoice receipt was completed for 20 quantity amounting 294.78 and Paid

- An additional invoice was created for the remaining 80 amounting 236.00 and Paid

- Both checks have been cashed, so reversal can not be completed

Scenario Two

- Good receipt was completed for $100 with multiple lines

- Invoice was completed with only one line for the amount of $100

- Item has been paid

Question

What steps should be taken to clear this item from the GR/IR account?

Thank you in advance for your professional advise.

[Former Member · Accepted solution]

- Good receipt was completed - two line items 80 and 20- for 100 quantity amounting to 295.00.

Understand 2.95/1 pc

- Invoice receipt was completed for 20 quantity amounting 294.78 and Paid

did you mean 2.9478/1 pc? If so, 20*=58.956 Considering for 100 quantity amount is 295, how could you miro 294.78 for 20 quantity? Could you please confirm?

- An additional invoice was created for the remaining 80 amounting 236.00 and Paid

Same questin as above

- Good receipt was completed for $100 with multiple lines

- Invoice was completed with only one line for the amount of $100

- Item has been paid

Supposed there are 10 items, each item costs 10$ , then you have goods receipt for them? Please confirm.

And you just miro for first items, and amount is 100$ , which means you had not finished miro, or you just miro wrong amount for first item which is supposed to be 10 $ please confirm...

[Former Member]

Hi,

GRIR is only a balancing account. The difference between Good Receipts and Invoice Receipts is not affecting the GRIR account.

Scenario 1- In this case you have following options

1. Add the additional amount in the base amount it will add in the material GL aacount if the material is in stock or otherwise it will go to price difference account.

2. The difference manually can be entered against the material, in the material tab available in ECC 6.

3. The difference manually can be entered against the GL Account, in the material tab available in ECC 6.

4. You can charge it against unplanned delivery cost, in the tab under additional tab.

Scenario2-

1.In this case you can clear only line item posted for $100.

Regards

Milind Sonalkar

[Former Member]

Thank you very much for your comments and input

Let me elaborate further:

Scenario One:

There are two lines in this PO but only one is causing an issues. So all references below are related to one line alone

PO Quantity is 100pcs @ 2.95 per pcs = 295.00

First GR is for 20 pcs @ 2.95 per pcs = 59.00

Second GR is for 80pcs @ 2.95 per pcs = 236.00

First IR is for 20pcs for 294.78 - Vendor made an error on the invoice and user entered the Invoice for 20pcs totaling 294.78

Second IR was made for 80pcs @ 2.95 per pcs = 236.00 - User then paid the vendor - As of now, we have over paid the vendor due to errors in invoicing

Vendor issues a credit memo for 236.00 and user reverses the second IR

The PO history shows the following:

GR 80 236.00

GR 20 59.00

-

---

TR. 100 295.00

IR-L 80- 236.00-

IR-L 80 236.00

IR-L 20 294.78

-

---

TR. 20 294.78

F.13 will not clear this amount as the quantity does not reconcile. My assumption is using MR11 would not be correct as quantity was actually received. Another piece invoice for 20pcs can not be reversed as it has been paid/cashed.

What can i do to address this?

Your suggestions are greatly appreciated.

[Former Member]

My apologies, i forgot to elaborate further on Scenario Two. The following is an example:

PO has two line items -Bear in mind, the material is the same in both lines.

10. xxxx 981pcs @ $3.07 per pcs = $3011.97

20. xxxx 4pcs @ $3.07 per pcs = $12.28

GR was completed for the first line: 98pcs1 @ $3.07 per pcs = 3011.67

GR was also completed for the second line: 4pcs @ $3.07 = 12.28

IR was completed for the first line item: 327pcs @ $3.07 = 1003.89

658pcs @ $3.07 = 2020.06

-

---

Total 985pcs 3023.95

IR was not completed for line item two - Instead of clearing the 4pcs on line item two the user applied it to the first line.

What steps should be taken to clear these items in the GR/IR account?