The query that picks special pricing priority chooses the earliest Begin_Date with no other options ORDER BY Begin_Date ,End_Date,UOfM ASC If special pricing gets added for an item that already has some in place, SalesPad will always select the pr...