Vendor History

[Former Member]

We need to download vendors with any activity in the last 2 years. The criteria is any open PO, Open invoice or payment posted to the account. Can anyone propose what can be the best way to do that?

Thanks.

[HarshaYedla]

There is no single report, but here are some reports that you can use:

ME2L - Shows the PO history for a vendor.

MIR5 - Shows the PO based invoices for a vendor.

FBL1N - Shows the open/cleared (paid) /all items on the FI side for a vendor.

Let me know if this helped.

[rwarri1]

Hi,

There is no standard report to get this data but you could do it with a combination of ME80FN and FBL1N. If it's a one-time activity, you can do this else you will require to develop a new report.

We have developed one to mark vendors for deletion if there is no activity for 18 months.

Cheers !