Skip to Content
0
Former Member
Nov 14, 2008 at 08:14 PM

report for inactive vendors from past 2 years

63 Views

Hi,

We have a request to create a report for the vendors who are not active for last 2 years. Can anyone please advise me the points I should keep in mind to consider a particular vendor inactive. eg. if a vendor has 0 balance in table LFC1 for last 2 years, will be considered as inactive but, that vendor could have some PO's activity on it in these 2 years, which are not appearing on FI side.

Please also tell me if there is a table to find open and close POs for vendors for last 2 years.

If anyone please advise, the points to keep in mind and important tables to refer for create this report.

Quick response will be appreciated.

Thanks & Regards