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

SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINES

edited Dec 6, 2023 1:13PM in Reporting and Analytics for ERP 2 comments

I'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of bank statements with a system that interfaces with Oracle based on this report.

We've found that because of how Internal Bank Transfers work (without Payment in Transit suspense account), sometimes the payment is expensed at the payee's side in a different period than expected/intended. If we can query the transaction date of the IBT rather than the value/booking date of the bank statement line, that would help us solve this issue.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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