Bug #1086 was discovered on 3/24/10.
This is a bug. Although unanticipated user behavior is a factor, the program should anticipate such behavior and block it.
To determine how many procedures are affected, run this report:
SELECT * FROM procedurelog WHERE ProcStatus=2 AND DATE(DateEntryC) < DATE(ProcDate)
This may return a number of false positives. It will also show all procedures that were set complete and future dated, something that is sometimes allowed, but less now than in previous versions.
To find procedures that are significantly mismatched in date
SELECT * FROM procedurelog WHERE ProcStatus=2 AND DATE(DateEntryC) < DATE(ProcDate - INTERVAL 2 DAY)
We are in the process of tightening down the user interface to prevent such issues in the future. But for procedures that already have a date that does not match the appointment, we are reluctant to attempt any sort of automatic fix. There is no way to exclude false positives. But using the queries above, the most significant problems can be manually addressed.
Open Dental Software 1-503-363-5432