Banking Account Register report FSX3004
On the report FSX3004 "Account Register" (Financials>Banking>Reports>Account Register) shows reconciled AR Deposits, the deposit transaction date and the Settlement/Reconciliation Date.
Is there a query or some way to show the bank statement date the deposit cleared instead of the Settlement/Reconciliation Date? We utilize Manual and Semi-Manual reconciling on deposits and the date we actually perform the reconcilement is always different than the actual date the deposit cleared the bank.
I cannot find a link between the AR deposits records and the bank statement table to join the bank statement RECON_BANK_DT.