To find inactive vendors

[Former Member]

Hello Pals,

I want to find vendors who are inactive from past 5 years,Hau to find is there any standard report or we have to develop a z-report.If at all yes please give me some logic.

[Former Member · Accepted solution]

Hi,

You should develop Z report instead. The logic is quite simple - get the reporting date (or any other date which is chosen by end users at the initial run of this report) as the reference date and feed it to Table EKKO and select each and every vendor ID to find if there is any related record in the last 5 years as from this reference date for that vendor. If not, then report that particular vendor. If yes, then continue searching with another vendor ID till complete.

Cheers,

HT