Somehow, when the sale date is over, (V) This item is on sale check box is still checked.
When we run reports by SalePrice >0 then this still pulls up on the report. So I manually go in to the system to change the sale price to $0.00 and make sure End Date is over.
I have checked SaleType on the query, some of them are showing 1 and 0 and I don't think that is nothing to do with this sale pricing check box.
Does anyone know where I can run query to uncheck sale price?
*This post is locked for comments