Is it possible to access a transaction lines histo...
# suitescript
i
Is it possible to access a transaction lines history using suitescript?
plusone 1
d
Couldn't find it in the search.Type enum URL for it doesn't give me any hints:
/app/accounting/transactions/history.nl?id=${tranid}&line=${line}
While all the fields look like system notes (set by, context, type, field, old/new value), running a system notes search didn't return any transaction line history results
m
From memory line history is included in system notes table for SuiteQL but I couldn't find any way to identify which specific line it related to
🤔 1
i
Well, on a transaction SS, there is a Line system Notes, so I'm gonna end up doing a SS for each transactions and check the field im interested. What I need to do is, there is a date field and a counter field, so each time an user changes the date field it should add +1 to the counter, this works for new records using an UE, but for older ones that already had a change I need to set it also, so this is the only solution I can think of, a MR with a SS for each transaction and count the number of times the field has been modified using the line system notes on the SS.