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

All responses (7)

Answers (0)

Suggested answer

Teddy Herryanto (Th... 13,486 Moderator on at

Like (1)

Report

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

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.
Suggested answer

YUN ZHU 81,789 Super User 2025 Season 1 on at

Like (1)

Report

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

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
Suggested answer

Valentin Castravet 27,891 Super User 2025 Season 1 on at

Like (2)

Report

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

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/
Suggested answer

Khushbu Rajvi. 14,928 Super User 2025 Season 1 on at

Like (2)

Report

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

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
Suggested answer

Ramesh Kumar 3,501 on at

Like (1)

Report

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

Hi,

Filter on vendor list page with balance field.
Suggested answer

Jainam M. Kothari 6,567 on at

Like (2)

Report

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

Hello,

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

Then you can block the same.
Suggested answer

Jinal P. 85 on at

Like (0)

Report

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

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.