Has anyone found a way to query line-level system ...
# suiteanalytics
b
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()