Finance | Project Operations, Human Resources, ...

How modify existing feild in table using extension - D365FO

(0) Share

Report

Posted on by Akbar Pasha

1,505

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)

All responses (3)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
GnaneswaranKrishnaram 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No