Small and medium business | Business Central, N...

How do I to get list of vendors with zero activity in BS

(3) Share

Report

Posted on by Nihad92

Hi everyone

we have 1000s of vendors setup that we haven't used before..

is there a way to get a list of all the vendors with zero activities so we can block them instead of deleting them?

Kind regards

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Jinal P. 300 on at

Like (0)

Report

Hello,

You can apply the field filters below on the vendors list page in Business Central. Filter = 0

All Amount field and Balance field fitters = 0.

Hope this will be helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

On the Vendor List, You can filter that "Balance" = 0.

Then you can block the same.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Filter on vendor list page with balance field.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,603 Super User 2025 Season 2 on at

Like (2)

Report

On the Vendor List page in Business Central, you can filter vendors with zero activity by using the Balance field.

Here's how to do it: In the Filter pane or Search field, apply the filter: Balance = 0: This will display all vendors with a zero balance, indicating no outstanding invoices or payments.

Cross-check the Vendor Ledger Entry table — if a vendor has no entries in it, that means they’ve had no transactional activity at all

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (2)

Report

The Balance field only tells you whether a vendor currently has any open documents (e.g., unpaid invoices). It doesn't indicate whether the vendor has ever had any activity.

The best way to check for vendor activity is by reviewing the Vendor Ledger Entries page. If you want to do this in bulk, one option is by exporting both the vendor list and the vendor ledger entries to Excel. From there, you can use formulas like VLOOKUP (or XLOOKUP) to check whether each vendor number appears in the ledger entries. This will help you identify which vendors have never been used.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (1)

Report

It is also easy to find using analysis mode in Vendor Ledger Entries.

PS: https://learn.microsoft.com/en-us/dynamics365/business-central/analysis-mode?wt.mc_id=DX-MVP-5004336

Hope this helps as well.

THanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (1)

Report

You need two things:

1) Making sure that the Vendor is not being assigned to any orders. You can apply filters 0 on all "No. of *" fields

2) Export all your vendor ledger entries and cross check there. Making sure that there is no vendor ledger entries for that vendor.

You can then try to delete the vendors. However, there is still possibility that the vendor no is being used somewhere else. The error message will tell you where it is.

Was this reply helpful? Yes No