Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What table stores the system transactions reference number for Bank Statement (CE) reconciled items

edited Jun 22, 2022 9:38PM in Reporting and Analytics for ERP 2 comments

Summary:

We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions lines, we cannot find the Reference number (i.e., check number from Payables) within the CE reconciled items tables. Navigation to the page we want to replicate is Cash Management>Bank Statements and Reconciliation>Manual Reconciliation>Search up specific bank statement id>Reconciled tab. We are getting all the right results with our query but the CE_RECON_HISTORY_ITEMS table, which has the system transactions in it, returns null for the Reference field on all system transactions. Again, these are for RECONCILED items - not items available

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!