Audit Report for inactive bank account associated with employee payment method

Summary:

Audit Report for inactive bank account associated with employee payment method

Content (required):

Hi Team,

Greetings!

Is there any existing Audit Report for inactive bank account associated with employee payment method?

We have some employees who have the direct deposit payment method with inactive and end-dated bank account associated with it. This is leading to EFT run error for them.

We want to capture such records before payroll run so that the active bank account can be added before EFT run.

pay_bank_accounts table end date does not match with the end date showing up on the bank account of the employee and hence, it is not coming out easily to extract such details.