For given equipmment when i am checking offhire activity(DOLC) date is wrong in EMS.
For eg. equip#TTNU1857130 , DOLC has been added in EMS on 26/04/2012 /04:53 with activity date 19/02/2012 23:00 while last activity RMTY has been added on 22/03/2012 18:42 with activity date 19/03/2012 22:00. ie location has added DOLC activity with wrong date. Location should give correct DOLC date in EMS while adding activity. All equipment given by you have wrong DOLC date that's why inventory report showing those record with error. Please ask location to correct DOLC date in EMS. If equipment is offhired then DOLC should be last activity in EMS. Please find attached file for your reference.
There is some data issue in EMS table for equipment TGHU7220745,TTNU9941891,REGU4982434 . we will correct record in EMS for these equipment.