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

[former_member192897]

Try Standard Report on Vendor Business S_ALR_87010043

Go to Above report and Give Vendor Range and Company Code and Botttom of Screen there is an Option called Accounts with No Purchase Tick it and Execute.

Hope you may get Similar Threads on SDN Search

Try this I havent tried

[former_member218067]

Hi,

Use transaction S_ALR_87012093 to find out vendor business for a period

or you can run report RFKUML00 IN SE38

Use reporting periods as search criteria

Diwakar

[Former Member]

Thank u for answering this question