cancel
Showing results for 
Search instead for 
Did you mean: 

List of Active Vendors (with current payments)

Former Member
0 Kudos

I am trying to see if there is a way to pull a report with a list of Active vendors with payment activity from this year

thank you

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

There are a couple of reports. Pl. see if any of these are of any help to your requirement.

S_AL0_96000385 - Top Vendors Report

S_ALR_87012104 - List of Cleared Vendor Items for Printing (choose cleared items only for the required date range)

Answers (2)

Answers (2)

atif_farooq
Active Contributor
0 Kudos

Hi:

First you need to download the list of all vendors created from the table LFA1..Copy the vendor by exporting it to excel from this table data..Having done with this please go to FBL1N...Select all item with normal and special GL indicator and give date range for the whole year..Paste the vendor number in vendor and execute the report. After when it is executed you may filter payment document types, do not forget to fetch Account field from layout into in your layout. You will now have all the list of vendors that were active during the date range given.. I hope this help .

Regards

0 Kudos

Hello,

you can use the table LFA1 or LFB1 to view all the vendor in the system.

you can filter these vendor on based the payment block, get all the list of blocked vendor then you can easily find the all the active vendors in the system.

you can choose the filed based on your requirement from this table.

Hope this will help you.

Thanks and Regards,

Mangal Modi