Is it possible in a sales discount, to configure it to only apply if the price is the standard price. And to ignore the sales discount, if a specific price prices (For a given period) has been configured on the product?
If ProductDBPrice > ProductActualPrice Then
Ignore sales discount on product