cancel
Showing results for 
Search instead for 
Did you mean: 

To find inactive vendors

Former Member
0 Kudos
2,484

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

former_member192897
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Thank u for answering this question