Link between MIRO doc and Invoice doc

[former_member311089]

In my company we follow third party process, where the goods reaches the customer directly from the vendor place. For this requirment we are following standard third party process in sap, which includes

SALE ORDER - PR - PURCHASE ORDER - GRN MIGO(without a/c doc for statistical purpose) - MIRO - RESALE INVOICE BASED ON SALE ORDER

We wanted to create a report which should give the customer invoice details based on vendor invoice. In all my case it is one is to one basis, where for ever miro there will be only one resale invoce.

The vendor invoice is entered during MIRO in reference field. When we have multiple shipment against a purchase order then we are not able to link the customer invoice against a MIRO/vendor invoice, as system does not know which invoice to link as there is no standard link available in the system.

I need to create this link which will help us internally for many reasons, how I can achieve this?

Raj

[former_member197616]

Hi,

You can get the query in one way.

Use table VBFA for sale document flow ,which will provide the sale invoice created for that sale order.

You can use the table EKKN for the POs for the third party which have account assignment as sale order and for the POs MIRO invoice you can use EKBE for PO history category IR-L for invoices posted.

Regards,

[former_member311089]

Your suggestion will work when there is one invoice and one purchase booking, but when there are more than one invoice for a sale order, it will not be possible to link a particular invoice to a purchase booking document.

RAJ

[Former Member]

You can get a link between the MIRO doc and the PO line item in RSEG. This PO line item should have link to PR (EBAN), which should have link to your sales order.

Regards,

Aroop