MIRO - How to restrict the user to hold the MIRO document for the second time

[former_member506893]

Dear all,

When posting the MIRO document instead of posting it we can hold the document and post it later and when we hold this, document number generates for the HOLD MIRO document. But in my case what happens, instead of posting the HOLD MIRO document in MIR7, without knowingly my users again HOLD'ed the same MIRO document. For our clear understanding, now we have two HOLD MIRO document for the same Invoice/PO number. That is the standard behavior in SAP and we need to restrict that.

In the screenshot 1 you can clearly see the HOLD MIRO document number is 5105609502 for the same Invoice No./PO No.

Again in the screenshot 2 we can clearly see that SAP is allowing me to HOLD (5105609503) for the same Invoice No./PO Number.

So, my client need to restrict that and while posting the HOLD document for the second time SAP should throw the error if it is a same Invoice/PO Number. So I need your help/suggestions and I believe that I'll be getting the positive response from you all. Thank you all.

Attaching the screenshots for your reference.

Screenshot 1 - First hold document in MIRO for the same PO/Invoice

Screenshot 2 - Second hold document in MIRO for the same PO/Invoice

[former_member506893 · Accepted solution]

Dear Sreenivasulu,

Thank you for the input. Here we did the enhancement in the standard MIRO Tcode. If we hold the document, SAP will not store any transactional data in FBL1N. But it is storing the data in "RBKP" table and the identification field is "RBSTAT". First we have to check the following fields respectively.

Company code(BUKRS) → Document type(BLART) → Invoicing party(LIFNR) → Reference(XBLNR) → Fiscal Year(GJAHR) → Document number(BELNR) → Invoice document status(RBSTAT).

Suppose in "RBSTAT" if the value is "D"(Held entered) system should throw the error with the existing document number so that user can easily lookup to the already posted document number in MIR4.

We can also add other values like A: Parked, B: Parked complete, C: Held parked in the same field.

Thanks

[former_member206132]

Dear Manivannan,

You can achieve this by other method also where The duplicate invoice entry check has been activated in the vendor master record for the vendor for which you are entering an invoice, then it will resolve your issue.

But any way hoping that your enhancement is working, Great!!

Best Regards,

Repakula Manoj

[polaggari]

Hi,

Try if "Check for Duplicate Invoices" works.

material management->logistics invoice verification->Incoming invoice->Set check for Duplicate invoices.

Thank you,

Sree.

[former_member506893]

Dear Sreenivasulu,

Thank you for your reply. We have already activated the duplicate invoice check but the system will not throw the error as there is no accounting transaction will take effect. I'd thankful to you if you provide me alternate solution.

[polaggari]

I couldn't think of any standard solution.

You could try this:

create a custom program/t-code and ask business to use only this T-Code to hold the invoices and in this custom program you could validate for duplicate 'Held documents' using the combination of PO number and Item number or Vendor invoice number depending on your requirement.

Thank you,

Sree.