Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

I am getting duplicate entries in many smart list searches

Posted on by 955

Hello. In many of my smart list searches, especially in the Inventory query area.  The report Items below Order Point Quantity * duplicates each entry.  Overstocked Items duplicates each entry, a report I saved called Quantities on hand duplicates, and Item Quantities *  also duplicates entries. Why? 

Thank you for your attention

*This post is locked for comments

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: I am getting duplicate entries in many smart list searches

    Robin,

    Take a look at the Location Code column - these SmartLists show a line for each location and then a line with the Location Code 'All Sites' that is a sum of all the individual Sites (aka Locations).  Typically you want to either choose to see only 'All Sites' or anything not equal to 'All Sites'.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans