Skip to Content
author's profile photo Former Member
Former Member

GRN Filter in MIRO for invoice

Dear MM Guru,

i need your help,

client business process ;;;; one PO is created for one month GRN , every day more than 200 GRN has been done against one PO. now they do MIRO weekly and they have selected GRN no in excel to do the invoice ,

suppose in one week GRN can be more than 1000 but he want to do invoice only 400 GRN which they have in Excel

now when he put the PO in MIRO all GRN shows .so he can not filter 400 GRN which he has,

he is doing search one by one GRN and then select,

from this process one person do one invoice in one day...

now client want requirement--- i have GRN no PO No. now give me one filter process in MRO where i will put my PO no. and GRN so only this GRN will appear in MIRO

kindly suggest me how i can give the solution to filter GRN no in MIRO

Regards,

akil

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 03, 2014 at 05:25 AM

    Take the Reference XBLNR (same as delivery note) from MKPF table with regards to these GR numbers (Material document number)

    Then choose the option delivery note instead of PO in MIRO. Then give these delivery note and enter your invoice.

    Try the same and revert back if any issues.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 01:24 PM

    Dear Aqueel,

    Agreed with DEV, you can't get difference b/w material document numbers associated with same PO until and unless you used delivery note while doing GR. There is no other option to the best of my knowledge.

    Best Regards

    Mohsin Abbasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 11:50 AM

    i got solution myself

    thanx to guide me

    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.