This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

We have ARM (advanced revenue management)
Can anyone give me the chain of tables and joins I can use to get from the revenue recognition journal back to the original invoice line? (using the <http://netsuite2.com|netsuite2.com> schema or suiteql schema)

<@UCW6BN2DA> Take a look at the RevenueElement table, and the "revenueelement" column on the TransactionLine table. That might help get you started.

weirdly, revenueelement is blank on the TransactionLine
I'm wondering if I have to go to previous transaction to get the RevenueArrangement somehow?

in the <http://netsuite.com|netsuite.com> datasource, I was joining from transaction_lines to transaction_links and _*then*_ on the linked transaction joining on revenue element

but it's not clear to me how I join transactionLines to PreviousTransactionLineLink (if that's even where I need to join to)