http://in.compucrete.com/index.php?action=history&feed=atom&title=GL_All_Transactions_Related_to_an_Account 2026-05-15T18:01:29Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=GL_All_Transactions_Related_to_an_Account&diff=218&oldid=prev 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=GL_All_Transactions_Related_to_an_Account&diff=217&oldid=prev 2021-04-16T12:57:26Z

<p>Created page with &quot;==GL All Transactions Related to an Account== &#039;&#039;&#039;01/15/2020&#039;&#039;&#039; This query returns all transactions from all sessions that have activity for the selected account and date rang...&quot;</p> <p><b>New page</b></p><div>==GL All Transactions Related to an Account==<br /> '''01/15/2020''' This query returns all transactions from all sessions that have activity for the selected account and date range when the activity is created in G/L or C/M.<br /> <br /> &lt;PRE&gt;select distinct(x.session_no) sno,xx.trans_no,xx.gl_account, a.description, xx.trx_date, xx.source_code, xx.source_app, xx.trx_amount, session_no from glttrx x<br /> inner join glttrx xx on xx.session_no=x.session_no<br /> inner join gltacct a on a.gl_account=xx.gl_account<br /> where x.source_app in('C','G') and x.trx_date between:Begin_date and:End_date<br /> and x.gl_account = :&quot;Acct&quot;<br /> order by session_no<br /> &lt;/PRE&gt;<br /> The main query selects all sessions that contain gl activity for the selected account and date range with glttrx aliased to X. Then this is inner joined to XX which selects all of the activity from each of those sessions. It's important to specify xx.&lt;fieldname&gt; in the select query to get the individual transaction information. For the same reason GLTACCT is joined to XX.<br /> '''NOTE:''' make sure to keep the distinct(x.session_no) and xx.trans_no as the first 2 fields. This makes sure that each transaction is included AND only included once. If you remove the distinct then you'll get duplicate transactions. If you remove trans_no then similar transactions will be merged.</div>

Chanson