- Check the script where the data is extracted into the report
- as per checking, the script used for extracting the duplicate and discrepancy data has no department filter
- add department filter to the script and test the modified script
- the list of duplicate racks is now ok but the rack discrepancy still not ok when tried generating the report with a range
- as per checking, there is no range applied other than the location in the script when it is extracting data to display in the reports
- modify the script and add the dept, area, rack filter
- test the application for checking if the modification applied
- modification applied and the error is now fixed