Has anyone built a report that shows the Source Tr...
# general
l
Has anyone built a report that shows the Source Transaction Line, Revenue Arrangement, Revenue Element, Discounted Sales Amount, Deferred Revenue Recognized, Revenue Recognized, Unbilled Receivable?
m
Not sur, you could try with a revenue plan search, but I think there are too many different levels of joins involved. It might be better to use a workbook or SuiteQL to handle the complexity.
l
When you say SuiteQL, is it the onr built by Tim? If not, how can I use that in the UI?
m
Yes it’s a Tim tool But you can try by workbook
otherwise when there are too many joins I create several reports, export them by script, and I use the web query to connect them
l
Thank you. Is there a way to bypass the transaction line limit from Tim's tool?
m
you have no join limit so you can go back to the information you are looking for as long as you have a common value
l
Sorry, I meant the no. of line results.