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