Possibility to show opening balance of a GL account through SQL query?

[Former Member]

Hi experts,

Is it possible to run an SQL query in SBO that shows the opening balance

of a GL account based on a date entered by the user?

This is similar to how the general ledger shows the opening balance of a GL account based on the posting dates entered.

Thanks for your ideas.

[Former Member · Accepted solution]

Hi,

It is possible to show opening balance of a GL account through SQL query. However, that query may be super long because you have to create a temporary table to run through all history to omit recent JE.

Thanks,

Gordon

[Former Member · Accepted solution]

Hi Gordon,

Thanks for that idea.

I am thinking of the following:

1. Create a virtual table (#TEST) from a SELECT statement that gets all journal entries for the specified GL account BEFORE the specified posting date.

2. Perform a SELECT statement that sums the debit and credit from (#TEST).

This should show the opening balance of the GL account right?

Regards,

Eric

Edited by: eceguerra on May 18, 2011 7:02 AM

Edited by: eceguerra on May 18, 2011 7:02 AM

[Former Member · Accepted solution]

That is what I mean.

[Former Member]

Hello,

Have you check Financial reports ?

Financials > Financials Reports>Financials >Balance Sheet

From Here you have nos of selection creteria.

Thanks

Manvendra Singh Niranjan

Edited by: Manvendra Singh Niranjan on May 17, 2011 11:54 PM