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 :
Small and medium business | Business Central, N...
Suggested answer

Cannot modify a record. Current connection intent is Read-Only. - Custom Report Error

(0) ShareShare
ReportReport
Posted on by 3,197

Hi Guys

I have created a copy of standard report 113 in vs code (customer item/sales) and try to run it after publishing (v17.5 BC), but I get the below error:

"Cannot modify a record. Current connection intent is Read-Only."

Unlike other reports, this report contained multiple restrictions, and this is one of them, and I'd like to understand this error before changing access levels etc.

Thanks

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    121 on at
    RE: Cannot modify a record. Current connection intent is Read-Only. - Custom Report Error

    My understanding is this is only applicable if you intend on using a replica DB to run the report. Is that your intention? docs.microsoft.com/.../devenv-dataaccessintent-property

    The report itself - standard - only does one modification and that’s to a valueentrybuffer table which is temporary anyway. So it is a property related error based on using replicas only

  • Samantha73 Profile Picture
    3,197 on at
    RE: Cannot modify a record. Current connection intent is Read-Only. - Custom Report Error

    Thanks, Josh, I did read that document I'm bemused by the error as we are looking at a BC SaaS system without using a replica etc.  The question is why the standard report is coded with

    " DataAccessIntent = ReadOnly" setting and this is not working on a copy in exactly the same environment. Once above is removed report works but clearly we are missing something here

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

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…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,761

#2
Sumit Singh Profile Picture

Sumit Singh 2,611

#3
YUN ZHU Profile Picture

YUN ZHU 1,975 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans