I have this SQL query I ran to find duplicate UPCs in RMS:
SELECT ItemLookupCode, ItemLookupCode, COUNT(*) FROM Item GROUP BY ItemLookupCode, ItemLookupCode HAVING COUNT(*) > 1
Am I able to insert this into a custom report so I can have the ability to bring up the item properties window and make changes from there? I guess an extended question is on custom reports, where do I put the SQL queries?
Thanks for your help!
I have this SQL query I ran to find duplicate UPCs in RMS:
SELECT ItemLookupCode, ItemLookupCode, COUNT(*) FROM Item GROUP BY ItemLookupCode, ItemLookupCode HAVING COUNT(*) > 1
Am I able to insert this into a custom report so I can have the ability to bring up the item properties window and make changes from there? I guess an extended question is on custom reports, where do I put the SQL queries?
Thanks for your help!
Have something to add? Share your thoughts — no account required.
Ask the community — no account required