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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Multiple query Updating issues

(1) ShareShare
ReportReport
Posted on by



Here I am updating multiple queries in TmpTable for the Ganarter SRS report. When I was trying to generate the report, I got this error, so can you please tell me how to solve it? 

Error Is /update conflict occurred due to another user process deleting the record or changing one or more fields in the record./

I have the same question (0)
  • Suggested answer
    Waed Ayyad Profile Picture
    9,061 Super User 2026 Season 1 on at
    Hi,
     
    Try to add  YourTmpTable.reread(); statement after the ttsBegin; statement, and why you added YourTmpTable .selectforUpdate(true) again?
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
     
  • André Arnaud de Calavon Profile Picture
    303,139 Super User 2026 Season 1 on at
    Hi,
     
    On which select statement do you get the error? The first one or the second? What is your report about? I do see a crosscompany statement in the select query. Do you really have data from different legal entities? If so, you can probaby better make this table no dependent on the dataareaid, but have an own CompanyId field.
     
    You are joining several tables. Could it be the case that you have multiple records in the purchPrepayTable and PurchReqTable for a single BSInvoiceToPaymentReportTmp record?
     
    When you have a forUpdate statement in the select query, the separate call before the update() statement is obsolete.
  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    3,634 Moderator on at
    Tell me one thing. If report is running in a legal entity, why do you need to update temp table in different legal entity via cross company?
     
    As Andre suggested, selectforupdate is not required.
     
    A good approach while updating data is to use changecompany instead of crosscompany.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 576 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 366

#3
Adis Profile Picture

Adis 256 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans