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
Skip to content
  • Register

    • Report on selected bank account

    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?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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