Vendor with last transaction date

[Former Member]

Hi,

Can I generate any report which contains all vendors with last transaction date? THis is for audit purpose.

Thanks & Regards,

Rajaneesh.C

[former_member533946]

Hi dear,

There is a way to get it in two steps.

1) Get the list of PO vendor wise (ME2L)

2) Put all those PO numbers in ME80FN and execute the report. In the displayed report go to chage view and select the optoin of Purchase Order history.Here you will get all PO details as GR,Invoice,Doc no, date.

[Former Member]

Transaction date means? Does it mean purchase order created date or does it mean last transaction done from the vendor like payment ...

Regards

Sangeeta

[Former Member]

It means, last invoice posting transaction (posting date)

[Former Member]

Hi,

You can take the report of the FI accounting document for all vendors based on the company code and the posting date ( input the present date) in the T code- S_ALR_87012991.

regards,

Kannan B

[Former Member]

I am not sure if we have a report which shows only the last transaction date. But in FBL1N, you can select the option Cleared Items and enter the Vendor account and you can sort by posting date in the descending order to find the last posting date.