SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINES
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.
0