Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Invoice Electron...
Finance | Project Operations, Human Resources, ...
Answered

Sales Invoice Electronic Report Showing Duplicate Lines

(0) ShareShare
ReportReport
Posted on by MA-07051407-0 41

Hi, 

I have configured the sales invoice report in Electronic reporting and I am using same format for other legal entities as well. The issue is Report is Working Fine for One Legal Entity but showing duplicate Lines for other legal entity. The Report was working fine until we updated the version to 10.34. I tried to figure out all possible option but no luck.

I am sharing screenshots for the invoices in both legal entities. Below invoice showing duplicate data

 

  • MA-07051407-0 Profile Picture
    MA-07051407-0 41 on at
    Sales Invoice Electronic Report Showing Duplicate Lines
     Hi,
    Thanks for the response, Your suggestion really helps to fix the issue.
    Thanks
  • Verified answer
    SL-23080902-0 Profile Picture
    SL-23080902-0 7 on at
    Sales Invoice Electronic Report Showing Duplicate Lines
    We had the same problem and it was related to the feature "(Italy) Sales invoice lines sorting per packing slips" that was enabled when we upgrade.
    We dont use Standard SSRS reports for invoices so I dont know what the best way is to solve the problem there. We have the ISV Lasernet and there we fixed it with a script by taking out the field FIELD_SalesInvoiceTmp_InvoiceReportLineType_IT and put on a critera on the pattern we have on the invoice line.
     
     
  • MA-07051407-0 Profile Picture
    MA-07051407-0 41 on at
    Sales Invoice Electronic Report Showing Duplicate Lines
    Hi Kevin;
    Thanks for your response, The issue is same report is working fine for two other legal entities but only for ITALY legal entity facing the duplication issue. Even the Model is same as available on Microsoft didn't drive and didn't change anything.
    Can i write some kind of validation script to check the line duplication in the report.
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Sales Invoice Electronic Report Showing Duplicate Lines
    Hi,
    Depending on the problem you described, it seems that there are many reasons for your problem, specifically the following:
    • Check entity configuration settings: Review the configuration settings differences between the legal entity with the issue and the legal entity that is working fine. Ensure that the configuration settings, system settings, and data settings are consistent across the two entities.
    • Verify the data source: Check the data source and data queries used in the report. Confirm that the data source is correctly connected to the appropriate entity data and tables. Ensure that the data queries do not return duplicate rows.
    • Review report design: Check the design and definition of the report. Ensure that there are no duplicate data sources or data fields in the report. Verify that the calculation logic and filtering conditions in the report are correct.
    • Check the report processing: Confirm that there are no errors or duplicate steps in the report processing. Check if there are multiple report tasks or processes running concurrently that may result in data duplication.
    Best regards,
    Kevin

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans