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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / SmartList showing dupl...
Finance | Project Operations, Human Resources, ...
Suggested answer

SmartList showing duplicates - Sales

(1) ShareShare
ReportReport
Posted on by RM-28051521-0 13
The Sales smartlist is showing duplicate lines for certain customers.  Can someone help with the fix? Below is the SQL view.
 
select 
* from (select * from [<<COMPANY_ID>>]..slbCustomers with (NOLOCK)) T1 
 INNER JOIN [BCEW].dbo.[_DSI_Customer_Email_Info] T2 with (nolock) 
 on 
 T2.[Customer ID] = T1.CUSTNMBR and  T2.[Address ID] = T1.ADRSCOD
 
 
Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Raj Borad Profile Picture
    Raj Borad 1,337 on at
    SmartList showing duplicates - Sales
     
    This maybe occurs because of multiple records related to contact/email in the customer.
     
    Try to use, Distinct or Top1 in your query.
    You can also aggregate that Email before joining..
     
    Thanks.
  • Devon Southall Profile Picture
    Devon Southall 160 on at
    SmartList showing duplicates - Sales
    We can't help you because at least "_DSI_Customer_Email_Info"  is a custom view/table that we are not familiar with.
    if you give us that SQL object in detail we might be able to help.
     
    Best,
    Devon
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 330 on at
    SmartList showing duplicates - Sales
    Hello,
     
    This is not an Answer, but perhaps a way to find out if it is duplicating due to the Customer having multiple address codes assigned to them as Raj pointed out. It also appears this is a cross company Smartlist. If the customer is in multiple companies, this could be why as well. It could also be helpful to provide a screenshot of what you are seeing as Duplicates to help determine if it is an actual duplicate or if it is due to different company/multiple addresses.
     
    1. Determine on the Smartlist one Customer that is Duplicating results and one that is not duplicating results. 
    2. Go into GP and look at the Customer Address Maintenance window.
      1. Sales | Cards | Addresses.
    3. Enter the customer that is duplicating.
    4. Click the arrow key next to Address ID and see if they have multiple addresses assigned.
    5. Next, enter the Customer that is not duplicating.
    6. Click the arrow key next to the Address ID to see if they have multiple addresses.
    7. If one has multiple addresses but the other does not, this could be why it appears to be duplicated.
    8. You can then add another address ID to the customer that only has a single address and then see if the Smartlist now shows a duplicate for them.
    9. To rule out if it is due to the multicompany, you can create a customer and address in another company that replicates one of the Customers that is not duplicating and then see if it duplicates to determine if it is caused by being in multiple companies.
     
    If this is not the cause, then there is likely something with the _DSI_Customer_Email_Info table/view that is returning multiple results for the same record. As Devon said, we would need to see this information as well as the data in the table this is pulling from to be able to determine this.
     
    If you are not able to determine this, I would suggest reaching out to your partner to let them have a look at your environment. 
     
    If you do not have a Partner, Enavate would be happy to take a look with you to see what is going on with your Smartlist and provide recommendations on how to stop it from returning duplicates.
     
     
    I hope this helps!
     
    Thank you!
     

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 867 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans