Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / grid field won't u...
Microsoft Dynamics AX (Archived)

grid field won't update

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear All,

I have a field called Note on an extension table of SalesTable, SalesTable_DIE. So this field has 1 value for 1 SO. I also have a form, the Picking List Jornal (Accounts receivable/Common/Sales orders/All sales orders, Pick and pack tab, Journals group, Picking list). This shows multiple lines for the same SO. On these lines I want to show the value of the aforementioned Note field.2072.update.png

It works up to this point, but when I edit the Note field on a certain line, it doesn't update on the others - as You can see on the screenshot, even though the Note value changes on the table and also the form datasource. It only updates if I press F5. I tried multiple things all to no avail.

Thanks for the help.

Gabor

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: grid field won't update

    Finally solved it. The problem was, that the fields on the lines in the grid were from WMSPickingRoute table, but the Note field was from an extension table for SalesTable (both being datasources on the form). Every method I tried to call I did it for the extension table, but I had to call them for the other one. So in the end WMSPickingRoute_DS.executeQuery() worked for me.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: grid field won't update

    Thanks for the reply. My write() looks like this now but still does'nt work.

    2671.Untitled2.png

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: grid field won't update

    Override the write() method on the formdatasource, and call a FormDataSource_ds.research(true) to refresh the records (after saving the current value by calling super()) on the line, while also retaining the current cursor position.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans