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 / Small and medium business | Business Central, N... / Dynamics Business Cent...
Small and medium business | Business Central, N...
Answered

Dynamics Business Central Online - Customer Report Extension: The operation could not complete because a record in the Sales Invoice Header table was locked by another user. Please retry the activity.

(0) ShareShare
ReportReport
Posted on by Julnio Vasquez 5

We have developed an report extension that is being run by multiple users, however we are getting the following error when you have more than 1 user running the report in the same tenant, same database but different database records:

The operation could not complete because a record in the Sales Invoice Header table was locked by another user. Please retry the activity.

Any idea how to resolve this? I've seen some solution of killing the Session ID of the user who is locking, but do not want to have to keep doing this. Is this a design issued of the report, where maybe they read portion and the write portion need to be segregated or is this just a limitation of BC when you create report extensions? 

Any help would be greatly appreciated.

Thank you

Jay

Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
  • Verified answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

    It is usually based on the design of the report. If the report changes some data, there is a need to lock.

    However, if the report only reads the data, there shouldn't be any locking problem. You should modify the report code to lock only when it is necessary.

  • Anks27 Profile Picture
    Anks27 1,087 on at

    Solution is don't use any out of box report template, create the report from scratch, this is probably Microsoft BUG , we also faced same issue but during troubleshooting i suddenly realized this and found this solution.

    If we are creating same sales invoice report from scratch then it's working fine without deadlock issue, we have checked our all custom reports and all reports are working fine without any issue specially this "locked by another user".

    Thanks,

    Ankit Shah

  • logilun Profile Picture
    logilun 50 on at

    I strongly disagree to you answer.

    1: Your conclusion is all MS reports have issues. That does not fit to my many years experiences with Navision.

    2. Your suggestion is econamically questionable. Do you really want to create every report a customer needs from scratch!?

    Maybe dig into Navision and try to understand processes and funcations of Navision would help much to understand behaviour and customize the right solution.

  • Anks27 Profile Picture
    Anks27 1,087 on at

    Yes once upon a time i was also not agree but this is reality and fact, i don't know for all reports but i'm talking about sales invoice report where sales invoice header table used and that table is currently locking for multiple users.

    When we faced exactly same issue that time we didn't realize but after troubleshooting and research we got an idea for scratch report and that works for us.

    Issue was if you generate the sales invoice report for more than 1500 invoices by different users at same time then only this locking issue occurring which we solved by creating the new report by scratch.

    Now multi users/department can run the reports for bulky invoices at a same time.

    @logilun you can also replicate same scenario at your end.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans