Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Export to Excel found duplicate record

Posted on by 513

Hi Experts,

We are getting more duplicate records while exporting the data into excel.

1. Excel version - 2007.

2. AX version  - AX 2009 SP1.

Kindly give me a suggestion to do the some R&D about this issue.

Thanks in advance and Regards,

Vignesh 

*This post is locked for comments

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Export to Excel found duplicate record

    Hi Vignesh,

    I'm afraid you have to go for debugging or get a person on-site to help troubleshooting this.

  • Vignesh R Profile Picture
    Vignesh R 513 on at
    RE: Export to Excel found duplicate record

    Hi Ludwig,

    Thanks for your response.

    In our test environment, we are not facing this kind of issue. Problem with only Production environment.

    Thanks in advance and regards,

    vignesh

  • Vignesh R Profile Picture
    Vignesh R 513 on at
    RE: Export to Excel found duplicate record

    Hi Andre,

    In my case, we are facing issue with exporting general ledger transaction and Customer transactions into excel using export to excel button.

    For few transactions only, we are facing this kind of issue.

    Thanks in advance and regards,

    vignesh

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Export to Excel found duplicate record

    Hello Vignesh R,

    I have checked LCS and found no hint on a problem with the Excel export functionality.

    As AX2009 is already out of the main support you will have to get some help from a developer and try to fix the issue yourself.

    It might be due to a modification as Andre mentioned, corrupted or manipulated data.

    In any case, try to replicate the issue on your demo/test machine and get some help from a developer to get this fixed.

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at
    RE: Export to Excel found duplicate record

    Hi Vignesh,

    Can you tell what exact data you are exporting to Excel and how? If you have a custom solution, you can check the query for possible join issues.

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