Inactive Rate Shows up in the Salary Basis Config Page and also in the transaction

Summary:

Inactive Rate Shows up in the Salary Basis Config Page and also in the transaction

Content (please ensure you mask any confidential information):

Hi Team,

We have a rate and need to make changes in the logic (Category of the Rate to be changed). Hence I have made the rate inactive, but it still shows up in the Salary Basis Config page and during the transaction.

I can not Remove the Rate as there are Salary Records in the system.

What is the best solution in this scenario? Creating a New Salary Basis?

Please share your thoughts and suggestion.