Discussions
How to remove duplicate Records showing in Item Saved Search Results?
Item Saved Search
Issue - Saved search shows duplicate records
Criteria - All items with Status = Active/Extension
What is causing duplicate records - Reports shows all the items with active/extension status
If the service item has any change example - Bill Rate, Pay Rate, Hourly cost, then the name of service item would be changed
Example -
Service Item - HP Singh_3052 - This was initial created service item
New Service Item - As pay rate has been changed so a new service item got created
Updated service item name - HP Singh_3052_Eff.3/27/23
Saved search shows all the service item old and updated both causing it duplicate records, as both status are active/extension