Please make the over-ride rate function go away. It makes all integrity with a rate code disappear.
Instead create a Rate Variance Report. Any rate that is changed will be reflected in a Rate Variance Report that can be viewed daily by management - it can be printed during the Night Audit. For Example BAR = $100, rate on room was $90, Variance is -$10.00. The goal will be for the variance to be zero.