@ERP Experts - with the rule revenue posts into deferred account first and then the rev rec journal moved it from deferred to income. It matters if your audit said so

Yeah our auditors in certain countries are very particular about this point, which means a complicated ODBC query. Unfortunately there's no easy way through saved search that I know of to distinguish between revenue recognised immediately and "proper" deferred revenue

@Jon Kears - what are you after to show in your search? if you use items you should be able to get what you need

So our customers might buy a licence and that licence might renew monthly or quarterly. We load this from an upstream billing system as the same item with different contract start and end dates. Our auditors are after the revenue recognised but split between deferred and immediately recognised. If we attack it from the revenue GL accounts as a transaction search. there's no way to get back to the revenue elements I realise we can run a saved search on revenue plans but then you have to combine with a transaction search for the direct revenue posting stuff, which is annoying to combine