When an employee has multiple bank details records (IT0009) we are issuing only one payment advice form. For example, the employee has a main bank and an other bank.
At the bottom of this payment advice we output the amount of the bank transfer. However, the system is issuing the amount of the transfer to the other bank only. We would like to be able to display the total amount being sent to banks for the employee (that is, other bank plus main bank amount).
Do anyone know how we can do this? Since the system issues the payment advice for the first transfer found, and payroll fills BT with the other bank as 01 and main bank as 02, the total amount due to the employee is not available on REGUD at the time that the form is issued. How can we generate a total paid to the employee amount that can be output on the payment advice?