some times that out of range error could be due to a bad data point in the wrong field. The common cause is a barcode number got entered by accident in a different field (ex: quantity, price, cost, etc.). Try doing advanced Find search 'greater than 1,000' on those fields, hopefully you find the outlier.