I am looking to create a trial balance file for 2012 but we h aven't closed 2011 yet. As a result, there is no period 0 opening balances for the balance sheet accounts, and the current balance represents period activity and not the true balance in the account.
Is there a way to query to get the correct balance even if the prior year isn't closed?