Vendors with no Transactions

[Former Member]

Hi Guys,

I am trying to find and delete vendors with no transactions, please suggest if any field is capturing this information.

Thanks

Deepak

[Former Member · Accepted solution]

Hi Deepak,

You can use master data clean up wizard, this would help you to remove the bp's without any transactions.

thanks,

Joseph

[Former Member]

Dear Deepak,

There is no fields which capture this information as per my knowledge.  By using Excel you can find this list. Please check the below steps which I use to do in my project.

1)Go to FBL1N give the vendor number range of vendors as shown below. execute. 

2)system shows all the transactions of vendors

3)download this in to excel list. Filter and take only vendor numbers.

4) in Excel next tab you do the V lookup  you can find the vendor numbers who dos't have transactions.

5) Once you get the information you can Block and mark for deletion

. 

Hope it is helpful.

Regards,

Inthiyaz

[kothandaraman_nagarajan]

Hi Inthiyaz Ahemmed,

Thanks for sharing your idea. But this forum for SAP Business one application.

Thanks & Regards,

Nagarajan

[kothandaraman_nagarajan]

Hi,

Try this query and let me know your feedback:

SELECT T0.[CardCode], T0.[CardName], T0.[Balance] FROM OCRD T0 WHERE T0.[CardType]  = 's' and  T0.[Balance]  = '0' and  T0.[CardCode]  not in ( select t0.cardcode from OPOR t0) and T0.[CardCode]  not in ( select t0.cardcode from OPCH t0) and T0.[CardCode]  not in ( select t0.cardcode from OPDN t0)

Thanks & Regards,

Nagarajan