How to find out the GR Numbers for which IR has not been done

[former_member417490]

Hi Sap Gurus,

Can anybody tell me how to find out the G R Numbers for which Invoice Receipt has not been done. Any TC or ant standard process to find out.

Thanks N Regards,

Siddhartha

[Former Member]

Hi Siddarth,

Solution :

1) Go to SE16 - Table Name : EKBE (PO History)

2) Field - BUDAT (Posting Date)

3) Transaction event Type:

- 1 (Only GR's )

- 2 (Both GR and IR)

4) We can fetch both GR Numbers and also PO Numbers for which IR has not been done if transaction event - 1.

In addition to MB5S, you can try this also...

[former_member581212]

hi,

> in addition to MB5S pls see the tables in se16...tables are SKA1, SKAT, SKB1 these are G/L account Masters...

Hope it helps..

Regards

Priyanka.P

[Former Member]

Hi,

Use standard report ME2M and appropriate Selection Parameters to meet requirement.

If no appropriate Selection Parameters,you can define it by SM30 table V_160S

Jason.

[former_member335885]

Hi,

Check MB5S as pankaj told you.

You have the document numbers with the the GR Qty and Invoiced Qty.

MB5S Display List of GR/IR Balances RM07MSAL

Thanks & Regards,

Kiran

[Former Member]

Hi,

Check in MB5S -- List of GR/IR Balances,

You can also check in ME2M/ME2N/ME2N -- List of Purchasing documents.

Here select the selection parameters as RECHANTG -- Open Invoice reciepts.

You will get list of all the pending invoices to clear.

rgds

GSC

[Former Member]

Dear,

Try MB5S - GR/IR balances transactions which uses RM07MSAL report.

The document numbers are not displayed in this report. Data displayed basing on purchase document number. To get GR and particual IR document number, design a custom zreport with help of abapers.

Regards,

Syed Hussain.

[pankaj_singh9]

Hi,

Refer Report MB5S - List of GR/IR Balances

Also you can use Report ME2N with Selection Parameter as "RECHNUNG" - Open invoices

And also you can refer report ME80FN, here select option as "PO History" in the output screen.