Error message running AR report

(1) Share

Report

Posted on by tb513

When trying to run an AR report, I am getting the following message: "Cannot insert a record. Current connection intent is Read-Only." I can run an AP report just fine and I can run all other customer reports. It is only this one report that I get this message for.

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

JAngle 133 on at

Like (0)

Report

That report only inserts into temporary tables which any license type can use. Could be a bug. So other user’s experience the same?

Was this reply helpful? Yes No
tb513 48 on at

Like (0)

Report

Other users have been able to log in and run the report just fine. At the moment it seems to be just me having this issue.

Was this reply helpful? Yes No
Suggested answer

THE Italian on at

Like (1)

Report

Try searching for "Database Access Intent" then select the aforementioned report and change the Access Intent to explicitly "Allow Write"

Was this reply helpful? Yes No
tb513 48 on at

Like (0)

Report

I just tried that and am still getting the same error message.

Was this reply helpful? Yes No
JustAK6 171 on at

Like (0)

Report

I am getting the same error as are others in our organization.

Only an issue with the Aged Accounts Receivable report that I am experiencing so far.

Was this reply helpful? Yes No
JustAK6 171 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

JustAK6 171 on at

Like (2)

Report

Found in the Database Access Intent Listing two Aged AR reports. Try change report id 10040. That fixed it for me. Would like to know why it has changed however - might still be bug.

Was this reply helpful? Yes No
tb513 48 on at

Like (0)

Report

Changing the report id 10040 to 'Allow Write' fixed the problem. I must not have realized there were two reports the last time I went it to try and solve it. All is good now. Thanks!

Was this reply helpful? Yes No
JustAK6 171 on at

Like (0)

Report

Good to hear! I still want to understand why this started occurring and only on this report.

Was this reply helpful? Yes No
tb513 48 on at

Like (0)

Report

I thought the same thing. I was the only person in our company who was getting this message, but I am also the only person who had a plugin for credit card payments, so am wondering if that had something to do with it after the latest BC updates?

Was this reply helpful? Yes No