http://in.compucrete.com/index.php?action=history&feed=atom&title=DataScope%3A_A%2FR_G%2FL_transactions_by_SourceDataScope: A/R G/L transactions by Source - Revision history2026-05-15T17:07:24ZRevision history for this page on the wikiMediaWiki 1.40.0http://in.compucrete.com/index.php?title=DataScope:_A/R_G/L_transactions_by_Source&diff=100&oldid=prevWikiAdmin: 1 revision imported2023-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>WikiAdminhttp://in.compucrete.com/index.php?title=DataScope:_A/R_G/L_transactions_by_Source&diff=99&oldid=prevChanson at 16:45, 15 March 20192019-03-15T16:45:26Z<p></p>
<p><b>New page</b></p><div>This assumes the G/L account is set to the AR class.<br />
<br />
<PRE><br />
SELECT X.*,A.SEGMENT_1 ACT,a.ACCOUNT_TYPE,A.ACCOUNT_CLASS,A.DESCRIPTION "Act Name",<br />
X.SESSION_NO/1000 X1<br />
FROM GLTTRX X<br />
INNER JOIN GLTACCT A ON A.GL_ACCOUNT=X.GL_ACCOUNT<br />
WHERE X.TRX_DATE BETWEEN :Beg AND :End<br />
and account_class='AR'<br />
</PRE><br />
<br />
[[File:DS_ar_gl_sumbysrc.PNG]]<br />
<br />
When looking for mismatched g/l data look for:<br />
*Entries from other apps the A/R ('''R''')<br />
*Entries with incorrect SOURCE_TRANS_TYPE. (Expect IR,CR,SR. "IS" is ok if it sums to 0, this is from voids)<br />
<br />
In the example above the values for CA are from an allowance code offset account being the A/R account resulting in a Sum zero transaction.</div>Chanson