We can successfully import the updated health insurance rates using an import scenario; however, we have to manually set the previous deduction to inactivate it / set the ending date before importing or the import fails. We tried to create a separate import scenario to update existing deductions, but I am not seeing how to differentiate between creating a new deduction vs updating the existing.
SQL is so straight forward in comparison. Update … will update the record. Insert will create a new record. Not seeing comparable in the import scenario.
Any suggestions?