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"