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
Marc
08/16/2024, 1:02 PM
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
Luis
08/17/2024, 3:54 AM
When you say SuiteQL, is it the onr built by Tim? If not, how can I use that in the UI?
m
Marc
08/25/2024, 6:43 PM
Yes it’s a Tim tool
But you can try by workbook
Marc
08/25/2024, 6:45 PM
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
Luis
08/26/2024, 3:18 PM
Thank you. Is there a way to bypass the transaction line limit from Tim's tool?
m
Marc
08/27/2024, 10:02 PM
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