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)

Sort by

Suggested answer

Jinal P. 324 on at

Like (0)

Report
Copy link

Link copied!

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,829 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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,547 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Filter on vendor list page with balance field.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,287 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 32,406 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

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 99,805 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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,304 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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