Skip to Content

Monthly wise GR and GI report

I have to make report in which i have to show the quantity and value of Goods Receipt and Goods Issue monthly wise for a particular material. How can i do this. Plz help........

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Best Answer
    Apr 06, 2011 at 09:21 AM

    Hi Rita,

    You can do this by 2 methods.

    1) U can use standard T codes like MC.A , MC.2 , MC.6 you are required to give plant material and period as input field.

    2) Create Z report by copying MB51 you have to take into account the respective movement types.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2011 at 08:58 AM

    >

    > I have to make report in which i have to show the quantity and value of Goods Receipt and Goods Issue monthly wise for a particular material. How can i do this. Plz help........

    Refer tables MKPF,MSEG.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Rita Bodra

      Hi,

      I think there is not need to create a Z-Report for this.

      Use Report MB51 - List of Material Documents based on the Movement Types.

      If this report doesn't suffice your requirement then instead of using tables MSEG and MKPF, use view "WB2_V_MKPF_MSEG2" and try to develop report.

  • Apr 06, 2011 at 09:03 AM

    pl check whether MB90 is useful for you

    if you want to make a custom report, you can do it with MSEG, MKPF, MAKT tables

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2011 at 09:11 AM

    Hi,

    Please check MC.A report.

    Thanks,

    JK

    Add comment
    10|10000 characters needed characters exceeded

    • MBEWH table contains the quantity and value of material of the previous period. I want to know the details of the current period.

      I have to make a report which show the monthly wise reprt for opening stock, closing stock of material, how much purchasing or goods receipt have done, how much consumption have done against that material.

  • avatar image
    Former Member
    Apr 06, 2011 at 09:20 AM

    Hi

    In MB51 t-code

    enter you material

    psoting date for month

    movement type 101 for GR and GI 201,261 for issue of gods

    you will get report for grn and issue in this t-code

    Regards

    Kailas Ugale

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2011 at 09:22 AM

    Hi there

    Use the transaction MB51,, Enter the date range (Posting Date) i.e for a month, Enter the material, and execute the report,,

    in the output filter the GI/GR movement types,, And extract the report to excel, you can create the variant also and just change the month to get the desire results,,

    Thanks

    Senthil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 06, 2011 at 10:00 AM

    Hi,

    Get details with entering Plant, company code with material with t.code: S_P00_07000139 & execute

    Regards,

    Biju K

    Add comment
    10|10000 characters needed characters exceeded

    • Its a good report which show the details on date wise and balance quantity and value.

      I want to show the same report for quantity and value of material but in monthwise or period wise like

      In Quantity

      Opening stock Goods receipt Goods Consumption Closing stock

      Jan 15 20 10 25

      Feb 25 45 20 50

      Mar Apr May......till Dec

  • avatar image
    Former Member
    Jan 28, 2014 at 10:26 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 28, 2014 at 10:45 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 01, 2014 at 07:15 PM

    I have found table S031 to be helpful in summarizing receipts and issues on a monthly basis.  This table holds both the quantity and value of receipts and issues per material.  This is especially useful for reporting purposes where material document specific data is not required.

    Add comment
    10|10000 characters needed characters exceeded