Cash Management Diagnostic Queries

Cash Management Balance vs. G/L Balance

select sum(trx_amount)  Cash_Man_Balance,
(select sum(trx_amount)  from glttrx where trx_date<=:Bal_Date and gl_account=:Cash_GL_Act) GL_Balance,
sum(trx_amount)-
(select sum(trx_amount)  from glttrx where trx_date<=:Bal_Date and gl_account=:Cash_GL_Act) Difference
from cmttrx
where trx_date<=:BAL_DATE
and gl_account=:Cash_GL_Act
and cm_trans_flag='Y'

Cash Management - Transactions to G/L and not to C/M

select gl_account,check_no,trx_date,trx_amount,description_1,description_2,source_app,source_table,source_trans_type, session_no,trans_no
   from glttrx
where gl_account=:"Cash G/L Account"
and
NOT (source_app='C' or
 (source_APP='P' AND SOURCE_TABLE='C') or
 (source_APP='R' AND SOURCE_TABLE='C') or
 (source_APP='Y' AND SOURCE_TRANS_TYPE='C') )
AND TRX_DATE>:"Begin Date"