BIP Report to get Employees with Bank Accounts not assigned in a Payment Method
Summary:
Hello everyone,
I am trying to create a report where I want to get a list of employees who have bank accounts that are not tied to any Personal Payment Method. This is to let employees know that these bank accounts should have associated Payment Methods to them
Content (please ensure you mask any confidential information):
I am trying to generate a BIP report to select employees whose bank accounts are not associated with a payment method. I do not think it's entirely accurate just to get the PAY_PERSON_PAY_METHODS_F where BANK_ACCOUNT_ID is NULL since it is possible for multiple payment methods to be associated to only one Bank Account. If you have a query that links the person to their bank account, that would be really helpful.
Tagged:
0