I need help with correcting an issue with a hour-based meter and PM frequency. An asset recently had a PLC upgraded and its physical meter reset to 0. An employee tried to roll over the hours (12,806) after the upgrade but he may not have rolled over the hours correctly, since he noticed the PM associated with the asset shows over 55,000 units to go, even though the PM has a 3500 hour frequency. The employee unsuccessfully tried to correct the issue.
After reviewing the METERREADING records for the asset around the time of the PLC upgrade, I noticed that the rollover value changed while the employee was trying to fix the issue. He said he did not modify the PM. I am not proficient with understanding and troubleshooting meter readings issues and what he could have done that caused the issue. I have attached a spreadsheet with the asset's records for the METERREADING table and a screenshot of our Maximo system information.
Sorry if I missed any important information. I would like to resolve the issue as cleanly as possible, preferably using the Maximo UI over SQL commands. Any help is greatly appreciated!