material invoice report

[Former Member]

Hello:

Here is my request, if I input material and plant number, then I want to know if our vendor had sent invoice to this material which we had bought and good receipt. Is there any possible to run this report via query or table combination?

[former_member533946 · Accepted solution]

Hi dear,

Try this T. code ME80FN.

Enter material code and plant execute the report once the report is executed go to change view select Purchase order history and you will get the details.

If you want to display more fields go to change layout.

[Bruno_F · Accepted solution]

Thank you for the valuable contribution...exactly what I was looking for.

[Former Member]

One question, what is amount in mr51, where does it come from? It looked like that it comes from inventory g/l account when posting invoice receipt.

[former_member187989]

Use report MR51 for document type - 'WE'-Goods receipt,'RE'- Invoice.

[Former Member]

Hi,

For your requirement please take tables EKKO for document number n vendor ,EKPO for material number, EKBE -for the invoice number and for checking the invoice document created,in EKBE restrict transaction/event key -2- Invoice Receipt.

This gives list of invoices for materials for vendor combination.

Hope this is useful.

Smita

[Former Member]

I need invoice receipt number as well...

[Former Member]

Hi,

Check T-Code MR51, MIR5 and MIR6.

Regards

Aloysius

[Former Member]

Hi

Use ME2M - It give the PO raised to vendor and the information about the delivery and invoice is done or not.

regards

Anand

[Former Member]

Hi,

Simple query will not cater your needs. You need to develop a custom Report by linking the tables- EKKO, EKPO, MSEG tables.

Umakanth R