#C298P0BCK #C2A1ZEMF0 Has anyone been able to get the revenue arrangement and corresponding invoice/Journal on a saved search or Analytics? Unable to get these only one report that would tell me whats been invoiced vs journaled and the outstanding amount.. Want to see if anything has one and not the other hence the question

Saved search on the RA , use Revenue element…source to have ( transaction source ) and applying transaction to have ( Rec REc JE) I created a script to change the Line memo of the rev rec JE to have the source transaction.

thanks @Marc that just gives me the journal and not the invoice? basically, I want to match off the invoice and the Rev Rec journal to see any that have not been released properly or where the invoice has been generated but not the Rev Rec journal and vice versa.. have differences in our Deferred Revenue Account which I'm trying to reconcile

Is not applied to transaction you need to use join Revenue element …source like in my screenshot

So the Source of the transaction is Sales Order and not the Invoice whilst the RA has related records of Invoice & Journal...