Multiple Worksite report reporting old location for work from home employees.

Summary:

While running multiple worksite reports for the US we have encountered an issue that works for home employees who has multiple assignment record (old and active), archive process is erroring out as the process is getting 2 location record for a single employee from reporting information cal card. One from old assignment and one from active assignment.

Is there a process (automatically changing the reporting information location to active assignment) or HDL to end date the reporting information component?