How to direct AM or Payroll to sum erncds by day before inserting into PAY_OTH_EARNS

Hi,

Working with a client who is using AM and Payroll, no T&L. So Absence Conversion process inserts both retro offsets and latest recalculations directly into PSHUP_TXN. From there they are inserted by a payroll load program to PAY_OTH_EARNS. However, the earning codes are NOT summed by day, so both negative and positive values are inserted.

For example, if the original calculation was 7 and the retro calculated it as 8, instead of inserting a row with 1 hour, we see both -7 and +8 in pay_oth_earns.

Can't find any documentation on this. Will appreciate any suggestions.

Thanks,