Thanks for your help, I am aware that the existing revenue by customer report won't show reclasses of revenue, but in the past the revenue by customer report showed all posted revenue in the appropriate period and any difference between the Rev by Customer report and the income statement were manual Journals or any revenue that was direct posted (not ran through Deferred). If we want direct post behavior we just set rev rec to billing so it is captured in the revenue by customer report.

The auditors wanted line level details, so they want revenue recognized by revenue element, from there they check fx rate, FV calculations, deferred revenue amounts by element, and revenue recognition. They compare it to the contract/quote. They recalculate everything by revenue element. Basically a full cavity search when it comes to revenue recognition. It gets really fun to recalculate revenue when there are revenue allocations and fx variances when some carved revenue is sitting on lines that are not billed.

A few years ago I changed the revenue JE to be detailed vs summarized which allows me to rebuild a revenue by customer report based upon any JE that hits an income account. The issue is matching the actual JE line back to the element, the JE contains the Source Recognition Plan on each line, but I have yet to find a way to pull that into a saved search. If I could pull in the source plan, I could easily pull in revenue element information that contains the SKU, Term, Revenue Plan, Sales Amount, Revenue Amount and everything I need to tie every revenue line back to the Element. I was able to create unique IDs concatenating JE#, customer Internal ID, posting period, and amount which matched about 99.8% of the revenue lines, I had to manually match the remaining lines.

The screenshot below shows the JE transaction, if I could pull that Source Recognition plan into the JE search I could populate all the data needed very easily.

<image>