http://in.compucrete.com/index.php?action=history&feed=atom&title=G%2FL_Balancing_Queries
G/L Balancing Queries - Revision history
2026-05-15T17:06:01Z
Revision history for this page on the wiki
MediaWiki 1.40.0
http://in.compucrete.com/index.php?title=G/L_Balancing_Queries&diff=212&oldid=prev
WikiAdmin: 1 revision imported
2023-07-14T12:58:50Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="en">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:58, 14 July 2023</td>
</tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>
WikiAdmin
http://in.compucrete.com/index.php?title=G/L_Balancing_Queries&diff=211&oldid=prev
Intra>User: 1 revision imported
2017-01-10T00:01:41Z
<p>1 revision imported</p>
<p><b>New page</b></p><div>==Quick Balance Query==<br />
<PRE><br />
select session_no, sum(trx_amount) from glttrx<br />
where trans_type<>'R'<br />
group by session_no<br />
having sum(trx_amount)<>0<br />
</PRE><br />
<br />
==Quick Verify Income Statement vs. Balance Sheet Total==<br />
<PRE><br />
select 'BAL_SHT',sum(gt.trx_amount) amount from glttrx gt inner join<br />
gltacct ga on ga.gl_account=gt.gl_account <br />
where trx_date <= :end_date and ga.account_type='B'<br />
union<br />
select 'INC_STM',sum(gt.trx_amount) amount from glttrx gt inner join<br />
gltacct ga on ga.gl_account=gt.gl_account <br />
where trx_date BETWEEN :Yr_Beg_Date and :end_date and ga.account_type='I'<br />
</PRE><br />
<br />
<br />
<br />
==G/L Before Year End entered after Closing Year==<br />
<PRE><br />
select gl_account,trx_date,trx_amount,description_1,description_2,session_no,trans_no,last_change_datetime,last_change_user <br />
from glttrx where trx_date <=(select max(trx_date) from glttrx where trans_type='R') <br />
and session_no> (select max(session_no) from glttrx where trans_type='R')<br />
</PRE></div>
Intra>User