Is there a saved search to extract the revenue arr...
# ask-stanley-ai
s
Is there a saved search to extract the revenue arrangement level entries of unbilled receivables when revenue journal entries are recorded as summary journals
🤓 1
c
AI generated answer (using internal Slack threads):
Based on the conversations, it appears that you can create a saved search to extract the revenue arrangement level entries of unbilled receivables when revenue journal entries are recorded as summary journals. However, it might be complex due to the different levels of joins involved. Here are some steps you can follow: 1. Create a saved search on the Revenue Arrangement (RA). Use 'Revenue Element' as the source to have the transaction source and 'Applying Transaction' to have the Revenue Recognition Journal Entry (Rec Rec JE). 2. Set the criteria as 'Type = Revenue Arrangement'. 3. To get the invoice and the Rev Rec journal, you might need to use a join. Remove 'Applied to Transaction' and use 'Revenue Element Source' as shown in the screenshot (not provided). 4. If you want to see invoices that are not affected by revenue recognition, you can use a criteria specifying that you only want items with direct posting. Please note that this might not give you all the information you need due to the complexity of the joins involved. You might need to use a workbook or SuiteQL to handle the complexity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.844543457
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840502739
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830143571
Please provide your feedback on this answer.