web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

"This record has been changed since you opened the window. Changes won't be saved" at Note field

(0) ShareShare
ReportReport
Posted on by 208

Hi All, 

I got an error whenever I edit or delete the NOTE FIELD in Sales order Entry window. Error is below: 

"This record has been changed since you opened the window. Changes won't be saved" 

Can any one tell me the reason why it is happening ?. 

Thanks ,

Pavan

Categories:
I have the same question (0)
  • Suggested answer
    Hokuminaria Profile Picture
    2,950 on at

    Hello PavanBujji,

    Most time when we see this error message, it is due to a trigger on the table that is not a core GP Trigger. I believe this will be on the SY03900 or the SOP10100 table. 

    The triggers i have on these tables are:

    SY03900  -- No Triggers.

    SOP10100 -- zDT_SOP10100U  -- tr_SVC_SOP10100_D  --  sopWFupdateSOP10104

    Use the scripts below to review the triggers on these tables.

    SP_Helptrigger SOP10100
    SP_Helptrigger SY03900

    If you have any additional triggers on these tables, test disabling it and determining if the issue still occurs. If it does still occurs, can you provide the results of the script below to look at all your triggers you have on your tables.

    select substring(b.name,1,50) as TriggerName,a.name as TableName
    from sysobjects a join sysobjects b on
    a.id = b.parent_obj
    where
    b.xtype = 'TR' order by TableName

    I will then be able to compare your triggers to mine in hopes of determining which extra ones you have.

    I hope this helps!

    Microsoft Support Engineer | Brandon Jarrett

  • PavanBujji Profile Picture
    208 on at

    Thanks for responding Brandon.

    I have verified the Triggers on SOP10100 Table and I had an extra trigger on SOP10100 named as "MSO_Trigger_SOP_HDR_WORK_U". I disabled that Trigger and tried to edit the NOTE FIELD even though I got the same error.

    I ran the query which you have mentioned It returns 108 rows.

  • Richard Wheeler Profile Picture
    75,850 Moderator on at

    I would give this a try first. Start simple and then move onto more exotic techniques.

    support.microsoft.com/.../a-batch-is-held-in-the-posting-receiving-busy-marked-locked-or-edited

  • Suggested answer
    Alejandro Lopez Profile Picture
    15 on at

    Hello, I had the same problem when I inserted rows in the SY03900, I was doing that including milliseconds in the TIME1 column. You can fix the problem by updating the rows by removing ms:

    update SY03900 set TIME1 = dateadd(ms, - datepart(ms, TIME1), TIME1) where TIME1 != dateadd(ms, - datepart(ms, TIME1), TIME1)

    The error message occurs because when GP update the row validates that TIME1 column match the value it had previously read (without ms).

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans