How to delete a list of records.

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

Add a commit

The COMMIT on the processing report worked.

Thanks again.

You are very welcome.