Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Duplicate records retu...
Microsoft Dynamics GP (Archived)

Duplicate records returned in SmartList Viewer

(0) ShareShare
ReportReport
Posted on by Rob Klaproth 1,730

I am using the SmartList Viewer templates provided by Microsoft, this one is called Receivables transactions.  This SmartList shows only document types of return or credit memo, and I am showing the apply to document information on the SmartList.

When I run the report, it is showing duplicate rows, i.e. the same credit memo applied to the same document applied to the same amount for some of the transactions.  Does anyone know why this would happen or how I can prevent it from showing duplicates?

Thanks!

*This post is locked for comments

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Duplicate records returned in SmartList Viewer

    Mike, her view does work great - of course if there were multiple applies to a return then it will look like there are duplicates when in fact the return was applied to multiple docs, so that scenerio should be fine.  Under the SmartList default template scenerio, we get 80 rows returned, with Victorias I get 75, so it looks great.

    Thanks for the prompt response!

  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at
    RE: Duplicate records returned in SmartList Viewer

    It looks like Victoria has something similar here:

    victoriayudin.com/.../sql-view-with-ar-apply-detail

    Looks like she is accounting for the scenario using Inner Joins.

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Duplicate records returned in SmartList Viewer

    Mike, can you point me to where I can find a view, should I check out Victoria's site? LOL

  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at
    RE: Duplicate records returned in SmartList Viewer

    Yes, the Return has been fully applied, this is the History records as you have noted. The Invoice is likely still open and has the apply history between it and the Return still in Open/Work. In this scenario, a SQL view is the best option, combining History and Open/Work where apply records do not exist for the same records across the tables.  I use a "WHERE NOT IN" scenario in my view but this can probably be done other ways.

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at
    RE: Duplicate records returned in SmartList Viewer

    There are no asterisks next to the document in the inquiry screen.   One of the documents is a return in history and was FULLY APPLIED to one document, however the return amount does not fully equal the amount of the invoice it was applied to, could that be creating duplicates?  

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    RE: Duplicate records returned in SmartList Viewer

    While I'm not sure of the exact scenario in this SmartList, if you are looking at Apply History and Apply Open/Work, a duplicate scenario can/will exist in the scenario where one of the documents is in History ($0 balance) and the other is in Work/Open (has current open balance). The best way to handle this (that I've found) is the use of a SQL view where you take into account the duplicate records across the History and Work/Open scenario.

  • Josh P Profile Picture
    Josh P 2,895 on at
    RE: Duplicate records returned in SmartList Viewer

    When you view this in the document inquiry screen, are there little asterisks next to any of the entries?

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans