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

Report on selected bank account

Received Response
42
Views
5
Comments
edited Aug 13, 2019 3:56PM in Reporting and Analytics for ERP 5 comments

Summary

I need to report on the selected/default bank account where a colleague may have more than one in the system

Content

Hello,

I need to report on the selected/default bank account a person has in the system as my BIP report will bring back both of them if a colleague has two (or more). I've found bugs/knowledge related to this i.e. Doc 2198323.1 suggests this should be possible using SQL, but Bug 23502153 is raised as there's an Enhancement Request in progress to allow the reporting on this from OTBI.

Following the logic provided on the Doc above, I've attached my SQL but this still brings back both bank accounts. Is anyone able to help please? Or is anyone able to confirm if this isn't yet possible before the ER is in place?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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