Has anyone found a way to query line-level system notes with a join to transactionline? I have a SuiteQL query working which gives me the line level expected receipt date history, but it doesn't tell me what line was changed.
require(['N/query'])
var query = require('N/query')
query.runSuiteQL({
query:`SELECT systemnote.* from systemnote where recordtypeid = -30 and field = 'TRANLINE.DEXPECTEDRECEIPTDATE'`,
params: []
}).asMappedResults()