Skip to Content

How can i get total of GR & IR quantity of PO

Hi Experts,

There is a case where invoiced quantity is greater than GR quantity. Now we put a check maintaining message no M8504 as error. But i need a report where i can compare IR quantity to GR quantity of PO. In table EKBE have all the info but it is not as per our requirement. I need a report where i can see PO - Total GR quantity - Total IR qty.

Please refer below screenshot.

Please help

regards

grtoir1.PNG (24.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Jan 08, 2014 at 06:06 AM

    Hi,

    Check report with t.code:MB5S

    Regards,

    Biju K

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 06:08 AM

    Hi

    Try MB5S and MR11 report

    also check following thread

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2014 at 06:09 AM

    Hi,

    MB5S is the best report as suggested by Bijay.

    Alternatively, you can find the info in ME2N, ME2L, ME2M also.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2014 at 07:09 AM

    Thank you all..MB5S works..😊

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2014 at 06:39 AM

    Hi rohit,

    Check in the tcode SAP1 to get the list of reports.

    Regards

    Subbu.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 08, 2014 at 06:41 AM

    In EKBE table you can get the both quantity..

    But You have to put a logic on this table output.

    Here E = Goods receipt. Q = Invoice receipt.

    And also S= Positive and H = Negative.

    Additionally

    From MSEG table, you will get the GR quantity

    And from RSEG table, you will get the IR quantity..


    ScreenShot.jpg (147.6 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.