A local resource can't be deleted once it has been used to create an invoice or order item. This is true even if the local resource is removed from an invoice or order before the invoice or order is submitted.
In this situation, you can make the local resource Inactive. Marking it Inactive will prevent it from appearing in the dropdowns for users when creating invoice/order items, and it will only show when you're specifically searching for inactive local resources.