I'm trying to delete a work order completion which is referenced by a custom record field. The field though it set to allow deletion of list/record values and set the value to null. Though whenever we try to delete the completion, we still experience an error saying that there is a dependency, namely the custom record.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems like you're encountering a common issue in NetSuite where a record cannot be deleted due to dependent records. Even though you've set the field to allow deletion and set the value to null, the system is still detecting a dependency. Here are a few things you can try: 1. Check the dependent records: When NetSuite gives you the dependent record error, it should provide a link to see which dependent records are attached. Check this link to see if there are any records you might have missed. 2. Change the field type: Sometimes, changing the field type can delete all previous data that the field stored. You will get a warning saying “Changing this custom field type will delete all data in existing records. Are you sure you want to do this?” 3. Use the field in a transaction or record: After changing the field type, try using it in a transaction or record. This might help in removing the dependency. 4. Check for backend data: Sometimes, the dependency could be part of some backend data that isn't referenced in these dependencies, like in System Notes or Audit Trail. 5. Check if the record has transactions: If the record is an item, check if it has transactions. You can do this by going to Actions on the item and then view all transactions. Remember, these are just suggestions based on previous conversations and might not work in all cases. If none of these suggestions work, you might need to dig deeper into the issue. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******