Insert/Update doesn’t allow updates, only inserts new Records Sage 300 payroll premium, Sage 2020

Previously I could either insert or update records using that drop down option when importing records using dbase5. Now I have to use .csv to import, the Insert/Update option is there but you get an error “Record already Exists” when trying to update. Trying to use the Update option only also fails.