What's new in Customer Journeys?

Connect and learn more! ×
Bank statement balances check report — Cloud Customer Connect
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

Bank statement balances check report

Question
36
Views
0
Comments
edited Sep 13, 2019 11:32AM in Reporting and Analytics for ERP

Content

Crossposting here from the Cash Management forum as per Oracle's suggestion.

We want to have a report that shows bank statements for which the subsequent bank statements opening and closing balances do not match, indicating a missing or erroneous statement.

Currently, I've come up with the below code but there's one problem: If there's multiple statements in each day, this SQL does not work. I've checked some samples and in each case where there were more than 1 statement on a day, it was always only 2. In these cases, the statement that should be seen as the 'first' statement of that day, always had a statement_to date which was smaller than the statement_to date of the subsequent statement.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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