This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Would a TransactionLine record ever actually disappear from a NetSuite instance? I am querying based on `TransactionLine.uniquekey` and not getting any record back, but I have reason to believe the value I am searching for did link to a record.

Query is simply `SELECT * FROM TransactionLine WHERE        TransactionLine.uniquekey = '#######'`

if a line is deleted from a transaction, it will probably also be deleted from the database. It would *not* show up among the DeletedRecord table, as that is only for full records.

Thank you for your help on both these questions Watz! This is helpful, I didn't realized the records were truly expunged