Customer Specific Pricing

We are having a few problems with customer specific pricing. (CSP) 

Some details

Pricing set for a certain period with a start and end date.

CSP is deleted after expiry date.

A new CSP gets set up after the end of the old CSP.

When new CSP’s are created the pricing is not always higher than the old CSP. 

The problem we are running into is if there are orders in the system with the old CSP pricing at expiry date.

After expiry date and after the new CSP is created, when we tab through the orders to commit product the new CSP pricing is being picked up and applied to the order.

Is there any way to stop that from happening? To have it retain the old CSP pricing? 

Thank you.