We have some items that are double-built in the system. Also some that are the “same” but have different “Search Key”.
What would you suggest is the best report(s) to generate to find the duplicates and the Search Key?
If you go into the Inventory menu, you can type FINDDUPS at the selection line to run a "hidden" function. Select "4" for "all files" and the first time you run it select "No" to "delete duplicates". This will find duplicate items in the master, store and vendor files. If you want the system to clean them up for you, you can run it again selecting "Yes" to "delete duplicates". The system will delete every second record which printed on the report.