DataScope: A/R G/L transactions by Source

This assumes the G/L account is set to the AR class.

SELECT X.*,A.SEGMENT_1 ACT,a.ACCOUNT_TYPE,A.ACCOUNT_CLASS,A.DESCRIPTION "Act Name",
X.SESSION_NO/1000 X1
 FROM GLTTRX X
INNER JOIN GLTACCT A ON A.GL_ACCOUNT=X.GL_ACCOUNT
WHERE X.TRX_DATE BETWEEN :Beg AND :End
and account_class='AR'

When looking for mismatched g/l data look for:

• Entries from other apps the A/R (R)
• Entries with incorrect SOURCE_TRANS_TYPE. (Expect IR,CR,SR. "IS" is ok if it sums to 0, this is from voids)

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.