web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Josh P Profile Picture
    Josh P 2,895 on at

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

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at

    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.

  • Rob Klaproth Profile Picture
    Rob Klaproth 1,730 on at

    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?  

  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at

    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

    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

    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

    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!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans