http://in.compucrete.com/index.php?action=history&feed=atom&title=GL_Trial_Balance_QueryGL Trial Balance Query - Revision history2026-05-15T16:10:13ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=GL_Trial_Balance_Query&diff=224&oldid=prevWikiAdmin: 1 revision imported2023-07-14T12:58:50Z<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr>
<!-- diff cache key my_wiki:diff::1.12:old-223:rev-224 -->
</table>WikiAdminhttp://in.compucrete.com/index.php?title=GL_Trial_Balance_Query&diff=223&oldid=prevIntra>User: 1 revision imported2017-01-10T00:01:42Z<p>1 revision imported</p>
<p><b>New page</b></p><div>[[Category: Balancing]]<br />
[[Category: General Ledger]]<br />
[[Category: SQL]]<br />
<br />
<PRE><br />
select GL_Account Account,Description Name,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :PD_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') Cur_Pd_Amt,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date <= :PD_End_Date and gta.trANS_type<>'B') End_Amt<br />
from gltacct ga <br />
where ga.account_type='B' <br />
group by gl_account,Description<br />
union <br />
select GL_Account Account,Description Name,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :PD_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') Pd_Amt,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :yr_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') End_Amt<br />
from gltacct ga <br />
where ga.account_type='I'<br />
group by gl_account,Description<br />
</PRE><br />
<br />
With Begin Amt column:<br />
<PRE><br />
select GL_Account Account,Description Name,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date <:PD_beg_Date and gta.trANS_type<>'B') "Begin Amt",<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :PD_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') "Current",<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date <= :PD_End_Date and gta.trANS_type<>'B') "Ending Amt"<br />
from gltacct ga <br />
where ga.account_type='B' <br />
group by gl_account,Description<br />
union <br />
select GL_Account Account,Description Name,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :yr_Beg_Date and (-1 + :PD_beg_Date) and gta.trANS_type<>'B') BeginAmt,<br />
<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :PD_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') Pd_Amt,<br />
(select sum(gta.trx_amount) from glttrx gta where ga.gl_account=gta.gl_account <br />
and gta.trx_date between :yr_Beg_Date and :PD_End_Date and gta.trANS_type<>'B') End_Amt<br />
from gltacct ga <br />
where ga.account_type='I'<br />
group by gl_account,Description<br />
</PRE><br />
<br />
<br />
[[Most Excellent Queries]]</div>Intra>User