Financilal Reports in SQL

We are on a fresh install Epicor 9.05.607, and we are replicating data over to a SQL server. Fields and tables have changed from Vantage, so I need to get our reports updated and able to tie back to figures on our Income Statement. I am close, but I am missing something. Is anyone out there doing any financial reporting outside of Epicor in SQL? Could I possibly look at your queries? I'd like to see which tables you are including, which fields, criteria, etc... It would be much appreciated!