RE: Does anyone else have an issue with the wrong address on a PayStub reprint?
Here is what I found by further testing. We were using a modified report, but the results are the same either way and it doesn't follow your explanation.
Two address ID's, OLD and PRIMARY. Employee card is PRIMARY when paycheck was created. Recreated PayStub prints OLD. Change Employee Card to OLD. Recreated PayStub prints OLD.
Now delete OLD address and it prints PRIMARY. Add ZZZ address, it prints PRIMARY. Add OLD address, it prints OLD.
So it seems to always print the first one alphabetically.
This is GP2016.
A trace shows this SQL statement:
exec LHI.dbo.zDP_UPR00102F_1 'SMITCHRI','','SMITCHRI','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
which is selecting all addresses for the employee.
Where does it store the address that was used originally used?