Amount Reconciled is not showing the correct amount reconciled for the statement line
I have an issue with Bank Statement reconciliation. The reconciled amount on the Statement lines form is not same as from ce_statemenrt_lines (tried with query behind tables
I am trying the same amounts from database tables. Data is not the same as it is from the form.
SELECT *
FROM (
SELECT
SH.STATEMENT_NUMBER,
SD.STATEMENT_LINE_ID,
SD.LINE_NUMBER,
SD.TRX_TYPE,
SD.TRX_CODE_ID,
SD.AMOUNT,
SD.STATUS,
SUM(S.AMOUNT) RECON_AMOUNT,
SH.STATEMENT_DATE,
SUBSTR(SH.STATEMENT_DATE,4,6) PERIOD
FROM CE_STATEMENT_RECONCILIATIONS S,
CE.CE_STATEMENT_HEADERS SH,
CE.CE_STATEMENT_LINES SD