rick1906 5/31/2012 11:13:37 AM

Account Balance Summary query

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?

Version: GP 2010
Section: Dynamics GP, SQL Scripts

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables