http://in.compucrete.com/index.php?action=history&feed=atom&title=Cash_Management_Diagnostic_Queries 2026-05-15T17:07:07Z Revision history for this page on the wiki MediaWiki 1.40.0 http://in.compucrete.com/index.php?title=Cash_Management_Diagnostic_Queries&diff=74&oldid=prev 2023-07-14T12:58:48Z

<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=Cash_Management_Diagnostic_Queries&diff=73&oldid=prev 2017-01-10T00:01:27Z

<p>1 revision imported</p> <p><b>New page</b></p><div>==Cash Management Balance vs. G/L Balance==<br /> &lt;pre&gt;<br /> select sum(trx_amount) Cash_Man_Balance,<br /> (select sum(trx_amount) from glttrx where trx_date&lt;=:Bal_Date and gl_account=:Cash_GL_Act) GL_Balance,<br /> sum(trx_amount)-<br /> (select sum(trx_amount) from glttrx where trx_date&lt;=:Bal_Date and gl_account=:Cash_GL_Act) Difference<br /> from cmttrx<br /> where trx_date&lt;=:BAL_DATE<br /> and gl_account=:Cash_GL_Act<br /> and cm_trans_flag='Y'<br /> &lt;/PRE&gt;<br /> <br /> ==Cash Management - Transactions to G/L and not to C/M ==<br /> &lt;PRE&gt;<br /> select gl_account,check_no,trx_date,trx_amount,description_1,description_2,source_app,source_table,source_trans_type, session_no,trans_no<br /> from glttrx<br /> where gl_account=:&quot;Cash G/L Account&quot;<br /> and<br /> NOT (source_app='C' or<br /> (source_APP='P' AND SOURCE_TABLE='C') or<br /> (source_APP='R' AND SOURCE_TABLE='C') or<br /> (source_APP='Y' AND SOURCE_TRANS_TYPE='C') )<br /> AND TRX_DATE&gt;:&quot;Begin Date&quot;<br /> &lt;/PRE&gt;</div>

Intra>User