How to delete a list of records.

Dynamics 365 Business Central/NAV Developers Forum
#1

I am working in Navision 3.6 (SQL Server Version). Our customer has a list of 14,000 obsolete items that they want to delete due to lack of activity.

I want to read this list and delete the corresponding record from Navision. I understand that you cannot delete from a dataport but when I pass the item record to a processing report from a dataport that is reading the record, it will not delete (similar to the dataport - i.e. the delete OnValidate of the item table is called but the record remains.

Any suggestions on why this does not work or what to do to make it work?

Thanks

#2

Add a commit

#3

The COMMIT on the processing report worked.

Thanks again.

#4

You are very welcome.