Hi everyone, I am trying to get the deleted transactionline using suiteql. I was using DeletedRecord table to get the deleted transactions which doesn’t have deleted line items. Any idea on how can i get it?

You can't. Once a transaction is deleted the lines are no longer retrievable

@michoel Thanks for writing up. I am talking about only the transaction line items. Not the transaction itself. eg, I have a transaction JE1234 which has 5 line items. I delete 2 line items. Now we will have only 3 in the UI. Now how do i know that there are 2 line items are deleted using suiteql?

You don't. The lines are not soft-deleted, they are removed from the database and AFAIK they don't appear on the Deleted Transactions or Audit Trails.

Thanks @Edgar Valdes.