Deleting vendors

Business Central/NAV User Forum
1

hi all.

i want to delete all vendors whose having no transactions .

how can i do this

pls any one can me

2

What did you try till now?

3

Hi

Try doing this - Select all vendors in vendor master. System will check the vendor records one by one and will delete the vendor without any transaction, then move to next record. If there is no transaction, the record will be deleted. Otherwise you will get the message. Leave out those vendors and select remaining and delete again.

Please try this in test first, and depending on the number of records it might be time consuming.

Regards

4

Why to delete ??

We have field called 'Blocked ’ on vendor card .Just blocked them by selecting ‘All’ option

You never know when you required the same vendor again in future.

5

Another Options is adding a new field to the vendor table.

Field No:50090
Field Name:“Ledger Entry Exists”
Data Type: Boolean
FieldClass: FlowField
CalcFormula: Exist(“Vendor Ledger Entry” WHERE (Vendor No.=FIELD(No.)))

Then you can filter on “Ledger Entry Exists” = NO and those can be deleted.