Small and medium business | Business Central, N...

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

(0) Share

Report

Posted on by Samantha73

2,782

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

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Samantha73 2,782 on at

Like (0)

Report

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
Suggested answer

JAngle 83 on at

Like (0)

Report

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