Using SuiteQL, I wish to get the source Estimate transaction that created the Sales Order.
Within NetSuite's reporting features I can get the source transaction of a Sales Order using 'createdfrom'. I need to know the Estimate transaction related to the Sales Order from with SQL. transaction.sourcetransaction is always null. The report I'm trying to create is to show the detail of an estimate that has been…