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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How modify existing fe...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How modify existing feild in table using extension - D365FO

(0) ShareShare
ReportReport
Posted on by Akbar Pasha 1,540
Hi All,
 
We need to modify the existing field in /GeneralJournalAccountEntry/ by multiplying by some value, this is not the new field where we can write a display method in table extension, 
How we can write a piece of code for an existing table field modification. 
 
Please advice.
 
Regards,
Akbar
I have the same question (0)
  • Suggested answer
    GirishS Profile Picture
    GirishS 27,829 Moderator on at
    Hi Akbar,
     
    For the existing record in GeneralJournalAccountEntry table you need to write script to update the new field value.
    For the new records creation my suggestion will be adding the code in both insert and update event handlers of the table to save the value as you want with some calculations.
     
    Thanks,
    Girish S.
  • GnaneswaranKrishnaram Profile Picture
    GnaneswaranKrishnaram 4 on at
    Create a code extension for the table GeneralJournalAccountEntry and write coc methods for insert and update
    For existing records, you may need to write a job to update the values. 
     
    Thanks
    Gnaneswaran
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,727 Super User 2026 Season 1 on at
    Hi Akbar,
     
    Can you tell us about the business requirement and purpose? Do you need to update existing records? If so, this is not allowed as the table GeneralJournalAccountEntry represents posted transactions. It is not allowed to change posted transactions due to international accounting rules. Next to this, there is a high risk of creating inconsistencies which would lead to data corruption.

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

News and Announcements

Introducing our New Video Series: Community Spotlight

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!

Congratulations to the January Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Martin Dráb 207 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans